sqlutils.java

手机游戏设计一书的源代码

package bookshop.sql;



import java.sql.*;
import oracle.jdbc.driver.OracleDriver;


public class SqlUtils {

  private void createConnection () {
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      conn = java.sql.DriverManager.getConnection(
          "jdbc:oracle:thin:@localhost:1521:pdjerry", "scott", "tiger");
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    catch (ClassNotFoundException ex) {
      ex.printStackTrace();
    }
  }

  private void closeConnection () {
    if (conn != null) {
      try {
        conn.close();
      }
      catch (SQLException ex) {
      }
    }
  }

 //获取图书信息方法
  public  String[] getBookInfo (String bookNo) {
      createConnection () ;
      try {
        String[] bookInfo = new String[4];
        Statement stmt = conn.createStatement();
        ResultSet rst = stmt.executeQuery("select * from BookInfo where BookNo='" + bookNo + "'");
        while (rst.next()) {
          for (int i = 0;i < rst.getMetaData().getColumnCount();i++) {
             bookInfo[i] = rst.getString(i + 1);
          }

        }
        if (rst != null) rst.close();
        if (stmt != null) stmt.close();
        closeConnection();
        return bookInfo;
      }
      catch (SQLException ex) {
        ex.printStackTrace();
        return null;
      }
  }


  private Connection conn = null;

}