addctenter.jsp

精品课程的java源码

<%@ page contentType="text/html;charset=gbk" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ 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,oicq,homepage,sex,face,text,email;
int int_oicq;
Integer int_num=new Integer(0);
name=request.getParameter("name");
email=request.getParameter("email");
oicq=request.getParameter("qq");
sex=request.getParameter("sex");
face=request.getParameter("face");
text=request.getParameter("text");
//if(oicq!=null){
//try{
//int_oicq=int_num.parseInt(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(name+email+oicq+homepage+sex+face+text+email);
if(name.length()!=0 && text.length()!=0){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql;
java.util.Date ud = new java.util.Date();
java.sql.Timestamp times = new java.sql.Timestamp(ud.getTime());
//java.sql.Date b = new java.sql.Date(new java.util.Date().getTime()); 

sql="insert into lyb_content (content,name,image,email,oicq,sex,times) values ('"+text+"','"+name+"','"+face+"','"+email+"','"+oicq+"','"+sex+"','"+times+"')";
sql=Bytes(sql);
sql=format(sql);
stmt.executeUpdate(sql); 
stmt.close();
out.print("<script>alert('留言成功！');window.location.href='index.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 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>");
%>