jsp开发企业进销存开发系统

package db; import java.sql.*; public class DBCon { private static String driver = "com.mysql.jdbc.Driver"; private static String url = "jdbc:mysql://localhost:3306/ims"; private static Connection con = null; private static ResultSet rs = null; private static int rs2 = 0; private static Statement st = null; public ResultSet getResult(String sql) { try { Class.forName(driver); con = DriverManager.getConnection(url, "root", "123"); st = con.createStatement(); rs = st.executeQuery(sql); } catch (Exception e) { System.err.println("出现异常:"+e.getMessage()); } return rs; } public int update(String sql) { try { Class.forName(driver); con = DriverManager.getConnection(url, "root", "123"); st = con.createStatement(); rs2 = st.executeUpdate(sql); } catch (Exception e) { System.err.println(e.getMessage()); } return rs2; } /* public static void main(String[] args) throws SQLException { String supplierName = "n"; String address = "dfs"; String phone ="3243"; String supplierId = "23"; String sql = "update supplier set supplierName='"+supplierName+"' , "+ "set address = '"+address+"' , set phone = '"+phone+"' where supplierId = '"+supplierId+"' "; new DBCon().update(sql); con.close(); //rs.close(); }*/ }