superdbconn.java

关于商品的进、销、存管理系统

package superdb;
import java.sql.*;
public class SuperDBConn {
	private String user;
	private String password;
	private String driver;
	private String url;
	private Connection conn;
	public SuperDBConn()
	{
		this.user="root";
		this.password="root";
		this.driver="com.mysql.jdbc.Driver";
		this.url="jdbc:mysql://127.0.0.1/supershop?user="+user+"&password="+password+
		"&useUnicode=true&characterEncoding=utf8";//CharacterEncoding
		
	}
	//创建连接对象
	public Connection getConn()
	{
		if(conn==null)
		{
			try
			{
			Class.forName(driver);
			conn=DriverManager.getConnection(url);
			System.out.println("创建连接--成功");
			}catch(Exception e)
			{
				e.printStackTrace();
				System.out.println("创建连接--失败!!!!");
				return null;
			}
		}
		return conn;
	}
	//关闭连接对象
	public void closeConn()
	{
		if(conn!=null)
		{
			try
			{
			conn.close();
			conn=null;
			System.out.println("关闭连接--成功");
			}catch(Exception e)
			{
				System.out.println("关闭连接--失败!!!");
			}
		}
	}
	public String getDriver() {
		return driver;
	}
	public void setDriver(String driver) {
		this.driver = driver;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public String getUser() {
		return user;
	}
	public void setUser(String user) {
		this.user = user;
	}
	
}