?? sqlbean.java
字號:
package result;
import java.io.*;
import java.sql.*;
public class sqlBean {// /
public Connection conn = null;
public ResultSet rs = null;
private String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
// DataSource 數(shù)據(jù)源名稱DSN
private String DatabaseConnStr = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ClassDB,'sa',318";
// 定義方法
/* setXxx用于設(shè)置屬性值;getXxx用于得到屬性值 */
public void setDatabaseDriver(String Driver) {
this.DatabaseDriver = Driver;
}
public String getDatabaseDriver() {
return (this.DatabaseDriver);
}
public void setDatabaseConnStr(String ConnStr) {
this.DatabaseConnStr = ConnStr;
}
public String getDatabaseConnStr() {
return (this.DatabaseConnStr);
}
public sqlBean() {// ///構(gòu)造函數(shù)
try {
Class.forName(DatabaseDriver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println("加載驅(qū)動(dòng)器有錯(cuò)誤:" + e.getMessage());
System.out.print("執(zhí)行插入有錯(cuò)誤:" + e.getMessage());// 輸出到客戶端
}
}
public int executeInsert(String sql) {
int num = 0;
try {
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ClassDB", "sa",
"318");
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println("執(zhí)行插入有錯(cuò)誤:" + ex.getMessage());
System.out.print("執(zhí)行插入有錯(cuò)誤:" + ex.getMessage());// 輸出到客戶端
}
CloseDataBase();
return num;
}
// display data
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ClassDB", "sa",
"318");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("執(zhí)行查詢有錯(cuò)誤:" + ex.getMessage());
System.out.print("執(zhí)行查詢有錯(cuò)誤:" + ex.getMessage()); // 輸出到客戶端
}
return rs;
}
// delete data
public int executeDelete(String sql) {
int num = 0;
try {
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ClassDB", "sa",
"318");
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println("執(zhí)行刪除有錯(cuò)誤:" + ex.getMessage());
System.out.print("執(zhí)行刪除有錯(cuò)誤:" + ex.getMessage()); // 輸出到客戶端
}
CloseDataBase();
return num;
}
// ////////////////
public void CloseDataBase() {
try {
conn.close();
} catch (Exception end) {
System.err.println("執(zhí)行關(guān)閉Connection對象有錯(cuò)誤:" + end.getMessage());
System.out.print("執(zhí)行執(zhí)行關(guān)閉Connection對象有錯(cuò)誤:有錯(cuò)誤:" + end.getMessage()); // 輸出到客戶端
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -