conn.java

来自「一个用JSP编写的在线图书购物网,很方便很方便很方便」· Java 代码 · 共 40 行

package bookshop;
import java.sql.*;
public class conn{
 String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
 String sConnStr="jdbc:odbc:bookshop";
 Connection connect=null;
 ResultSet rs=null;
 public conn(){
  try{
    Class.forName(sDBDriver);
	}
  catch(java.lang.ClassNotFoundException e){
    System.err.println(e.getMessage());
	}
 }
 public ResultSet executeQuery(String sql){
  try{
    connect=DriverManager.getConnection(sConnStr);
	Statement stmt=connect.createStatement();
	rs=stmt.executeQuery(sql);
	}
  catch(SQLException ex){
    System.err.println(ex.getMessage());
	}
	return rs;
 }
 public int executeUpdate(String sql){
  int rs=0;
  try{
     connect=DriverManager.getConnection(sConnStr);
	 Statement stmt=connect.createStatement();
	 rs=stmt.executeUpdate(sql);
	 }
	 catch(SQLException ex){
	   System.err.println(ex.getMessage());
	   }
	 return rs;
	}

}