package MyBean;
import java.sql.*;
public class dbcon
{
	  private String user="sa";
	  private String password="";
	  private String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
	  private String connectURL="jdbc:odbc:CityBus";
	  private Connection conn=null;
	  private Statement stmt=null;
	  private ResultSet rs=null;
	
	public dbcon()
	{

		try{
			Class.forName(driverName);
			conn=DriverManager.getConnection(connectURL,user,password);
			conn.setAutoCommit(true);
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			
			
		}
		catch(Exception e)
		{
			System.out.println("數(shù)據(jù)庫連接錯(cuò)誤"+e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql)
	{
		try{
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex)
		{
			System.out.println("數(shù)據(jù)庫查詢錯(cuò)誤"+ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql)
	{
		try{
			int i=stmt.executeUpdate(sql);
                     return i;
		   }
		catch(SQLException ex)
		{
			System.out.println("執(zhí)行更新錯(cuò)誤："+ex.getMessage());
			return -1;
		}
	}
	public Connection getcon()
	{
		return conn;
	}
}