www.pudn.com > 使用 Java 读取条形码代码文件.rar > Database.java

package com.jmart.dbaccess; 
 
 
import java.sql.*; 
import java.util.List; 
 
public class Database  
{ 
  private static final String jdbcDriver  
  	= "COM.ibm.db2.jdbc.app.DB2Driver"; 
  private static final String jdbcURL  
  	= "jdbc:db2:"; 
  private Connection connection;  
  public Database(String username,  
	  String password, String database)  
	throws SQLException, ClassNotFoundException  
  { 
    Class.forName(jdbcDriver); 
    String dbURL = jdbcURL + database; 
    if (!username.equals(""))  
    { 
      connection  
      	= DriverManager.getConnection 
      	  (dbURL, username, password); 
    }  
    else  
    { 
      connection  
      	= DriverManager.getConnection(dbURL); 
    } 
  } 
  public void close()  
  { 
    try  
    { 
      connection.close(); 
    }  
    catch (SQLException se)  
    { 
      connection = null; 
    } 
  } 
  public ResultSet executeQuery(String query)  
     throws SQLException  
  { 
    PreparedStatement st  
      = connection.prepareStatement(query); 
    return st.executeQuery(); 
  } 
  public int executeUpdate(String statement)  
    throws SQLException  
  { 
    PreparedStatement st  
      = connection.prepareStatement(statement); 
    return st.executeUpdate(); 
  } 
  protected void finalize()  
  { 
    close(); 
  } 
}