package dbConn;

import java.sql.*;
import java.io.*;
import java.util.*;
import javax.naming.*;


public class dbConn{
Connection conn = null; 
CallableStatement stmtpro = null;
Statement stmt=null;
ResultSet rs = null;
public dbConn(){
try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=td;user=td;password=td");
} catch(java.lang.SecurityException se) {
throw se;
} catch(java.lang.Exception e) {
e.printStackTrace();
}
}
//數據處理
public ResultSet executeQuery(String sql){
stmt=null;
rs = null;
try {        
     stmt=conn.createStatement();                                                 
     rs=stmt.executeQuery(sql);
     } catch(SQLException ex){
       System.err.println("sql_data.executeUpdate:"+ex.getMessage());
     //顯示數據庫連接錯誤或者查詢錯誤 
                             }   
     return rs;                          
    }
//數據更新
public int executeUpdate(String sql){
stmt=null;	
int number = 0;
try {
       stmt=conn.createStatement();    
       stmt.executeUpdate(sql);
       if (conn==null) { return -1; }
       if (stmt == null) { return -1; }
        } 
catch(SQLException ex){
       System.err.println("sql_data.executeUpdate:"+ex.getMessage());
       return -1;
        }
       return number;
    }
    
    public String executeProcedure(String BHMC){
stmtpro = null;
String BH=null;
String sql=null;
sql="{ call P_NB_BH(?,?)}";
try {    
     stmtpro=conn.prepareCall(sql);                                                 
     stmtpro.setString(1,BHMC);
     stmtpro.registerOutParameter(2,Types.CHAR);
     stmtpro.executeUpdate();
     BH = stmtpro.getString(2);
     } catch(SQLException ex){
       System.err.println("sql_data.executeUpdate:"+ex.getMessage());
     //顯示數據庫連接錯誤或者查詢錯誤 
                             }   
     return BH;
}

//關閉數據源，斷開連接
public boolean close(){
try{
if(this.rs!=null){
this.rs.close();
} 
if(stmt!=null){
this.stmt.close();
}
if(stmtpro!=null){
this.stmtpro.close();
}
if(conn!=null){
this.conn.close();
}
return true;
}catch(Exception err){
return false;
}
}

public String show(String str){
	String str1="";
	if(str.compareTo("1")==0){
		str1="\u221A";
	}else{
		str1=" ";
	}
	return str1;
}
    
}