package com.yxq.bean;

import java.sql.*;
public class DBO {
	private String URL;
	private String classname;
	private String username;
	private String password;
	
	private Connection con;
	private Statement stm;
	private ResultSet rs;
	
	public DBO(){
		URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_FABD01";
		classname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		username="sa";
		password="";
	}
	
	private void LoadDriver(){
		try{
			Class.forName(classname);
		}catch(ClassNotFoundException e){
			System.out.println("加載驅動程序失?。?quot;);
			e.printStackTrace();
		}
	}
	
	private Connection getCon(){
		LoadDriver();
		try{
			con=DriverManager.getConnection(URL,username,password);
		}catch(Exception e){
			System.out.println("創建數據庫連接失敗！");
			e.printStackTrace();
		}
		return con;
	}
	
	private Statement getStm(){
		getCon();
		try{
			stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);			
		}catch(Exception e){
			System.out.println("創建Statement對象失敗！");
			e.printStackTrace();
		}
		return stm;
	}
	
	public ResultSet getRs(String sql){
		if(sql==null)
			sql="";
		getStm();
		try{
			rs=stm.executeQuery(sql);			
		}catch(Exception e){
			System.out.println("查詢數據庫失敗！");
			e.printStackTrace();
		}			
		return rs;		
	}
	public int update(String sql){
		if(sql==null)
			sql="";
		System.out.println("SQL："+sql);
		getStm();
		int i=-1;
		try{
			i=stm.executeUpdate(sql);
		}catch(Exception e){
			i=-1;
			e.printStackTrace();
		}finally{
			closed();
		}
		return i;
	}
	public void closed(){
		try{
			if(this.rs!=null)
				rs.close();
			if(this.stm!=null)
				stm.close();
			if(this.con!=null)
				con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}

	public String getClassname() {
		return classname;
	}
	public void setClassname(String classname) {
		this.classname = classname;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getURL() {
		return URL;
	}
	public void setURL(String url) {
		URL = url;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
}