jdbcfile.java

来自「里面有电子书店管理系统」· Java 代码 · 共 39 行

package com.dbmanage;

import java.sql.*;
import java.util.*;
import java.awt.*;

/**
 * <p>Title:数据库连接 </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class JDBCFile {

  Connection conn;
  Statement stmt;
  int insertValue = -1;

  public JDBCFile() throws Exception {
    String driverName="oracle.jdbc.OracleDriver";
    Class.forName(driverName);
    conn = DriverManager.getConnection(
        "jdbc:oracle:thin:@thsspc0770:1521:THSSPCDB", "himsdba", "himsdba");
    stmt = conn.createStatement();
  } //构造函数

  public ResultSet executeQuery(String sql) throws Exception {
    ResultSet rs = stmt.executeQuery(sql);
    return rs;
  } //end executeQuery 查询

  public int insert(String sql) throws Exception {
    insertValue = stmt.executeUpdate(sql);
    return insertValue;
  } //end insert()插入
} //end public class JDBCFile