论坛的首页效果图:
3、核心代码: 在论坛的开发中,对于一些公用的模块,我们采用组建的方式实现。以下是 关于数据连接的
JavaBean。
package frola; import java.io.*; import java.sql.*; public class jdbc { public jdbc() { } Connection conn = null ; public java.sql.Connection getConn() //数据库连接函数,返回一个数据库连接对象 { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); user="+use+"&;password="+pass+"&;useUnicode=true&;characterEncoding=gb2312" ;
1
conn= DriverManager.getConnection("jdbc:odbc:bbsdata","",""); } catch(Exception e) { e.printStackTrace(); System.out.println("数据库连接失败!"); } return this.conn ; } public String getTime() //获取当前系统时间,返回当前时间字符串 { String datestr = "" ; try { java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-M-d HH:ss") ; java.util.Date date = new java.util.Date() ; datestr = df.format(new java.util.Date()) ; } catch (Exception ex) { } return datestr ; } }
截图界面如下:
2
当用户填写完个人信息之后,点击立即注册,
系统即会把用户信息写入数据库,并返回提示 页面,核心注册代码如下: //例程 1-6 <%@page contentType="text/html;harset=gb2312"; language="java" import="java.sql.*,java.util.*" %>
xml:namespace prefix = jsp />
<%!String User_Name,User_Password,User_Password1,sql,User_Sex,User_Email,User_Address,Use r_Mobile,User_Oicq,User_Year,User_Month,User_Day,User_Birthday,User_Icon,User_S ign; %> <% User_Name=request.getParameter("name"); User_Name=yy.ex_chinese(User_Name); User_Password=request.getParameter("password"); User_Password=yy.ex_chinese(User_Password); User_Password1=request.getParameter("pass
word2"); User_Password1=yy.ex_chinese(User_Password1); User_Sex=request.getParameter("sex"); User_Sex=yy.ex_chinese(User_Sex);
3
User_Email=request.getParameter("email"); User_Address=request.getParameter("address"); User_Address=yy.ex_chinese(User_Address); User_Mobile=request.getParameter("mobile"); User_Oicq=request.getParameter("oicq"); User_Year=request.getParameter("year"); User_Month=request.getParameter("month"); User_Day=request.getParameter("day"); User_Icon=request.getParameter("icon"); User_Sign=request.getParameter("sign"); User_Sign=yy.ex_chinese(User_Sign); if (User_Year.equals("")) { if ((User_Month.equals(""))&;&;(User_Day.equals(""))) User_Birthday="保密"; else User_Birthday=User_Month+"月"+User_Day+"日"; }else { if ((User_Month.equals(""))&;&;(User_Day.equals(""))) User_Birthday="保密"; else User_Birthday=User_Year+"年"+User_Month+"月"+User_Day+"日"; } User_Birthday=yy.ex_chinese(User_Birthday); if (User_Email.equals("")) { response.sendRedirect("err.jsp?id=11"); return; }else { } if (!User_Password.equals(User_Password1)) { response.sendRedirect("err.jsp?id=9"); return; } if ((User_Password.length()<5)||(User_Password.length()>12)) {
4
response.sendRedirec
t("err.jsp?id=10"); return; } if((User_Name.indexOf("'")>0)||(User_Name.indexOf(" ")>0)||(User_Name.indexOf("@")>0)||(User_Name.indexOf("=")>0)||(User_Name.index Of("%")>0)) { response.sendRedirect("err.jsp?id=12"); ret