public class JDBConnection {
private final String url = "jdbc:jtds:sqlserver://192.168.100.91:1433/itzcgl";
private final String userName = "itzcgly";
private final String password = "itadmin#";
private Connection con = null;
// 通过构造方法加载数据库驱动
static {
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
// 创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true);
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
