databasebeanp.java

燕大人才系统

package databasebeanp;
import java.sql.*;
public class databasebeanp
{
    String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String ConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=qiuzhixinxi";
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    int i ;
    public databasebeanp()
    {
        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","sa");
            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 int executeUpdate(String sql)
    {
    	i=0;
        try
        {
     
            conn=DriverManager.getConnection(ConnStr,"sa","sa");
            Statement stmt= conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            i=stmt.executeUpdate(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("databasebean.executeUpdate:"+ex.getMessage());
        }
        return i;
    }

    
    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; 
       } 
  } 
}