myconn.java

来自「JSP+SQL SERVER,酒店管理系统」· Java 代码 · 共 82 行

/*
 * Created on 2007-6-13
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package myhotel;

import java.sql.*;


public class MyConn {
  
  private String dbURL;			//数据库标识名
	private String user;				//数据库用户
	private String password;		//数据库用户密码
	Connection conn ;
    Statement stat;
    ResultSet rs;
  	int i;
	public MyConn() {
		dbURL="jdbc:odbc:hotel";
		user="furongrong";
		password="19870629";
	}

  public ResultSet executeQuery(String s){
  	rs=null;
	try
	{

	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
    conn=DriverManager.getConnection(dbURL,user,password);
	stat = conn.createStatement();
	rs=stat.executeQuery(s);
	}
	catch (Exception e)
	{
		System.out.println(e.toString());
	}
   return rs;
	}

  public int executeUpdate(String s){
  	rs=null;

	try
	{

	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
    conn=DriverManager.getConnection(dbURL,user,password);
	stat = conn.createStatement();
	i=stat.executeUpdate(s);
	}
	catch (Exception e)
	{
		System.out.println(e.toString());
	}
    return i;
	}
  
  public void close()
  {
  	try{
  		if(rs!=null)
  			rs.close();
  		if(stat!=null)
  			stat.close();
  		if(conn!=null)
  			conn.close();
  	}catch (Exception e)
	{
		System.out.println(e.toString());
	}
  }
  public static void main(String args[])
	{
		
			MyConn bridge=new MyConn();
	}

}