求助：用MVC做登录加留言
0
悬赏园豆：50
[待解决问题]
本人是信管专业的，最近学的JAVA要做个小作业。由于我学的不深，所以选择用MVC完成一个可以登录且可以留言并可以显示留言的网页。但是在JAVA部分老是出错，现在怎么找也找不到错误，所以跑来求助大伙了！本人第一次发帖求助，希望有人来帮忙~很急啊~~在这里先谢谢大家了！！
下面是我的源代码，还有编译的错误，大家帮忙看看是怎么回事啊~~
Partner.java
1 package my.big.vo ; 2 import java.util.* ; 3 public class Partner { 4 private String pname ; 5 private String pid ; 6 private String call ; 7 private String phone ; 8 private String qq ; 9 private List errors ; 10 11 public String getPname() { 12 return this.pname ; 13 } 14 public String getPid() { 15 return this.pid ; 16 } 17 public String getCall() { 18 return this.call ; 19 } 20 public String getPhone() { 21 return this.phone ; 22 } 23 public String getQq() { 24 return this.qq ; 25 } 26 public List getErrors() { 27 return this.errors ; 28 } 29 30 public void setPname(String pname) { 31 this.pname = pname ; 32 } 33 public void setPid(String pid) { 34 this.pid = pid ; 35 } 36 public void setCall(String call) { 37 this.call = call ; 38 } 39 public void setPhone(String phone) { 40 this.phone = phone ; 41 } 42 public void setQq(String qq) { 43 this.qq = qq ; 44 } 45 public void setErrors(List errors) { 46 this.errors = errors ; 47 } 48 49 public boolean isEmpty() { 50 boolean iserror=false; 51 if(this.pid==null || "".equals(this.pid)) { 52 53 iserror=true; 54 this.errors.add("用户名不能为空！"); 55 } 56 if(this.qq==null || "".equals(this.qq)) { 57 58 iserror=true; 59 this.errors.add("密码不能为空！"); 60 } 61 return iserror; 62 } 63 }
Message.java
1 package my.big.vo ; 2 import java.util.* ; 3 public class Message { 4 private String pname ; 5 private String pubdate ; 6 private String content ; 7 private List errors ; 8 9 public String getPname() { 10 return this.pname ; 11 } 12 public String getPubdate() { 13 return this.pubdate ; 14 } 15 public String getContent() { 16 return this.content ; 17 } 18 public List getErrors() { 19 return this.errors ; 20 } 21 22 public void setPname(String pname) { 23 this.pname = pname ; 24 } 25 public void setPubdate(String pubdate) { 26 this.pubdate = pubdate ; 27 } 28 public void setContent(String content) { 29 this.content = content ; 30 } 31 public void setErrors(List errors) { 32 this.errors = errors ; 33 } 34 35 public boolean isEmpty() { 36 boolean iserror=false; 37 if(this.content==null || "".equals(this.content)) { 38 iserror=true; 39 this.errors.add("内容不能为空！"); 40 } 41 return iserror; 42 } 43 }
DatabaseConnection.java
1 package my.big.dbc ; 2 import java.sql.* ; 3 public class DatabaseConnection{ 4 private static final String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ; 5 private static final String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bcgm" ; 6 private static final String DBUSER = "sa" ; 7 private static final String DBPASSWORD = "woaiputao" ; 8 private Connection conn ; 9 10 public DatabaseConnection() throws Exception { 11 try 12 { 13 Class.forName(DBDRIVER) ; 14 this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ; 15 } 16 catch (Exception e) 17 { 18 throw e ; 19 } 20 } 21 22 public Connection getConnection(){ 23 return this.conn ; 24 } 25 26 public void close() throws Exception { 27 if (this.conn != null) 28 { 29 try 30 { 31 this.conn.close() ; 32 } 33 catch (Exception e) 34 { 35 throw e ; 36 } 37 } 38 } 39 }
IPartnerDAO.java
1 package my.big.dao ; 2 import java.util.* ; 3 import my.big.vo.* ; 4 public interface IPartnerDAO { 5 6 public boolean findLogin(Partner partner) throws Exception ; 7 8 public List<Partner> findAll(String keyWord) throws Exception ; 9 }
IMessageDAO.java
1 package my.big.dao ; 2 import java.util.* ; 3 import my.big.vo.* ; 4 public interface IMessageDAO { 5 6 public boolean addMessage(Message message) throws Exception ; 7 8 }
PartnerDAOImpl.java
1 package my.big.dao.impl ; 2 import java.util.* ; 3 import java.sql.* ; 4 import my.big.dao.* ; 5 import my.big.vo.* ; 6 public class PartnerDAOImpl implements IPartnerDAO { 7 private Connection conn = null ; 8 private PreparedStatement pstmt = null ; 9 10 public PartnerDAOImpl(Connection conn) { 11 this.conn = conn ; 12 } 13 14 public boolean findLogin(Partner partner) throws Exception { 15 boolean flag = false ; 16 try{ 17 String sql = "SELECT call FROM partner WHERE pid=? AND qq=?" ; 18 this.pstmt = this.conn.prepareStatement(sql) ; 19 this.pstmt.setString(1,partner.getPid()) ; 20 this.pstmt.setString(2,partner.getQq()) ; 21 ResultSet rs = this.pstmt.executeQuery() ; 22 if (rs.next()) { 23 partner.setCall(rs.getString(1)) ; 24 flag = true ; 25 } 26 if (this.pstmt != null) { 27 this.pstmt.close() ; 28 } 29 }catch (Exception e){ 30 throw e ; 31 } 32 33 return flag ; 34 } 35 36 public List<Partner> findAll(String keyWord) throws Exception{ 37 List<Partner> all = new ArrayList<Partner>() ; 38 try{ 39 String sql = "SELECT pname,pid,call,phone,qq FROM partner WHERE pid LIKE ? OR qq LIKE ?" ; 40 this.pstmt = this.conn.prepareStatement(sql) ; 41 this.pstmt.setString(1,"%" + keyWord + "%") ; 42 this.pstmt.setString(2,"%" + keyWord + "%") ; 43 ResultSet rs = this.pstmt.executeQuery() ; 44 Partner partner = null ; 45 while (rs.next()) 46 { 47 partner = new Partner() ; 48 partner.setPname(rs.getString(1)) ; 49 partner.setPid(rs.getString(2)) ; 50 partner.setCall(rs.getString(3)) ; 51 partner.setPhone(rs.getString(4)) ; 52 partner.setQq(rs.getString(5)) ; 53 all.add(partner) ; 54 } 55 this.pstmt.close() ; 56 }catch (Exception e){ 57 throw e ; 58 } 59 60 return all ; 61 } 62 }
MessageDAOImpl.java
1 package my.big.dao.impl ; 2 import java.util.* ; 3 import java.sql.* ; 4 import my.big.dao.* ; 5 import my.big.vo.* ; 6 public class MessageDAOImpl implements IMessageDAO { 7 private Connection conn = null ; 8 private PreparedStatement pstmt = null ; 9 10 public MessageDAOImpl(Connection conn) { 11 this.conn = conn ; 12 } 13 14 public boolean addMessage(Message message) throws Exception { 15 boolean flag = false ; 16 try{ 17 String sql = "SELECT pname FROM message WHERE pubdate=? AND content=?" ; 18 this.pstmt = this.conn.prepareStatement(sql) ; 19 this.pstmt.setString(1,message.getPubdate()) ; 20 this.pstmt.setString(2,message.getContent()) ; 21 ResultSet rs = this.pstmt.executeQuery() ; 22 if (rs.next()) { 23 message.setPubdate(rs.getString(1)) ; 24 flag = true ; 25 } 26 if (this.pstmt != null) { 27 this.pstmt.close() ; 28 } 29 }catch (Exception e){ 30 throw e ; 31 } 32 33 return flag ; 34 } 35 }
PartnerDAOProxy.java
1 package my.big.dao.proxy ; 2 import java.util.* ; 3 import my.big.dao.* ; 4 import my.big.dao.impl.* ; 5 import my.big.dbc.* ; 6 import my.big.vo.* ; 7 public class PartnerDAOProxy implements IPartnerDAO { 8 private DatabaseConnection dbc = null ; 9 private IPartnerDAO dao = null ; 10 public PartnerDAOProxy(){ 11 try 12 { 13 this.dbc = new DatabaseConnection() ; 14 } 15 catch (Exception e) 16 { 17 e.printStackTrace() ; 18 } 19 this.dao = new PartnerDAOImpl(this.dbc.getConnection()) ; 20 } 21 22 public boolean findLogin(Partner partner) throws Exception { 23 boolean flag = false ; 24 try 25 { 26 flag = this.dao.findLogin(partner) ; 27 } 28 catch (Exception e) 29 { 30 throw e ; 31 } finally { 32 this.dbc.close() ; 33 } 34 return flag ; 35 } 36 37 public List<Partner> findAll(String keyWord) throws Exception{ 38 List<Partner> all = null ; 39 try 40 { 41 all = this.dao.findAll(keyWord) ; 42 } 43 catch (Exception e) 44 { 45 throw e ; 46 } 47 finally 48 { 49 this.dbc.close() ; 50 } 51 52 return all ; 53 } 54 }
MessageDAOProxy.java
1 package my.big.dao.proxy ; 2 import java.util.* ; 3 import my.big.dao.* ; 4 import my.big.dao.impl.* ; 5 import my.big.dbc.* ; 6 import my.big.vo.* ; 7 public class MessageDAOProxy implements IMessageDAO { 8 private DatabaseConnection dbc = null ; 9 private IMessageDAO dao = null ; 10 public MessageDAOProxy(){ 11 try 12 { 13 this.dbc = new DatabaseConnection() ; 14 } 15 catch (Exception e) 16 { 17 e.printStackTrace() ; 18 } 19 this.dao = new MessageDAOImpl(this.dbc.getConnection()) ; 20 } 21 22 public boolean addMessage(Message message) throws Exception { 23 boolean flag = false ; 24 try 25 { 26 flag = this.dao.addMessage(message) ; 27 } 28 catch (Exception e) 29 { 30 throw e ; 31 } finally { 32 this.dbc.close() ; 33 } 34 return flag ; 35 } 36 37 }
DAOFactory.java
1 package my.big.factory ; 2 import my.big.dao.* ; 3 import my.big.dao.proxy.* ; 4 public class DAOFactory { 5 public static IPartnerDAO getIPartnerDAOInstance() { 6 return new PartnerDAOProxy() ; 7 } 8 9 public static IMessageDAO getIMessageDAOInstance() { 10 return new MessageDAOProxy() ; 11 } 12 }
CheckPartner.java
1 package my.big.servlet ; 2 import java.util.* ; 3 import java.io.* ; 4 import javax.servlet.* ; 5 import javax.servlet.http.* ; 6 import my.big.factory.* ; 7 import my.big.vo.* ; 8 public class CheckPartner extends HttpServlet { 9 10 public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { 11 String path = "login.jsp" ; 12 13 String pid = request.getParameter("pid"); 14 String qq = request.getParameter("qq"); 15 String call = request.getParameter("call"); 16 List errors=new ArrayList(); 17 Partner partner=new Partner(); 18 partner.setPid(pid); 19 partner.setQq(qq); 20 partner.setCall(call); 21 partner.setErrors(errors); 22 23 if(!partner.isEmpty()) { 24 try{ 25 if(DAOFactory.getIPartnerDAOInstance().findLogin(partner)){ 26 path="welcome.jsp"; 27 request.getSession().setAttribute("pid",partner.getPid()); 28 request.getSession().setAttribute("call",partner.getCall()); 29 } 30 else { 31 errors.add("用户名或密码错误！"); 32 } 33 } catch(Exception e) { 34 System.out.println(e); 35 } 36 } 37 request.setAttribute("errors", errors); 38 request.setAttribute("partner", partner); 39 request.getRequestDispatcher(path).forward(request, response); 40 } 41 42 public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { 43 this.doGet(request,response) ; 44 } 45 }
AddMessage.java
1 package my.big.servlet ; 2 import java.util.* ; 3 import java.io.* ; 4 import javax.servlet.* ; 5 import javax.servlet.http.* ; 6 import my.big.factory.* ; 7 import my.big.vo.* ; 8 public class AddMessage extends HttpServlet { 9 10 public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { 11 String path = "home.jsp" ; 12 String pubdate = request.getPubdate("pubdate"); 13 String content = request.getContent("content"); 14 String pname = request.getPname("pname"); 15 List errors=new ArrayList(); 16 Message message=new Message(); 17 message.setPubdate(pubdate); 18 message.setContent(content); 19 message.setPname(pname); 20 message.setErrors(errors); 21 22 if(!message.isEmpty()) { 23 try{ 24 if(DAOFactory.getIMessageDAOInstance().addMessage(message)){ 25 path="addtrue.jsp"; 26 request.getSession().setAttribute("pname",message.getPname()); 27 request.getSession().setAttribute("pubdate",message.getPubdate()); 28 request.getSession().setAttribute("content",message.getContent()); 29 } 30 else { 31 errors.add("程序未知错误！"); 32 } 33 } catch(Exception e) { 34 System.out.println(e); 35 } 36 } 37 request.setAttribute("errors", errors); 38 request.setAttribute("message", message); 39 request.getRequestDispatcher(path).forward(request, response); 40 } 41 42 public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { 43 this.doGet(request,response) ; 44 } 45 }
这是我出错我地方：（晕，这里怎么上传本地图片的？）
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\本草纲目>E:
E:\>cd bcgm\web-inf\classes
E:\bcgm\WEB-INF\classes>javac -d . *.java
AddMessage.java:12: 错误: 找不到符号
String pubdate = request.getPubdate("pubdate");
^
符号: 方法 getPubdate(String)
位置: 类型为HttpServletRequest的变量 request
AddMessage.java:13: 错误: 找不到符号
String content = request.getContent("content");
^
符号: 方法 getContent(String)
位置: 类型为HttpServletRequest的变量 request
AddMessage.java:14: 错误: 找不到符号
String pname = request.getPname("pname");
^
符号: 方法 getPname(String)
位置: 类型为HttpServletRequest的变量 request
注: 某些输入文件使用了未经检查或不安全的操作。
注: 有关详细信息, 请使用 -Xlint:unchecked 重新编译。
3 个错误
我的JSP就先不上传了。因为上面的编译已经出错了，但是我不知道怎么修改。大家帮帮忙啊~~
顺便补充一下，我想实现的是，有一个登录页面，登录成功后转跳到主界面，主界面有类似与QQ空间发表说说的那样，可以发表说说，发表框下面是显示说说的内容，可以显示用户名时间和说说内容，用户我已经弄好了，是我宿舍的八个人。
我向请教下，我上面的代码能实现么？说说的内容是如何处理的？我对数据库不太熟悉。说说的内容是如何保存的？又是如何按照时间先后顺序显示的？大家给个思路吧~或者有空的话帮解决下~
补上我的数据库表：
CREATE TABLE partner(
pname VARCHAR(30),
pid VARCHAR(12) PRIMARY KEY,
call VARCHAR(20),
phone VARCHAR(11),
qq VARCHAR(10),
) ;
CREATE TABLE message(
pname VARCHAR(30),
pubdate smalldatetime PRIMARY KEY,
content ntext,
) ;
这样子可以实现吗？
谢谢大家了！！
