database.java

这个是我自己写的网上书店的管理系统

package util;

import java.sql.*;

public class Database   //数据库的连接
{
	public Connection conn;
	public Statement sm;
	public ResultSet rs=null;
	public String sqlStr="";
	private String dbName="bookstore";
	private String userName="root";
	private String pwd="123456";
	private String driverName="com.mysql.jdbc.Driver";
	private String url="";
	
	public Database()
	{
		this.connect();
	}

	public boolean connect()
	{
		// TODO 自动生成方法存根
		try
		{
			//注册驱动程序
			Class.forName(driverName).newInstance();
			url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+pwd+"&characterEncoding=gb2312";  //连接字符串
			conn=DriverManager.getConnection(url);
	        sm=conn.createStatement();
		}
		catch(Exception ex)
		{
			System.out.println("数据库连接失败！");
			return false;
		}
		return true;
	}
	
	public static void main(String[] args)
	{
		try
		{
			Database db=new Database();
			db.connect();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	

}