dbconnectionmanager.java

本系统利用JSP+JavaBean+ MySQL数据库三层模式实现了网上书店系统。本论文对系统的需求分析、系统总体架构及详细设计进行了详细地阐述

package org.pan.util;

import java.sql.*;

/**
 * Title:       数据库连接管理器
 *
 * @version 1.0
 */

public class DBConnectionManager {
    private String driverName = "com.mysql.jdbc.Driver"; 
    private String url = "jdbc:mysql://127.0.0.1/bookshop?useUnicode=true&characterEncoding=UTF8"; 
    private String user = "root";
    private String password = "root";

    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("SHOW VARIABLES LIKE 'character_set_%'");
		    
			
		//	stmt = conn.createStatement();

		    while(rs.next()){
            System.out.println(rs.getString(1)+","+rs.getString(2));
        }
        rs.close();

			//stmt.executeUpdate( "insert into my.txt values ('Ruby',27,'网络部')");		    //*/
		}catch(Exception e){
		    e.printStackTrace();
		}
    }
}