<%@ Pagelanguage= "Java"ContentType= "text/html; charset=utf-8"pageencoding= "UTF-8"%><!DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd "><HTML><Head><Metahttp-equiv= "Content-type"content= "text/html; charset=utf-8"><title>Insert Title here</title></Head><Body><formAction= "lyxianshi.jsp"Method= "POST"> Id: <inputtype= "text"name= "Name"><BR>Reply:<textareaname= "Testarea" ></textarea><BR><inputtype= "Submit"value= "Submit"></form></Body></HTML>
<%@ Pagelanguage= "Java"ContentType= "text/html; charset=utf-8"pageencoding= "UTF-8"%><%@ PageImport= "java.sql.*"%><!DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd "><HTML><Head><Metahttp-equiv= "Content-type"content= "text/html; charset=utf-8"><title>Insert Title here</title></Head><Body><% Stringname=newString (Request.getparameter ("name"). GetBytes ("Iso-8859-1"), "UTF-8"); String Testarea=newString (Request.getparameter ("Testarea"). GetBytes ("Iso-8859-1"), "UTF-8"); Connection Conn= null; try {class.forname ("oracle.jdbc.driver.OracleDriver"); String strURL= "Jdbc:oracle:thin: @localhost: 1521:orcl" ; Conn= Drivermanager.getconnection (strURL,"Test", "5211314"); SYSTEM.OUT.PRINTLN ("Connection database succeeded! "); Statement St= Conn.createstatement (); st.executeupdate ("INSERT into Liuyan values (Ly.nextval, '" "+name+" ', ' "+testarea+" ') "); ResultSet RS= St.executequery ("Select* from Liuyan Order by Ly "); while (Rs.next ()) {String ID= rs.getstring (2); String Liuyan= rs.getstring (3); %> <Tablewidth= "100%"Border= "1"> <TRHeight= " the" ><TD>Id:<%=id%></TD></TR> <TRHeight= "Max" ><TD>Message:<%=liuyan%></TD></TR> </Table> <%--out.print("<br>ID: "+ ID +" message: "+liuyan";--%><%} rs.close(); St.close (); Conn.close (); } catch (Exception e) {//TODO auto-generated catch block E.printstacktrace (); }%> </Body></HTML>
Write a simple message book, the ability to add messages and display message content