数据库连接java

来源：互联网发布：和药娘啪啪的感觉知乎编辑：程序博客网时间：2024/05/16 12:24

package aaa;

import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.net.*;

public class DBConn{

Connection conn = null;
ResultSet rs = null;

private String link="jdbc:oracle:thin:@192.168.10.120:1521:DBNAME";
private String name="username";
private String password="password";

public DBConn(){
  try{
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   }
  catch(java.lang.Exception e){
   System.err.println("dataDriver is wrong DBase():"+e.getMessage());
   }
  }

public ResultSet executeQuery(String sql){
  rs = null;
  try{
   Connection conn = DriverManager.getConnection(link,name,password);
   Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
   System.out.println(sql);
   rs = stmt.executeQuery(sql);
   }
  catch(SQLException ex){
   System.err.println("query is wrony Dbase.executeQuery()" + ex.getMessage());
   }
  return rs;
  }

public boolean executeUpdate(String sql){
  boolean bupdate = false;
  try{
   Connection conn = DriverManager.getConnection(link,name,password);
   Statement stmt = conn.createStatement();
   int rowcount = stmt.executeUpdate(sql);
   if(rowcount!=0) bupdate = true;
   }

  catch(SQLException ex){
   System.err.println("update is wrony,Dbase.executeUpdate()" + ex.getMessage());
   }
  return bupdate;
  }


public void connClose(){

  try{

   if(conn!=null) conn.close();
   if(rs!=null) rs=null;

   }
  catch(SQLException ex){
   System.out.println("connClose "+ex.getMessage());
   }
  }

}