Servlet使用MVC模式（Dao\Service\Servlet)增删查改

package cn.utils; import java.beans.PropertyDescriptor; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.sql.DataSource; import org.apache.commons.dbutils.ResultSetHandler; /** * 重写QueryRunner * @author 王健 * @version 1.0 2011-04-8 */ public class QueryRunner extends org.apache.commons.dbutils.QueryRunner{ public QueryRunner(){ } public QueryRunner(DataSource d){ super(d); } @Override public int[] batch(Connection arg0, String arg1, Object[][] arg2){ try { return super.batch(arg0, arg1, arg2); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int[] batch(String sql, Object[][] params){ try { return super.batch(sql, params); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected void close(Connection conn) { try { super.close(conn); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected void close(ResultSet rs){ try { super.close(rs); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected void close(Statement stmt){ try { super.close(stmt); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public void fillStatement(PreparedStatement arg0, Object... arg1) { try { super.fillStatement(arg0, arg1); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public void fillStatementWithBean(PreparedStatement arg0, Object arg1, PropertyDescriptor[] arg2){ try { super.fillStatementWithBean(arg0, arg1, arg2); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public void fillStatementWithBean(PreparedStatement arg0, Object arg1, String... arg2) { try { super.fillStatementWithBean(arg0, arg1, arg2); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public DataSource getDataSource() { return super.getDataSource(); } @Override protected Connection prepareConnection() { try { return super.prepareConnection(); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected PreparedStatement prepareStatement(Connection conn, String sql) { try { return super.prepareStatement(conn, sql); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(Connection conn, String sql, Object param, ResultSetHandler<T> rsh) { try { return super.query(conn, sql, param, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(Connection conn, String sql, Object[] params, ResultSetHandler<T> rsh) { try { return super.query(conn, sql, params, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } public <T> T query(Connection arg0, String arg1, ResultSetHandler<T> arg2, Object... arg3){ try { return super.query(arg0, arg1, arg2, arg3); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(Connection conn, String sql, ResultSetHandler<T> rsh) { try { return super.query(conn, sql, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(String sql, Object param, ResultSetHandler<T> rsh) { try { return super.query(sql, param, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(String sql, Object[] params, ResultSetHandler<T> rsh) { try { return super.query(sql, params, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(String sql, ResultSetHandler<T> rsh, Object... params) { try { return super.query(sql, rsh, params); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public <T> T query(String sql, ResultSetHandler<T> rsh){ try { return super.query(sql, rsh); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected void rethrow(SQLException cause, String sql, Object... params) { try { super.rethrow(cause, sql, params); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(Connection arg0, String arg1, Object... arg2) { try { return super.update(arg0, arg1, arg2); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(Connection conn, String sql, Object param) { try { return super.update(conn, sql, param); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(Connection conn, String sql) { try { return super.update(conn, sql); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(String sql, Object... params){ try { return super.update(sql, params); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(String sql, Object param){ try { return super.update(sql, param); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override public int update(String sql) { try { return super.update(sql); } catch (SQLException e) { throw new RuntimeException(e.getMessage(),e); } } @Override protected ResultSet wrap(ResultSet rs) { return super.wrap(rs); } }