databasebean.java

燕大人才系统

package databasebean;
import java.sql.*;
public class databasebean
{
    String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String ConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=fanggai";
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    
    public databasebean()
    {
        try
        {
        	
            Class.forName(DBDriver);
        }
        catch(java.lang.ClassNotFoundException e)
        {
            System.err.println("databasebean():"+e.getMessage());
        }
    }



    public ResultSet executeQuery(String sql)
    {
        rs=null;
        try
        {
            conn=DriverManager.getConnection(ConnStr,"sa","123");
            stmt= conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            rs=stmt.executeQuery(sql);
            
        }
        catch(SQLException ex)
        {
            System.err.println("databasebean.executeQuery:"+ex.getMessage());
        }
        return rs; 
    }



    public void executeUpdate(String sql)
    {
        try
        {
     
            conn=DriverManager.getConnection(ConnStr,"sa","123");
            Statement stmt= conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            stmt.executeUpdate(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("databasebean.executeUpdate:"+ex.getMessage());
        }
    }

    
    public boolean closeConn() 
    { 

       try 
       { 
           if (rs!=null) 
           {rs.close(); }
           if (stmt!=null) 
           {stmt.close(); }
           if (conn!=null) 
           {conn.close(); }
        return true; 
       } 
       catch(SQLException ex) 
       { 
            System.err.println("close:"+ex.getMessage());
            return false; 
       } 
  } 
}