package com.mali.dao;
import java.sql.*;

public class DBHelper {
	Connection conn = null;
	public void getCon(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Test","sa","liuqian");
		} catch (ClassNotFoundException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}
		}
	public void closeCon(){
		try {
			if(conn != null){
				conn.close();
				conn = null;
			}
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}
	}
	public int executeNonQuery(String sql){
		int result = 0;
		getCon();
		try {
			Statement st = conn.createStatement();
			result = st.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}finally{
			closeCon();
		}
		return result;
		
	}
	public ResultSet executeQuery(String sql){
		ResultSet rs = null;
		getCon();
		try {
			Statement st = conn.createStatement();
			rs = st.executeQuery(sql);
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}
		return rs;
	}
	
}