static {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String user="sa";
String pwd="123";
//JDBC连接方式
String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=name ";
//注册驱动
//DriverManager.registerDriver (new com.microsoft.sqlserver.jdbc.SQLServerDriver());
//获得一个连接
conn = DriverManager.getConnection (url,user,pwd);
//JOptionPane.showMessageDialog (null, "连接成功");
// 设置自动提交为false
conn.setAutoCommit (false);
//建立高级载体
ste = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
}
catch (Exception ex) {
JOptionPane.showMessageDialog (null, "数据库连接失败...", "错误", JOptionPane.ERROR_MESSAGE);
ex.printStackTrace();
}
}