package stuman;

import java.io.*;
import java.sql.*;

public class sqlBean {/// 
    public Statement stmt = null;
    public Connection conn = null;
    public ResultSet rs = null;
    private String DatabaseDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//錕斤拷錕藉方錕斤拷 
/*setXxx錕斤拷錕斤拷錕斤拷錕斤拷錕斤拷錕斤拷值;getXxx錕斤拷錕節得碉拷錕斤拷錕斤拷值*/
    public void setDatabaseDriver(String Driver) {
        this.DatabaseDriver = Driver;
    }

    public String getDatabaseDriver() {
        return (this.DatabaseDriver);
    }

    public sqlBean() {/////錕斤拷錕屆函錕斤拷 
        try {
            Class.forName(DatabaseDriver);
        } catch (java.lang.ClassNotFoundException e) {
            System.err.println("錕斤拷錕斤拷錕斤拷錕斤拷錕叫達拷錕斤拷:" + e.getMessage());
            System.out.print("執錕叫詫拷錕斤拷錕叫達拷錕斤拷:" + e.getMessage());//錕斤拷錕酵伙拷錕斤拷 
        }
    }

    public int executeInsert(String sql) {
        int num = 0;
        try {

            conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ClassDB;user=sa;password=");
            Statement stmt = conn.createStatement();
            num = stmt.executeUpdate(sql);
        } catch (SQLException ex) {
            System.err.println("執錕叫詫拷錕斤拷錕叫達拷錕斤拷:" + ex.getMessage());
            System.out.print("執錕叫詫拷錕斤拷錕叫達拷錕斤拷:" + ex.getMessage());//錕斤拷錕酵伙拷錕斤拷 
        }

        CloseDataBase();
        return num;
    }
// display data 
    public ResultSet executeQuery(String sql) {
        try {
            conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ClassDB;user=sa;password=");
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
        }
        return rs;
    }

    public int executeUpdate(String sql) {
        int result = 0;
        try {
            conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ClassDB;user=sa;password=");
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            result = stmt.executeUpdate(sql);
        } catch (SQLException ex) {
            result = 0;
        }
        return result;
    }
    //delete data 
    public int executeDelete(String sql) {
        int num = 0;
        try {
            conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ClassDB;user=sa;password=");

            Statement stmt = conn.createStatement();
            num = stmt.executeUpdate(sql);
        } catch (SQLException ex) {
            System.err.println("執錕斤拷刪錕斤拷錕叫達拷錕斤拷:" + ex.getMessage());
            System.out.print("執錕斤拷刪錕斤拷錕叫達拷錕斤拷:" + ex.getMessage()); //錕斤拷錕酵伙拷錕斤拷 
        }
        CloseDataBase();
        return num;
    }
////////////////// 
    public void CloseDataBase() {
        try {
            conn.close();
        } catch (Exception end) {
            System.err.println("執錕叫關憋拷Connection錕斤拷錕斤拷錕叫達拷錕斤拷" + end.getMessage());
            System.out.print("執錕斤拷執錕叫關憋拷Connection錕斤拷錕斤拷錕叫達拷錕斤拷錕叫達拷錕斤拷:" + end.getMessage()); //錕斤拷錕酵伙拷錕斤拷 
        }
    }
}