java.sql.*
; publicclass DBBean { privateString driverStr = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
; privateString connStr = "jdbc:sqlserver://localhost:1433; DatabaseName=JXP"
; privateString dbusername = "sa"
; privateString dbpassword = "123456"
; privateConnection conn =
null; privateStatement stmt =
null; public DBBean() { try { Class.forName(driverStr); conn=
DriverManager.getConnection(connStr, dbusername, dbpassword); stmt=
conn.createStatement(); } catch (Exception ex) { System.out.println("数据连接失败!"
); } } publicint executeUpdate(String s) { intresult = 0
; System.out.println("--更新语句:"+s+"\n"
); try { result=
stmt.executeUpdate(s); } catch (Exception ex) { System.out.println("执行更新错误!"
); } return result; } public ResultSet executeQuery(String s) { ResultSet rs=
null; System.out.print("--查询语句:"+s+"\n"
); try { rs=
stmt.executeQuery(s); } catch (Exception ex) { System.out.println("?执行查询错误!"
); } return rs; } publicvoid execQuery(String s){ try { stmt.executeUpdate(s); } catch (SQLException e) { // TODO Auto-generated catch blockSystem.out.println("执行插入错误!"
); } } publicvoid close() { try { stmt.close(); conn.close(); } catch (Exception e) { } } }来源: http://www.bubuko.com/infodetail-1958639.html