package com.netshop;

import java.sql.*;

public class OpenDB
{
    
    String userName="root";
    String userPassword="123456";  
    private String driverName = "org.gjt.mm.mysql.Driver";
    private String url = "jdbc:mysql://localhost/netshop?useUnicode=true&characterEncoding=gb2312";

    Connection dbConn;
    public OpenDB()
    {

    }
    public Connection getConnection()
    {
        try
        {
            Class.forName(driverName);
            dbConn=DriverManager.getConnection(url,userName,userPassword);
        }
        catch(Exception ex)
        {
            System.out.println(ex.toString());
            dbConn = null;
        }
       
        return dbConn;
    }

}