一个完整的java web项目 包含数据库

package s2jsp.bysj.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class baseDao {    
    public final static String DRIVER = “com.microsoft.jdbc.sqlserver.SQLServerDriver“;                 // 数据库驱动
    public final static String URL    = “jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=company“;   // url
    public final static String DBNAME = “sa“;                                                           // 数据库用户名
    public final static String DBPASS = “120010“;                                                           // 数据库密码
    
    /**
     * 得到数据库连接
     * @throws ClassNotFoundException
     * @throws SQLException
     * @return 数据库连接
     */
    public Connection getConn（） throws ClassNotFoundException SQLException{
        Class.forName（DRIVER）;                                                    //注册驱动
        Connection conn = DriverManager.getConnection（URLDBNAMEDBPASS）;        //获得数据库连接
        return conn ;                                                            //返回连接
    }
    
    /**
     * 释放资源
     * @param conn 数据库连接
     * @param pstmt PreparedStatement对象
     * @param rs 结果集
     */
    public void closeAll（ Connection conn PreparedStatement pstmt ResultSet rs ） {
        /*  如果rs不空，关闭rs  */
        if（rs != null）{
            try { rs.close（）;} catch （SQLException e） {e.printStackTrace（）;}
        }
        /*  如果pstmt不空，关闭pstmt  */
        if（pstmt != null）{
            try { pstmt.close（）;} catch （SQLException e） {e.printStackTrace（）;}
        }
        /*  如果conn不空，关闭conn  */
        if（conn != null）{
            try { conn.close（）;} catch （SQLException e） {e.printStackTrace（）;}
        }
    }
    
    /**
     * 执行SQL语句，可以进行增、删、改的操作，不能执行查询
     * @param sql  预编译的 SQL 语句
     * @param param  预编译的 SQL 语句中的‘？’参数的字符串数组
     * @return 影响的条数
     */
    public int executeSQL（String preparedSqlString[] param） {
        Connection        conn  = null;
        PreparedStatement pstmt = null;
        int               num   = 0;
        
        /*  处理SQL执行SQL  */
        try {
            conn = getConn（）;                              // 得到数据库连接
            pstmt = conn.prepareStatement（preparedSql）;    // 得到PreparedStatement对象
            if（ param != null ） {
                for（ int i = 0; i < param.length; i++ ） {
                    pstmt.setString（i+1 param[i]）;         // 为预编译sql设置参数
                }
            }
            num = pstmt.executeUpdate（）;                    // 执行SQL语句
        } catch （ClassNotFoundException e） {
            e.printStackTrace（）;                            // 处理ClassNotFoundException异常
        } catch （SQLException e） {
            e.printStackTrace（）;                            // 处理SQLException异常
        } finally {
            closeAll（connpstmtnull）;                     // 释放

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

     文件        490  2007-10-31 14:45  companycompany.classpath

     文件        294  2007-10-04 12:26  companycompany.mymetadata

     文件       1225  2007-10-01 10:17  companycompany.project

     文件        127  2007-10-06 22:50  companycompany.settingsorg.eclipse.core.resources.prefs

     文件       3221  2007-10-31 16:17  companycompanysrcs2jspysjdaoaseDao.java

     文件       2506  2007-10-31 13:46  companycompanysrcs2jspysjdaoMessageDao.java

     文件       4555  2007-10-07 13:37  companycompanysrcs2jspysjdaoNewsDao.java

     文件       5022  2007-10-10 11:59  companycompanysrcs2jspysjdaoProductDao.java

     文件       1347  2007-10-08 13:27  companycompanysrcs2jspysjdaoRevertDao.java

     文件       2981  2007-10-31 15:30  companycompanysrcs2jspysjdaoUserDao.java

     文件       1456  2007-10-05 09:28  companycompanysrcs2jspysjentityMessage.java

     文件        992  2007-10-01 09:20  companycompanysrcs2jspysjentityNews.java

     文件       1961  2007-10-01 16:35  companycompanysrcs2jspysjentityProduct.java

     文件       1368  2007-10-05 13:34  companycompanysrcs2jspysjentityRevert.java

     文件        984  2007-10-02 09:22  companycompanysrcs2jspysjentityUsers.java

     文件       2244  2007-10-10 15:09  companycompanyWebRootabout.jsp

     文件       2345  2007-10-12 15:13  companycompanyWebRootadminaddManager.jsp

     文件       2492  2007-10-31 13:38  companycompanyWebRootadminaddNews.jsp

     文件       4441  2007-10-31 14:33  companycompanyWebRootadminaddProduct.jsp

     文件        942  2007-10-10 17:24  companycompanyWebRootadminadminLoginManage.jsp

     文件        124  2007-10-10 16:50  companycompanyWebRootadminadminOut.jsp

     文件        270  2007-10-10 13:25  companycompanyWebRootadmincheckSession.jsp

     文件       1341  2007-10-10 08:35  companycompanyWebRootadminindex.jsp

     文件       5095  2007-10-08 14:34  companycompanyWebRootadminleft.jsp

     文件       1797  2007-10-11 09:38  companycompanyWebRootadminmanageNews.jsp

     文件       2732  2007-10-10 08:35  companycompanyWebRootadminmanageProduct.jsp

     文件        226  2007-10-07 17:11  companycompanyWebRootadmin
ight.jsp

     文件       1803  2007-10-10 08:35  companycompanyWebRootadminshowUserList.jsp

     文件       4379  2007-10-11 09:26  companycompanyWebRootadminupdateProduct.jsp

     文件       2621  2007-10-10 15:00  companycompanyWebRootafter.jsp

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