| 留言板 |
|
作者:peter 文章来源:网络转载 点击数: 更新时间:2004-7-11 18:30:56  |
//comment.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <%@page contentType="text/html;charset=gb2312"%>
</HEAD>
<body> <p>Ãû×Ö²»Äܳ¬¹ý20¸ö×Ö,ÁôÑÔ²»Äܳ¬¹ý200¸ö×Ö <form method="POST" action="comment.jsp"> ÄúµÄÃû×Ö£º <input type="text" name="thename" size="20"> <br> ÄúµÄÁôÑÔ£º <br> <textarea rows="6" name="thetextarea" cols="60"></textarea><input type="submit" value="Ìá½»" name="B1"><input type="reset" value="È«²¿ÖØÐ´" name="B2"> </form> </body>
</HTML>
//comment.jsp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> </HEAD>
<BODY> <%@page import="java.sql.*"%> <%@page import="java.lang.*"%> <%@page contentType="text/html;charset=gb2312"%> <center><font color=red><h1><%="ÁôÑÔ°å"%></h1></font></center><hr>
<% //str=new String(request.getParameter("str").getBytes("8859_1"),"gb2312") ½â¾öÊý¾Ý¿âµÄÖÐÎÄÎÊÌâ //String resultname=request.getParameter("thename"); Ô­À´µÄ //String resulttext=request.getParameter("thetextarea");
String resultname=new String(request.getParameter("thename").getBytes("8859_1"),"gb2312"); String resulttext=new String(request.getParameter("thetextarea").getBytes("8859_1"),"gb2312"); int namelen=resultname.length(); int textlen=resulttext.length();
if(namelen<=20&&namelen>0&&textlen<=200&&textlen>0){
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:source_access"); java.sql.Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); String updateorder="insert into comment " +"values('"+resultname+"','"+resulttext+"')";
stmt.executeUpdate(updateorder);
//stmt.executeUpdate("insert into comment values('resultname','resulttext')");
ResultSet rs=stmt.executeQuery("select * from comment"); while(rs.next()) { out.print(rs.getString("name")+" ÁôÏµĻ° "+"<br>"+rs.getString("comment")+ "<hr>"); } } else if(namelen==0) { out.print("Ãû×Ö²»ÄÜΪ¿Õ"); } else if(textlen==0) { out.print("ÁôÑÔ²»ÄÜΪ¿Õ"); } else if(namelen>20) { out.print("Ãû×Ö²»Äܳ¬¹ý20¸ö×Ö"); } else if(textlen>200) { out.print("ÁôÑÔ²»Äܳ¬¹ý200¸ö×Ö"); } else { out.print("ϵͳÕýÔÚÉý¼¶£¬ÇëÉÔºóÔÙÊÔ"); } %> <center><h1><a href="comment.html">·µ»Ø</a></h1></center> </BODY> </HTML>
|
| 文章录入:admin 责任编辑:admin |
|
上一篇文章: jsp访问任意机器上的oracle数据库
下一篇文章: 使用JAXB处理XML文档——先睹为快 |
| 【字体:小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 |