留言板系统(jsp版) .docVIP

  • 72
  • 0
  • 约2.37万字
  • 约 25页
  • 2017-05-01 发布于江西
  • 举报
留言板系统(jsp版)

留言板(JSP+JavaBean+filter+servlet+验证码 ) 作者:石头的承诺 PAGE  PAGE - 25 - 欢迎交流学习 留言板 仅供学习参考 作者:石头的承诺  HYPERLINK mailto:如有错误请发邮件到ww1095@163.com 如有错误请发邮件到ww1095@163.com欢迎交流学习! 开发工具:MyEclipse+Tomcat6.0+SQL2005 1.建立数据库 用户名:sa 密码:123 数据库名:info 表一:admininfo 表二:userinfo 注意: 2.源代码 目录结构: 1)conn.java package conn; import java.sql.*; public class conn { private Connection conn=null; private ResultSet rs=null; String dbUrl=jdbc:sqlserver://localhost:1433;databaseName=info;//连接串 String dbUser=sa; String dbPassword=123; public conn(){ try{ //加载ODBC驱动 Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); }catch(java.lang.ClassNotFoundException e){ System.out.println(e.getMessage()); } } public ResultSet getQuery(String sqls){//查询操作 try{ conn= DriverManager.getConnection(dbUrl,dbUser,dbPassword); Statement sql = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=sql.executeQuery(sqls); }catch(Exception e){ System.out.print(e.toString()); } return rs; } public void setModify(String sqls){//更新操作 try{ conn= DriverManager.getConnection(dbUrl,dbUser,dbPassword); Statement sql = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); sql.executeUpdate(sqls); }catch(Exception e){ System.out.print(e.toString()); } } } 2)loginfilter.java(登录过滤器) package loginfilter; import java.io.* ; import javax.servlet.* ; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class loginfilter implements Filter { public void init(FilterConfig filterConfig) throws ServletException { System.out.println(**登陸过滤器初始化...) ; } public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain chain) throws IOException, ServletException { HttpServletRequest req=(HttpServletRequest)arg0; Object loged=req.get

文档评论(0)

1亿VIP精品文档

相关文档