基于JSP的网上求职系统

基于JSP的网上求职系统

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=qiuzhixinxi“;
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    int i ;
    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““sa“）;
            stmt= conn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.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_SENSITIVEResultSet.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; 
       } 
  } 
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      24653  2007-12-26 17:20  qiuzhixinxi\auditing_1.jsp

     文件       2164  2008-01-12 21:06  qiuzhixinxi\auditing_1_1.jsp

     文件      25480  2007-12-26 17:25  qiuzhixinxi\auditing_2.jsp

     文件       2244  2008-01-12 21:07  qiuzhixinxi\auditing_2_2.jsp

     文件      27416  2007-12-26 17:26  qiuzhixinxi\auditing_3.jsp

     文件       2278  2008-01-12 21:07  qiuzhixinxi\auditing_3_3.jsp

     文件      26030  2007-12-26 17:27  qiuzhixinxi\auditing_4.jsp

     文件       2200  2008-01-12 21:06  qiuzhixinxi\auditing_4_4.jsp

     文件      25977  2007-12-26 17:28  qiuzhixinxi\auditing_5.jsp

     文件       2439  2008-01-12 21:06  qiuzhixinxi\auditing_5_5.jsp

     文件        569  2007-10-23 21:31  qiuzhixinxi\auditing_end.jsp

     文件       4323  2007-12-27 22:32  qiuzhixinxi\auditing_judge.jsp

     文件        629  2007-12-27 22:49  qiuzhixinxi\auditing_wait.jsp

     文件        535  2007-01-03 09:55  qiuzhixinxi\exit_do.jsp

     文件        580  2007-04-10 23:10  qiuzhixinxi\guide.jsp

     文件      27675  2008-01-12 16:46  qiuzhixinxi\file\1200127598953.rar

     文件      57928  2008-01-12 16:57  qiuzhixinxi\file\1200128240984.rar

     文件      57928  2008-01-12 17:00  qiuzhixinxi\file\1200128440750.rar

     文件      33822  2008-01-12 17:01  qiuzhixinxi\file\1200128485265.rar

     文件      57928  2008-01-12 17:03  qiuzhixinxi\file\1200128631968.rar

     文件      33822  2008-01-12 17:04  qiuzhixinxi\file\1200128660515.rar

     文件      33822  2008-01-12 17:07  qiuzhixinxi\file\1200128834453.rar

     文件      33822  2008-01-12 17:09  qiuzhixinxi\file\1200128959359.rar

     文件      33822  2008-01-12 17:13  qiuzhixinxi\file\1200129223156.rar

     文件      33822  2008-01-12 17:15  qiuzhixinxi\file\1200129307468.rar

     文件      33822  2008-01-12 17:16  qiuzhixinxi\file\1200129406328.rar

     目录          0  2008-01-12 16:46  qiuzhixinxi\file

     文件       1352  2007-10-24 10:46  qiuzhixinxi\index_bg.jsp

     文件       2097  2008-01-12 21:27  qiuzhixinxi\resume_5.jsp

     文件       1169  2007-12-27 20:09  qiuzhixinxi\info_intro.jsp

............此处省略273个文件信息