package com.database;

import java.sql.*;
/**
 *在連接數據庫時，需要加載驅動程序、創建連接等操作
 *這里將連接數據庫的這些操作封裝成一個類
 *當需要更換、移植數據庫時，只修改這個類即可
 */
public class DBConnection {
//	加載驅動程序
	private String driverName="com.mysql.jdbc.Driver";
//設置數據庫連接字串
	private String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";
//數據庫登錄用戶名	
	//private String userid="";
//數據庫登錄密碼	
	//private String passwd="";
	
	public String getDriverName() {
		return driverName;
	}
	public String getUrl() {
		return url;
	}
	/*public String getPasswd() {
		return passwd;
	}
	public String getUser() {
		return user;
	}*/
	public Connection getConnection(){
		try{
			Class.forName(driverName);
			return DriverManager.getConnection(url);			
			//return DriverManager.getConnection(url,userid,passwd);
		}catch(Exception e){
			System.out.println("無法載入"+driverName+"驅動程序!");
			e.printStackTrace();
			return null;
		}
	}
	
	/*public static void main(String args[]){
		try{
			String sql="select * from my_users";
			DBConnection dc=new DBConnection();
			Connection conn=dc.getConnection();
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){
				System.out.print("名稱"+rs.getString("UserName"));
				System.out.print("密碼"+rs.getString("PassWord"));
				System.out.println();
			}				
		}catch(Exception e){
			e.printStackTrace();
		}
	}*/
}