<TABLE id=submenu3112 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY> <TR><TD><IMG src="<%=basePath %>member/images/closed。gif"></TD>
<TD height=23><A href="<%=basePath %>member/sq/index。jsp" target="MainFrame">申报信息管理</A></TD></TR>
<TR><TD><IMG src="<%=basePath %>member/images/closed。gif"></TD>
<TD height=23><A href="<%=basePath %>member/sq/add。jsp?method=addsq" target="MainFrame">提交申报信息</A></TD></TR>
<TR><TD><IMG src="<%=basePath %>member/images/closed。gif"></TD>
<TD height=23><A href="<%=basePath %>member/sq/s。jsp" target="MainFrame">查询申报信息</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></td></tr>
<tr><td height="5" background="<%=basePath %>member/images/tableline_bottom。jpg" bgcolor="#9BC2ED"></td></tr>
3。4代码设计
因为整个系统的代码太多，不能一一介绍，只在这里简单介绍下用户注册时的操作代码：
try{
String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")。format(Calendar。getInstance()。getTime());
String date2=new SimpleDateFormat("yyyy-MM-dd")。format(Calendar。getInstance()。getTime());
String method=request。getParameter("method")。trim();
ComBean cBean = new ComBean();
HttpSession session = request。getSession();
if(method。equals("mreg")){ //会员注册
String username = request。getParameter("username");
String password = request。getParameter("password");
String realname = request。getParameter("realname");
String sex = request。getParameter("sex");
String age = request。getParameter("age");
String address = request。getParameter("address");
String email = request。getParameter("email");
String str=cBean。getString("select id from member where username='"+username+"'");
if(str==null){
int flag=cBean。comUp("insert into member(username,password,realname,sex,age,address,email,regtime) " +
"values('"+username+"','"+password+"','"+realname+"','"+sex+"','"+age+"','"+address+"','"+email+"','"+date+"')");
if(flag == Constant。SUCCESS){
request。setAttribute("message", "注册成功请登录！");
request。getRequestDispatcher("login。jsp")。forward(request, response);
}
else {
request。setAttribute("message", "操作失败！");
request。getRequestDispatcher("reg。jsp")。forward(request, response);
}
}
else{
request。setAttribute("message", "该用户名已存在！");
request。getRequestDispatcher("reg。jsp")。forward(request, response);
}
}
4 系统实现
4。1开发环境 JSP+MySQL信息管理与信息系统品牌专业经费管理系统设计(7):http://www.youerw.com/jisuanji/lunwen_110244.html