dbconnect.java

一个oracle和JSP做的论坛

package hcit.common;


import java.sql.*;

public class DBConnect {

    public Connection conn = null;
    private Statement stmt  = null;
    private ResultSet rs    = null;

    public DBConnect()
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(
                "jdbc:oracle:thin:@localhost:1521:HCIT", "angel", "1");
             stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        }
        catch (SQLException ex)
        {
            System.out.println(ex.getMessage() + "1路径错误");
        }
        catch (ClassNotFoundException ex)
        {
            System.out.println(ex.getMessage() + "驱动错误");
        }
   }

   public ResultSet executeQuery(String ssql) throws SQLException{
       try{
           rs = stmt.executeQuery(ssql);
           return rs;
       }
       catch(SQLException se){
           conn.rollback();
           System.out.println("DBBean.executeQuery() ERROR:"+se.getMessage());
       }
       finally{

       }

       return rs;
   }
   public int executeUpdate(String ssql) throws SQLException{
        int iupdate = 0;
        try{
            iupdate = stmt.executeUpdate(ssql);
        }
        catch(SQLException se){
            conn.rollback();
            System.out.println("DBBean.executeUpdate() ERROR:"+se.getMessage());
        }
        finally{
        }
        return iupdate;
   }
   public void free() throws SQLException{
       try{
           if(rs   != null) rs.close();

           if(stmt != null) stmt.close();
           if(conn != null) conn.close();
       }
       catch(SQLException se){
           System.out.println("DBBean.free() ERROR:"+se.getMessage());
       }
   }


}