actre.jsp

一个用JSP+ACCESS做的留言板页面,简单实用

<%@ 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);

request.setCharacterEncoding("gb2312");
String id=request.getParameter("id");
String txt=request.getParameter("text");

String sql="update lyb set retxt='"+txt+"',isre='y' where id="+id;
st.executeUpdate(sql);
st.close();
con.close();
response.sendRedirect("show.jsp?id="+id);
%>