数据库类型:SQL Server2000
切记,不要忘了加驱动包!
DB.java
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class DB {
- private static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=UserInfo";
- //数据库路径:服务器所在的计算机为localhost:1433;
- //数据库名称:UserInfo
- private static final String UserName = "xsy"; //用户名称
- private static final String PassWord = "xsy123"; //用户密码
- private static Connection conn = null;
- public static Connection getConnection(){
- try {
- Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //加载驱动程序
- conn = DriverManager.getConnection(URL, UserName, PassWord); //创建数据库连接
- } catch (SQLException e) {
- e.printStackTrace();
- } <