?? sqlbean.java
字號:
package stu;
import java.io.*;
import java.sql.*;
public class sqlBean{///
public Connection conn=null;
public ResultSet rs=null;
private String DatabaseDriver="sun.jdbc.odbc.JdbcOdbcDriver";
//DataSource 數據源名稱DSN
private String DatabaseConnStr="jdbc:odbc:ClassDB2,'sa',shift";
//定義方法
/*setXxx用于設置屬性值;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(){/////構造函數
try{
Class.forName(DatabaseDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("加載驅動器有錯誤:"+e.getMessage( ));
System.out.print("執行插入有錯誤:"+e.getMessage());//輸出到客戶端
}
}
public String getString(String name) throws SQLException{
if(rs==null) throw new SQLException("ResultSet is null");
return String.valueOf(rs.getString(name));
}
public void executeInsert(String sql){
try{
conn = DriverManager.getConnection("jdbc:odbc:ClassDB","sa","shift");
Statement stmt=conn.createStatement( );
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("執行插入有錯誤:"+ex.getMessage() );
System.out.print("執行插入有錯誤:"+ex.getMessage());//輸出到客戶端
}
}
// display data
public ResultSet executeQuery(String sql){
rs=null;
try{
conn = DriverManager.getConnection("jdbc:odbc:ClassDB","sa","shift");
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("執行查詢有錯誤:"+ex.getMessage() );
System.out.print("執行查詢有錯誤:"+ex.getMessage()); //輸出到客戶端
}
return rs;
}
// delete data
public void executeDelete(String sql){
try{
conn = DriverManager.getConnection("jdbc:odbc:ClassDB","sa","shift");
Statement stmt=conn.createStatement( );
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("執行刪除有錯誤:"+ex.getMessage() );
System.out.print("執行刪除有錯誤:"+ex.getMessage()); //輸出到客戶端
}
}
//////////////////
public void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("執行關閉Connection對象有錯誤:"+end.getMessage( ) );
System.out.print("執行執行關閉Connection對象有錯誤:有錯誤:"+end.getMessage()); //輸出到客戶端
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -