check.jsp

这个源码是一个论坛的源码,包括登陆,搜索和发表等.不过还有些功能不是很完善.

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");

String title1=request.getParameter("title1");
String content1=request.getParameter("content1");

String sql="select * from scott.dd "; 
ResultSet rs=stmt.executeQuery(sql); 
int introwcount;
ResultSet rt=stmt.executeQuery(sql);
rt.next();
introwcount=rt.getInt(1);
if(introwcount==null)
  long userid=1;
else
{
  long userid="select max(userid) from scott.dd";
  userid++;
}

  
stmt.executeUpdate("INSERT INTO scott.dd(userid,username,title1,content1)VALUES('"+userid+"','"+username+"','"+title1+"', '"+content1+"')");
out.print("<script>alert('添加成功');</script>");
rs.close();  rt.close(); stmt.close();   
%>

<br>
<center>
<font color=red>恭喜您：添加成功！</font>
<a href="index.jsp">返回</a>
</center>