dboperatorhandle.java

这是我们做的一个网上购物系统,包手用户和管理员两大功能模块,采用jsp+servlet+java bean技术.

package com.qyg.database;

import java.sql.*;

import com.mysql.jdbc.Driver;

public class DbOperatorHandle {
	private String Mysql_Driver="com.mysql.jdbc.Driver";
	private String Mysql_Url="jdbc:mysql://localhost:3306/shop?useUnicode=true&characterEncoding=gbk";
	private Connection con=null;

	public DbOperatorHandle(){
		
	}
	
	public Connection getCon(){
		try{
			//注册驱动
			Class.forName(Mysql_Driver);
			//连接驱动程序
			con = DriverManager.getConnection(Mysql_Url,"root","root");
		}catch(Exception e){
			System.out.print("数据库连接错误");
		}
		return con;
	}
	public void closeCon(){
		if (con != null) {
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
}