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()); //輸出到客戶端 
} 
} 
}