dbconnection.java

超市进销存系统,采用mvc+DAO模式编写

package mybaobao;
import java.sql.*;
public class DBConnection {
	private String Driver="com.mysql.jdbc.Driver";
	private String url="jdbc:mysql://localhost:3306/lvpeng";
	private String user="root";
	private String pass="root";
	private Connection con= null ;
	public DBConnection()
	{
		try {
			Class.forName(Driver);
			con=DriverManager.getConnection(url, user, pass);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public Connection getConnection()
	{
		return this.con ;
	}
	public void close()
	{
		try
		{
			this.con.close() ;
		}
		catch (Exception e)
		{
	    }
	}

}