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