第九章 JSP和Servlet结合的方法.pptVIP

内容提纲 留言板 JSP+JavaBean实现 留言板 JSP+JavaBean+Servlet实现 JSP+JavaBean实现MessageVO.java package com.jspdev.ch9; public class MessageVO implements java.io.Serializable { private String name,email,title,content; private java.sql.Date date;， JSP+JavaBean实现MessageBean.java public class MessageBean { private Connection con; MessageVO msg; public MessageBean(){ String CLASSFORNAME=com.microsoft.jdbc.sqlserver.SQLServerDriver; String SERVANDDB= jdbc:microsoft:sqlserver://:1433;DatabaseName=jspdev; String USER=bn; String PWD=bn; Class.forName(CLASSFORNAME); con = DriverManager.getConnection(SERVANDDB,USER,PWD); } JSP+JavaBean实现MessageBean.java public void addMessage()throws Exception {PreparedStatement stm=con.prepareStatement(insert into message values(?,?,?,?,?)); stm.setString(1,msg.getTitle()); stm.setString(2,msg.getName()); stm.setDate(3,new java.sql.Date(new java.util.Date().getTime())); if((msg.getEmail()).length()==0)stm.setString(5,null); else stm.setString(5,msg.getEmail()); stm.setString(4,msg.getContent()); stm.executeQuery(); con.close(); } JSP+JavaBean实现MessageBean.java public Collection getMessage()throws Exception { Collection ret=new ArrayList(); Statement stm=con.createStatement(); ResultSet result=stm.executeQuery(select count(*) from message); int message_count=0; if(result.next()) {message_count=result.getInt(1); result.close(); } if(message_count0) {result=stm.executeQuery(select * from message order by time desc); JSP+JavaBean实现MessageBean.java while(result.next()){String title=result.getString(title); String name=result.getString(name); String mail=result.getString(mail); String content=result.getString(content); java.sql.Date date=result.getDate(time); MessageVO message=new MessageVO(); message.setName(name); message.setTitle(title); message.setContent(content); message.setDate(date); message.setEmail(mail); ret.add(message);} result.close(); stm.close();con.close();return ret;