package org.pan.util;

import java.sql.*;

/**
 * Title:       數(shù)據(jù)庫連接管理器
 * Description:
 * Copyright:    Copyright (c) 2003
 * @author:		 linlin
 * @version 1.0
 */

public class DBConnectionManager {
//    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  //"oracle.jdbc.driver.OracleDriver";
//    private String url = "jdbc:microsoft:sqlserver://localhost:1433";  //"jdbc:oracle:thin:@127.0.0.1:1521:oracle";
    private String user = "WageManager";
    private String password = "WageManager";

    private String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
    private String url = "jdbc:odbc:WageSystem";
 
    public void setDriverName(String newDriverName) {
        driverName = newDriverName;
    }
    public String getDriverName() {
        return driverName;
    }
	
    public void setUrl(String newUrl) {
        url = newUrl;
    }
    public String getUrl() {
        return url;
    }
    public void setUser(String newUser) {
        user = newUser;
    }
    public String getUser() {
        return user;
    }
    public void setPassword(String newPassword) {
        password = newPassword;
    }
    public String getPassword() {
        return password;
    }

    public Connection getConnection() {
        try {
            Class.forName(driverName);
        //    return DriverManager.getConnection(url, user, password);
            return DriverManager.getConnection(url);
        }
        catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }

    public static void main(String[] args) {
       // DBConnectionManager DBConnectionManager1 = new DBConnectionManager();


		  try{
		
			  DBConnectionManager dcm = new DBConnectionManager();
			  Connection	conn = dcm.getConnection();
		    Statement stmt=conn.createStatement();
		    ResultSet rs=stmt.executeQuery("select * from admin");
		    
			
		//	stmt = conn.createStatement();

		    while(rs.next()){
				  System.out.print("登陸帳號: "+rs.getString(0));
				  System.out.print("\tpassword: "+rs.getString(1));
				  System.out.println();
		    }
			//stmt.executeUpdate( "insert into my.txt values ('Ruby',27,'網(wǎng)絡(luò)部')");		    //*/
		  }catch(Exception e){
		    e.printStackTrace();
		  }
    }
}		//stmt.executeUpdate( "insert into my.txt values ('Ruby',27,'網(wǎng)絡(luò)部')");		    //*/