gbcountdao.java~3~

来自「网吧网站留言本。主要使用基于MVC模式的JSP+JAVABEAN+SERVLET」· JAVA~3~ 代码 · 共 54 行

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;

    }

    public String getTime(){
        Connection con = com.netbar.dao.databaseOprate.getConnection();
       String sql = "select lastAdminLoginTime from gbCount";
       PreparedStatement pstmt = null;
       String time="";
       try {
           pstmt = con.prepareStatement(sql);
           ResultSet rs = pstmt.executeQuery();
           while (rs.next()) {
               time = rs.getString(1);
           }
           rs.close();
           pstmt.close();
           con.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           return "";
       }
       return time;


    }
}