basesql.java

简单的餐厅管理系统

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BaseSQL {
	public Connection connection = null;

	public Statement statement = null;

	ResultSet rs = null;

	public void connect(String datebase, String userName, String password) throws SQLException,Exception{ //
			String cstr = "jdbc:mysql://localhost:3306/"+datebase+"?useUnicode=true&characterEnconding=GBK";
			
	//		System.out.println("正在加载");
			Class.forName("com.mysql.jdbc.Driver").newInstance();
	//		System.out.println("加载完成");
			connection = DriverManager.getConnection(cstr, userName, password);
	//		System.out.println("连接");
			statement = connection.createStatement();
	//		System.out.println("获得statement");
			if(statement == null){
				System.out.println("不能连接");
			}
	}
	
	public void close() throws SQLException{
			if (statement != null)
				statement.close();
			if (connection != null)
				connection.close();
	}
}