一个jsp好玩的例子

package com.ts.dbase; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.jsp.jstl.sql.Result; import javax.servlet.jsp.jstl.sql.ResultSupport; public class DBase { private String clstr = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private String constr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=movedb"; private Connection con; private PreparedStatement stam; private ResultSet rs; public Connection getConnection() { try { Class.forName(clstr); con = DriverManager.getConnection(constr, "sa", ""); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return con; } public void getClose() { try { if (rs != null) rs.close(); if (stam != null) stam.close(); if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } public void bindingParam(Object... objects) throws SQLException { for (int i = 0; i < objects.length; i++) { stam.setObject(i + 1, objects[i]); } } public boolean executeUpdate(String sql, Object... objects) { if (con == null) con = this.getConnection(); try { stam = con.prepareStatement(sql); this.bindingParam(objects); return stam.executeUpdate() > 0; } catch (SQLException e) { e.printStackTrace(); } finally { this.getClose(); } return false; } public Result executeQuery(String sql, Object... objects) { if (con == null) con = this.getConnection(); try { stam = con.prepareStatement(sql); this.bindingParam(objects); rs = stam.executeQuery(); return ResultSupport.toResult(rs); } catch (SQLException e) { e.printStackTrace(); } return null; } }