dao.java

java sql jsp javabean

package com.gc.dao;

import java.sql.*;

public class dao {
	
	private Connection con = null;
	
	/**
	 * 实现数据库连接的类
	 */
	public dao()
	{
		String dbURL = "jdbc:mysql://localhost/Shopper";
		String driverName = "org.gjt.mm.mysql.Driver";
		String userName = "root";       //SQL用户名
		String userPwd = "Configer1";  //SQL密码
		try
		{
			Class.forName(driverName); //加载JDBC驱动
			con = DriverManager.getConnection(dbURL,userName,userPwd);//连接数据库和服务器
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public Connection getCon()
	{
		return con;
	}
}