packagecom.comm;importjava.sql.*;importjavax.swing.JOptionPane;publicclassConnDb{privateStringdbURL="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=lib";privateSt...
package com.comm;
import java.sql.*;
import javax.swing.JOptionPane;
public class ConnDb {
private String dbURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=lib";
private String user = "sa";
private String password = "sa";
public Connection conn;
public ResultSet rs1 ;
private PreparedStatement ps1;
private Statement st1;
//连接数据库
public Connection getConnection(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("驱动成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("驱动失败!");
}
try {
conn=DriverManager.getConnection(dbURL,user,password);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
new ConnDb().getConnection();
}
}
展开