?? databasemanager.java~11~
字號:
import java.sql.*;
public class DataBaseManager {
Connection con;
ResultSet rs;
Statement stmt;
public DataBaseManager() {
try {
// String url = "jdbc:odbc:LibraryBase";
String url = "jdbc:odbc:LibManagement";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
}
catch (SQLException sqle) {
System.out.println(sqle.toString());
}
catch (ClassNotFoundException cnfex) {
cnfex.printStackTrace();
}
}
public ResultSet getResult(String strSQL) {
try {
rs = stmt.executeQuery(strSQL);
return rs;
}
catch (SQLException sqle) {
System.out.println(sqle.toString());
return null;
}
}
public int updateSql(String strSQL) {
try {
int i=stmt.executeUpdate(strSQL);
con.commit();
return i;
}
catch (SQLException sqle) {
System.out.println(sqle.toString());
return -1;
}
}
public void closeConnection() {
try {
con.close();
}
catch (SQLException sqle) {
System.out.println(sqle.toString());
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -