package org.pan.util;import java.sql.*;/** * Title:       數據庫連接管理器 * Description: * Copyright:    Copyright (c) 2003 * Company:      多智能網絡有限公司 * @author:		 siny pan * @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 = "bookshop";    private String password = "bookshop";    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);        }        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 my_BookAdminuser");		    					//	stmt = conn.createStatement();		    while(rs.next()){				System.out.print("名稱: "+rs.getString(1));				System.out.print("\tpassword: "+rs.getString(2));				System.out.println();		    }			//stmt.executeUpdate( "insert into my.txt values ('Ruby',27,'網絡部')");		    //*/		}catch(Exception e){		    e.printStackTrace();		}    }}