dbconnectionmanager.java

基于JSP MYSQL开发的网上书店系统

package org.pan.util;

import java.sql.*;

/**
 * Title:       数据库连接管理器
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      多智能网络有限公司
 * @author:		 siny pan
 * @version 1.0
 */

public class DBConnectionManager {
    
	//Oracle
	/*
    private String driverName = "oracle.jdbc.driver.OracleDriver"; 
    private String url = "jdbc:oracle:thin:@localhost:1521:book";  
    private String user = "book";
    private String password = "book";
	*/


	//SQLServer
	/*
	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";
	*/
	
	//MySql
    private String driverName = "org.gjt.mm.mysql.Driver"; 
    private String url = "jdbc:mysql://localhost:3306/business?useUnicode=true&characterEncoding=GBK";  
    private String user = "root";
    private String password = "";

    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();
		}
    }
}