JavaWeb与数据库综合设计_宿舍管理系统源码

package student; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class DBConnect { public Statement stmt = null; public static Connection getConnection(){ Connection con=null; try { Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost:3306/sushe?useUnicode=true&characterEncoding=UTF-8"; String user="root"; String password="111"; con=DriverManager.getConnection(url, user, password); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return con; } public ResultSet DBQuery(String sqlText) { Connection conn1=null; ResultSet rs=null; java.sql.Statement stmt=null; try{ conn1=getConnection(); stmt=conn1.createStatement(); rs=stmt.executeQuery(sqlText); } catch(Exception x){ x.printStackTrace(); } return rs; } public int DBUpdate(String sqlText){ Connection conn=null; int rowcount=0; try{ conn=getConnection(); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rowcount=stmt.executeUpdate(sqlText); }catch(Exception x){ x.printStackTrace(); } return rowcount; } }