gbcount.jsp~9~

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

<%@ 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) {
  ex.printStackTrace();
}
//javax.servlet.jsp.JspWriter outcount=response.getWriter();
//outcount.print(count);
out.print(count);
%>