jdbcfile.java~10~

来自「这是Java数据库系统项目开发实践源代码,所有代码经过测试」· JAVA~10~ 代码 · 共 46 行

package com.dbmanage;

import java.sql.*;
import javax.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()插入
  //System.out.println("d@@@@@:"+  insertValue);
}//end public class JDBCFile