From a1a18f77a50804e0127dfa4b0f5240c49c541184 Mon Sep 17 00:00:00 2001 From: Scott Jackson Date: Mon, 2 Jul 2012 21:24:02 -0700 Subject: Initial Commit --- .../subsonic/controller/DBController.java | 66 ++++++++++++++++++++++ 1 file changed, 66 insertions(+) create mode 100644 subsonic-main/src/main/java/net/sourceforge/subsonic/controller/DBController.java (limited to 'subsonic-main/src/main/java/net/sourceforge/subsonic/controller/DBController.java') diff --git a/subsonic-main/src/main/java/net/sourceforge/subsonic/controller/DBController.java b/subsonic-main/src/main/java/net/sourceforge/subsonic/controller/DBController.java new file mode 100644 index 00000000..17d06497 --- /dev/null +++ b/subsonic-main/src/main/java/net/sourceforge/subsonic/controller/DBController.java @@ -0,0 +1,66 @@ +/* + This file is part of Subsonic. + + Subsonic is free software: you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation, either version 3 of the License, or + (at your option) any later version. + + Subsonic is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Subsonic. If not, see . + + Copyright 2009 (C) Sindre Mehus + */ +package net.sourceforge.subsonic.controller; + +import net.sourceforge.subsonic.dao.DaoHelper; +import org.apache.commons.lang.exception.ExceptionUtils; +import org.springframework.dao.DataAccessException; +import org.springframework.jdbc.core.ColumnMapRowMapper; +import org.springframework.web.servlet.ModelAndView; +import org.springframework.web.servlet.mvc.ParameterizableViewController; + +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +/** + * Controller for the DB admin page. + * + * @author Sindre Mehus + */ +public class DBController extends ParameterizableViewController { + + private DaoHelper daoHelper; + + protected ModelAndView handleRequestInternal(HttpServletRequest request, HttpServletResponse response) throws Exception { + Map map = new HashMap(); + + String query = request.getParameter("query"); + if (query != null) { + map.put("query", query); + + try { + List result = daoHelper.getJdbcTemplate().query(query, new ColumnMapRowMapper()); + map.put("result", result); + } catch (DataAccessException x) { + map.put("error", ExceptionUtils.getRootCause(x).getMessage()); + } + } + + ModelAndView result = super.handleRequestInternal(request, response); + result.addObject("model", map); + return result; + } + + public void setDaoHelper(DaoHelper daoHelper) { + this.daoHelper = daoHelper; + } +} -- cgit v1.2.3