addctenter.jsp

网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询

<%@ include file="format.jsp"%>
<%@ include file="bytes.jsp"%>
<%@ include file="conn.jsp"%>

<%String name;
name= (String) session.getValue("name");
if(name!=null)
{
out.print("<div align=center>管理员"+session.getValue("name"));
out.print("已经登陆&nbsp;&nbsp;&nbsp;&nbsp;<a href=default.jsp?loginout=true>退出登陆</a></div>");
}
String getword=request.getParameter("add");
if(getword!=null){
if(getword.compareTo("true")==0)
{
String eshow_name,eshow_oicq,eshow_homepage,eshow_sex,eshow_face,eshow_text,eshow_email;
int int_oicq;
Integer int_num=new Integer(0);
eshow_name=request.getParameter("name");
eshow_email=request.getParameter("email");
eshow_oicq=request.getParameter("qq");
eshow_homepage=request.getParameter("index");
eshow_sex=request.getParameter("sex");
eshow_face=request.getParameter("face");
eshow_text=request.getParameter("text");
//if(eshow_oicq!=null){
//try{
//int_oicq=int_num.parseInt(eshow_oicq);
//}
//catch(NumberFormatException e){
//out.print("<script language=javascript>window.location='info.jsp?info=mustnumber'</script>");
//out.print("<script>alert('error number');history.go(-1);</script>");//jsp的不使之执行下一步代码？}}
//out.print(eshow_name+eshow_email+eshow_oicq+eshow_homepage+eshow_sex+eshow_face+eshow_text+eshow_email);
if(eshow_name.length()!=0 && eshow_text.length()!=0){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql;
sql="insert into eshow_content (eshow_content,eshow_name,eshow_image,eshow_index,eshow_email,eshow_oicq,eshow_sex) values ('"+eshow_text+"','"+eshow_name+"','"+eshow_face+"','"+eshow_homepage+"','"+eshow_email+"','"+eshow_oicq+"','"+eshow_sex+"')";
sql=Bytes(sql);
sql=format(sql);
stmt.executeUpdate(sql); //操作数据库
stmt.close();
out.print("<script>alert('留言成功，感谢你的留言，现在就可在主页看到留言了');window.location.href='default.jsp';</script>");
}else
{
out.print("<script>alert('注意,名称和内容不能为空');history.go(-1);</script>");
}
}
}
out.print("<table width='771' border='0' align='center' cellpadding='5' cellspacing='1' bgcolor='#000000'>");
out.print("<form name='form1' method='post' action='add.jsp?add=true'>");
out.print("<tr bgcolor='#FFFFFF'><td width='103' align='right'>您的名字:</td><td width='668'><input name='name' type='text' id='name' size='30' maxlength='20'>*(20个字内)</td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>您的邮箱:</td><td><input name='email' type='text' id='email' size='30'></td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>腾讯QQ号:</td><td><input name='qq' type='text' size='30'></td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>您的主页:</td><td><input name='index' type='text' size='30'></td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>您的性别:</td><td><input type='radio' name='sex' value='女士' checked>女士<input name='sex' type='radio' value='先生'>先生</td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>喜欢的头像:</td>");
out.print("<td><input name='face' type='radio' value='image/a.gif' checked>");
out.print("<img src='image/a.gif' width='70' height='62' align='absmiddle'>");
out.print("<input type='radio' name='face' value='image/b.gif'>");
out.print("<img src='image/b.gif' width='70' height='62' align='absmiddle'>");
out.print("<input type='radio' name='face' value='image/c.gif'>");
out.print("<img src='image/c.gif' width='70' height='62' align='absmiddle'>");
out.print("<input type='radio' name='face' value='image/d.gif'>");
out.print("<img src='image/d.gif' width='70' height='62' align='absmiddle'>");
out.print("<input type='radio' name='face' value='image/e.gif'>");
out.print("<img src='image/e.gif' width='70' height='62' align='absmiddle'>");
out.print("<input type='radio' name='face' value='image/f.gif'>");
out.print("<img src='image/f.gif' width='70' height='60' align='absmiddle'>");
out.print("</td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td align='right'>留言内容:</td><td><textarea name='text' cols='80' rows='6'></textarea>*(200字以内)</td></tr>");
out.print("<tr bgcolor='#FFFFFF'><td>&nbsp;</td><td><input type='submit' name='Submit' value='提交留言'><input name='Submit' type='reset' value='清空留言'></td></tr>");
out.print("</form></table>");
%>