act.jsp

留言管理系统 用户网络版块的增加

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.jsp"%>
<%


ResultSet rs = stmt.executeQuery("select id from scott.lyb");
rs.last();
int no;
if(rs.getRow()!=0){
no=rs.getInt(1);
no++;
}else{no=1;}
rs.close();

request.setCharacterEncoding("gb2312");
String title=request.getParameter("title");
String name=request.getParameter("name");
String mail=request.getParameter("mail");
String web=request.getParameter("web");
String qq=request.getParameter("qq");
String txt=request.getParameter("text");
String ip=request.getRemoteAddr();
String id=""+no;
out.print(id);
String sql="insert into scott.lyb(id,title,name,mail,web,qq,ip,text) values("+id+",'"+title+"','"+name+"','"+mail+"','"+web+"','"+qq+"','"+ip+"','"+txt+"')";
stmt.executeUpdate(sql);
stmt.close();

response.sendRedirect("index.jsp");
%>