?? databaseconnection.java
字號:
package conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;
public class DataBaseConnection
{
String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl =
"jdbc:sqlserver://localhost:1433;DatabaseName=xsglDatabase";
String dbUser = "sa";
String dbPassword = "";
Connection con = null;
ResultSet rs = null;
PreparedStatement prepStmt = null;
public DataBaseConnection() {
try {
Class.forName(drivrename);
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
}
}
public Connection getConnection() {
Connection con;
try {
Class.forName(drivrename);
con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
return con;
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
} catch (SQLException er) {
System.err.println(er.getMessage());
}
return null;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -