gbcountdao.java~2~

网吧网站留言本。主要使用基于MVC模式的JSP+JAVABEAN+SERVLET

package com.netbar.dao;

import java.sql.*;

public class gbCountDao {
    public gbCountDao() {
    }

    public int getCurrentCount() {
        Connection con = com.netbar.dao.databaseOprate.getConnection();
        String sql = "select accessCount from gbCount";
        PreparedStatement pstmt = null;
        int count = 0;
        try {
            pstmt = con.prepareStatement(sql);
            ResultSet rs = pstmt.executeQuery();
            while (rs.next()) {
                count = rs.getInt(1);
            }
            rs.close();
            pstmt.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
            return 0;
        }
        return count;

    }
}