连接sqlserver2000用的字符串连接
发布时间:2020-12-12 13:54:05 所属栏目:MsSql教程 来源:网络整理
导读:static Connection conn;protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"+ "DatabaseName=db_database28;SelectMethod=Cursor";prot
static Connection conn; protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;" + "DatabaseName=db_database28;SelectMethod=Cursor"; protected static String dbUser = "sa"; protected static String dbPwd = ""; static { try { if (conn == null) { Class.forName(dbClassName).newInstance(); conn = DriverManager.getConnection(dbUrl,dbUser,dbPwd); } } catch (ClassNotFoundException e) { e.printStackTrace(); JOptionPane.showMessageDialog(null,"请将SQL Server 2000的JDBC驱动包复制到lib文件夹中。"); System.exit(-1); } catch (Exception e) { e.printStackTrace(); } } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |