jdbcfile.java~11~

基于java的一个小应用程序开发与应用

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