JAVA写的留言板原代码.rar_Java代码留言本_Java留言板_java留言板_留言板_留言板JAVA

共2个文件

txt：2个

版权申诉

java留言板

留言板

82 浏览量 2022-09-22 16:25:35 上传评论收藏 4KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

JAVA写的留言板原代码.rar （2个子文件）

新建文本文档.txt 11KB

www.pudn.com.txt 218B

/* * guestbookServlet.java * * Created on 2001年4月6日, 下午3:01 */ import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.util.Date; /** * * @author 吕武杰 * 请尊重作者的劳动 * @version 1.0 */ public class guestbookServlet extends HttpServlet { boolean debug=false; String sDBDriver; Connection conn=null; ResultSet rs=null; /** Initializes the servlet. */ public void init(ServletConfig config) throws ServletException { super.init(config); if(debug) sDBDriver=new String("sun.jdbc.odbc.JdbcOdbcDriver"); else sDBDriver=new String("org.gjt.mm.mysql.Driver"); try{ Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e){ System.err.println("Driver类初始化:"+e.getMessage()); } } /** Destroys the servlet. */ public void destroy() { } /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException { response.setContentType("text/html;charset=gb2312"); java.io.PrintWriter out = response.getWriter(); boolean empty=true; boolean noResult=true; String sqlStr; int currentPage=0; int totalPage=0; int reccount=0; ResultSet myrs=null; String username=request.getParameter("username"); String email=request.getParameter("email"); String ucontent=request.getParameter("ucontent"); String ipage=request.getParameter("ipage"); if(ipage==null||ipage.length()==0) currentPage=1; else currentPage=Integer.parseInt(ipage); if((username==null||username.length()==0)||(ucontent==null||ucontent.length()==0))empty=true; else empty=false; Date myDate=new Date(); //String intime=new String(String.valueOf(myDate.getYear()+1990)+String.valueOf(myDate.getMonth())); String year=String.valueOf(myDate.getYear()+1900); String month=String.valueOf(myDate.getMonth()+1); if(month.length()==1) month=new String("0"+month); String days=String.valueOf(myDate.getDate()); if(days.length()==1) days=new String("0"+days); String hours=String.valueOf(myDate.getHours()); if(hours.length()==1) hours=new String("0"+hours); String minutes=String.valueOf(myDate.getMinutes()); if(minutes.length()==1) minutes=new String("0"+minutes); String intime=year+"-"+month+"-"+days+" "+hours+":"+minutes; if(email==null||email.length()==0) email=new String(""); if(!empty){ //username=convert(username); //email=convert(email); //ucontent=convert(ucontent); sqlStr="insert into Mintegbook(Mname,Memail,Mcontent,Mtime,Mid) values("+username+","+email+","+ucontent+","+intime+",1)"; getDsnConn(); executeInsert(sqlStr); } sqlStr=new String("select Mname,Memail,Mcontent,Mtime from Mintegbook order by Mtime DESC"); getDsnConn(); reccount=getRecordCount("Mintegbook"); if(reccount==0) noResult=true; else noResult=false; if(!noResult){ int ipageSize=10; totalPage=getTotalPage("Mintegbook",ipageSize); if(currentPage>totalPage) currentPage=totalPage; int cursor=(currentPage-1)*ipageSize+1; try{ myrs=executeScrollableQuery(sqlStr); myrs.absolute(cursor); } catch(SQLException e){ noResult=true; } } out.println("<HTML><HEAD><TITLE>我的Servlet留言板</TITLE>"); out.println("<META http-equiv="Content-Type" content="text/html; charset=gb2312">"); out.println("<STYLE type="text/css">"); out.println(""); out.println("</STYLE>"); out.println("</HEAD>"); out.println("<BODY bgcolor="#FFFFFF" text="#000000">"); out.println("<TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext">"); out.println("<TR><TD height="22"> | <a href="http://www.vcdoor.com">我的主页</a> | 我的Servlet留言板(<A href="mailto:yf188@21cn.com">川石</A>制作)</TD></TR>"); out.println("<TR><TD height="1" bgcolor="#999933"></TD></TR>"); out.println("</TABLE>"); out.println("<BR>"); out.println("<TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext">"); out.println("<TR><TD height="8"></TD></TR>"); out.println("<TR><TD height="18" bgcolor="#f7f7f7"><DIV align="right">"); out.println("共有 "+reccount + " 条留言 "); out.println(" 当前第<font color=#ff0000>"+currentPage+"</font>/共 "+totalPage+" 页 "); if(currentPage>1) out.println(" <a href=guestbookServlet?ipage=1>首页</a> <a href=guestbookServlet?ipage="+(currentPage-1)+">上一页</a> "); else out.println(" 首页上一页 "); if(currentPage<totalPage) out.println(" <a href=guestbookServlet?ipage="+(currentPage+1)+">下一页</a> <a href=guestbookServlet?ipage="+totalPage+">末页</a> "); else out.println(" 下一页末页 "); out.println("</DIV></TD></TR>"); out.println("</TABLE>"); out.println("<BR>"); //这里是显示留言内容 if(!noResult){ String dname; String demail; String dcontent; String dtime; Date temptime; try{ do{ dname=new String(myrs.getString("Mname")); demail=new String(myrs.getString("Memail")); dcontent=new String(myrs.getString("Mcontent")); try{ dtime=new String(myrs.getObject("Mtime").toString()); } catch(java.lang.NullPointerException e){ dtime=new String("2001-04-06 12:30"); } if(dname==null) dname=new String("川石"); if(demail==null) demail=new String("yf188@21cn.com"); if(dcontent==null) dcontent=new String("test"); if(dtime==null) dtime=new String("2001-04-06 12:30"); dname=convert(dname); dcontent=convert(dcontent); //temptime=myrs.getDate("Mtime"); /* String tempyear=String.valueOf(temptime.getYear()+1900); String tempmonth=String.valueOf(temptime.getMonth()+1); if(tempmonth.length()==1) tempmonth=new String("0"+tempmonth); String tempdays=String.valueOf(temptime.getDate()); if(tempdays.length()==1) tempdays=new String("0"+tempdays); String tempminute=String.valueOf(temptime.getMinutes()); if(tempminute.length()==1) tempminute=new String("0"+tempminute); String temphours=String.valueOf(temptime.getHours()); if(temphours.length()==1) temphours=new String("0"+temphours); String dtime=tempyear+" 年 "+ tempmonth +" 月 "+ tempdays +" 日 " + temphours+ " 时 "+ tempminute + " 分 "; */ out.println("<TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext">"); out.println("<TR><TD>姓名 <A href="mailto:"+demail+"">"+dname+"</A> 留言时间："+dtime+"</TD></TR>"); out.println("<TR><TD height="10"></TD></TR>"); out.println("<TR><TD height="10">"+dcontent+"</TD></TR>"); out.println("</TABLE>"); out.println("<HR width="600" size="1">"); }while(myrs.next());} catch(SQLException e){ out.println("error found"); } } else{ out.println("还没有留言！"); } //结束 out.println("<FORM name="form1" method="post" action="guestbookServlet">"); out.println("<TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext">"); out.println("<TR><TD width="80">姓名:</TD><TD><INPUT type="text" name="username">*</TD></TR>"); out.println("<TR><TD>Email:</TD><TD><INPUT type="text" name="email">*</TD></TR>"); out.println("<TR><TD>留言：</TD><TD><TEXTAREA name="ucontent" cols="65" rows="4"></TEXTAREA></TD></TR>"); out.println("</TABLE>"); out.println("<TABLE width="400" border="0" cellspacing="0" cellpadding="6" align="CENTER" class="mytext">"); out.println("<TR><TD height="15" width="200"> </TD><TD> </TD></TR>"); out.println("<TR><TD><DIV align="RIGHT"><INPUT type="button" name="Button" value=" 提交 " style="cursor:hand" onclick="javascript:check()"></DIV></TD>"); out.println("<TD><INPUT type="reset" name="Submit2" value=" 重置 "></TD></TR>"); out.println("</TABLE>"); out.println("</FORM>"); out.println("<TABLE width="400" border

评论收藏

内容反馈

版权申诉