java毕业设计之咖啡馆管理系统源码（前后端完整源代码）.zip

package db; import java.sql.*; public class db { private String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; private String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;databasename=kafeiguanli"; //private String dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //sql2005 //private String sConnStr ="jdbc:sqlserver://WHL_PC\\SQLEXPRESS:1433;database=jspchaoshixns"; public Connection connect = null; public ResultSet rs=null; public db() { try { Class.forName(dbDriver).newInstance(); connect = DriverManager.getConnection(sConnStr,"sa",""); } catch (Exception ex) { System.out.println("12121"); } } public ResultSet executeQuery(String sql) { try{ connect=DriverManager.getConnection(sConnStr,"sa",""); Statement stmt=connect.createStatement(); rs=stmt.executeQuery(sql); }catch(SQLException ex){ System.err.println(ex.getMessage()); } return rs; } public void executeUpdate(String sql) { Statement stmt=null; rs=null; try { connect=DriverManager.getConnection(sConnStr,"sa",""); stmt=connect.createStatement(); stmt.executeUpdate(sql); stmt.close(); connect.close(); } catch(SQLException ex) { System.err.println(ex.getMessage()); } } }