act.jsp

来自「一个用JSP+ACCESS做的留言板页面,简单实用」· JSP 代码 · 共 32 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:numb1");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

ResultSet rs = st.executeQuery("select id from 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;

String sql="insert into lyb values("+id+",'"+title+"','"+name+"','"+mail+"','"+web+"','"+qq+"','"+ip+"',now(),'"+txt+"','','n')";
st.executeUpdate(sql);
st.close();
con.close();
response.sendRedirect("index.jsp");
%>