JSP项目

package mypackage; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class DBConnectionManager { //驱动程序 private String driverName = "com.mysql.jdbc.Driver"; //设置数据库连接URL private String url = "jdbc:mysql://localhost:3306/shou"; private String user = "root"; private String password = "123456"; public Connection getConnection() { try { Class.forName(driverName); return DriverManager.getConnection(url,user,password); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); return null; } } public String getDriverName() { return driverName; } public void setDriverName(String driverName) { this.driverName = driverName; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } public String getUser() { return user; } public void setUser(String user) { this.user = user; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } // public ResultSet getDateBydate(String date) { // ResultSet rs=null; // try { // Class.forName(driverName); // //构造数据库连接URL // //String connectionUrl = "jdbc:mysql://localhost:3306/shou;database=shou;user=root;password=root"; // //获取数据库连接 // Connection con = DriverManager.getConnection(url,user,password); // // // String sql="select * from record where date="+ date+"order by date desc"; // Statement smt=con.createStatement(); // rs=smt.executeQuery(sql); // } // catch (Exception e) { // e.printStackTrace(); // } // // return rs; // // } }