关于JDBC连接数据库的代码

来源：互联网发布：淘宝网帐号怎么申请编辑：程序博客网时间：2024/05/20 22:26

import java.sql.*;

public class DBConn {
private Connection conn;

private Statement sta;

private ResultSet rs;

private String driver="oracle.jdbc.driver.OracleDriver";

private String url="jdbc:oracle:thin:@localhost:1521:TBSOFT";

private static DBConn db;

private DBConn()throws Exception{
  Class.forName(driver);
  conn=DriverManager.getConnection(url,"maomao","maomao");
}

public static DBConn getConn(){
  if(db==null){
   try{
    db=new DBConn();
   }catch(Exception e){
    e.printStackTrace();
   }
  }
  return db;
}

public void disConn(){
  if(rs!=null){
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
  if(sta!=null){
   try {
    sta.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
  if(conn!=null){
   try {
    conn.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
}

public ResultSet query(String sql) throws SQLException{

   sta=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
   rs=sta.executeQuery(sql);

  return rs;
}

public void update(String sql) throws SQLException{

   sta=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
   sta.executeUpdate(sql);

}

}