package dbms;
import java.sql.*;
public class Conn
{
	private String _username;
	private String _password;
	private String _driver;
	private String _dburl;
	private Connection _con;
	private Statement _stmt;
//	ResultSet rset=null;

	public Conn()
	{
		_dburl="jdbc:odbc:bookstore";
		_username="huahua";
		_password="binbin";
		_driver="sun.jdbc.odbc.JdbcOdbcDriver";
	}

	public Conn(String driver,String dburl,String username,String password)
	{
		_driver=driver;
		_dburl=dburl;
		_username=username;
		_password=password;
	}


	//獲得數據集
//	public ResultSet getDbResultSet(String sql)
	public ResultSet executeQuery(String sql)
	{
		ResultSet rset=null;
		try
		{
			Class.forName(_driver);
			_con=DriverManager.getConnection(_dburl,_username,_password);
			_stmt=_con.createStatement();
			rset=_stmt.executeQuery(sql);
		}catch(Exception e){System.out.print("Query Error!!!!!!!!!");}
		return rset;
	}



	/*public boolean updateDb(String sql)
	{
	boolean flag=false;
	try
		{
			Class.forName(_driver);
			_con=DriverManager.getConnection(_dburl,_username,_password);
			_stmt=_con.createStatement();
			flag=Boolean.valueOf(int.valueOf(_stmt.executeUpdate(sql)));
			//_stmt.executeUpdate(sql);
		}catch(Exception e){System.out.print("Update Error!!!!!!!!!");}
		return flag;
	}*/
	

	
	//修改、插入、刪除
	public void updateDb(String sql)
	{
	//boolean flag=false;
	try
		{
			Class.forName(_driver);
			_con=DriverManager.getConnection(_dburl,_username,_password);
			_stmt=_con.createStatement();
			//flag=Boolean.valueOf(int.valueOf(_stmt.executeUpdate(sql)));
			_stmt.executeUpdate(sql);
		}catch(Exception e){System.out.print("Update Error!!!!!!!!!");}
		//return flag;
	}
};