gbcount.jsp~3~

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

<%@ page contentType="text/html; charset=GBK" import="java.sql.*" %>
<%
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) {

}
System.out.println(count);
%>