www.pudn.com > Hotel.rar > MyConn.java

/* 
 * 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(); 
	} 
 
}