然后是朋友管理模块。有增删改查等功能。
添加朋友。AddFriAction.java 当输入朋友的姓名后,会从数据库 中检索是否存在此姓名的朋友。
然后在execute()方法中,获取登录用户名。insertFri()方法把朋友的信息添加到数据库。
package edu.friendManager.Action;
import DBJavaBean.DB;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;
//import javax.swing.JOptionPane;
import org.apache.struts2.interceptor.ServletRequestAware;
public class AddFriAction extends ActionSupport implements ServletRequestAware{
private String name;
private String phone;
private String email;
private String workplace;
private String place;
private String QQ;
private ResultSet rs=null;
private String message="ERROR";
private HttpServletRequest request;
private String userName=null;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getWorkplace() {
return workplace;
}
public void setWorkplace(String workplace) {
this.workplace = workplace;
}
public String getPlace() {
return place;
}
public void setPlace(String place) {
this.place = place;
}
public String getQQ() {
return QQ;
}
public void setQQ(String QQ) {
this.QQ = QQ;
}
@Override
public void setServletRequest(HttpServletRequest hsr) {
request=hsr;
}
// public void message(String msg){
// int type=JOptionPane.YES_NO_OPTION;
// String title="信息提示";
// JOptionPane.showMessageDialog(null,msg,title,type);
// }
@Override
public void validate(){
if(getName()==null||getName().length()==0){
addFieldError("name","用户姓名不允许为空");
}else{
try {
DB mysql=new DB();
userName=mysql.returnLogin(request);
rs=mysql.selectFri(request, userName, this.getName());
if(rs.next()){
addFieldError("name","此用户已存在!");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
if(getPhone()==null||getPhone().length()==0){
addFieldError("phone","用户电话不允许为空");
}
if(getEmail()==null||getEmail().length()==0){
addFieldError("email","邮箱地址不允许为空");
}
if(getWorkplace()==null||getWorkplace().length()==0){
addFieldError("workplace","工作单位不允许为空");
}
if(getPlace()==null||getPlace().length()==0){
addFieldError("place","家庭住址不允许为空");
}
if(getQQ()==null||getQQ().length()==0){
addFieldError("QQ","用户QQ不允许为空");
}
}
public String execute() throws Exception{
DB mysql=new DB();
userName=mysql.returnLogin(request);
String fri=mysql.insertFri(request, userName, this.getName(), this.getPhone(), this.getEmail(), this.getWorkplace(), this.getPlace(), this.getQQ());
if(fri.equals("ok")){
message="SUCCESS";
}else if(fri.equals("one")){
message="input";
}
return message;
}
}
addFriend.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title><s:text name="个人信息管理系统->增加联系人"></s:text></title>
</head>
<body bgcolor="gray">
<hr noshade/>
<s:div align="center">
<s:form action="findFriAction" method="post">
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center">
<tr>
<td width="33%">
<s:text name="增加联系人"></s:text>
</td>
<td width="33%">
<s:a href="http://localhost:8080/ch04/friendManager/lookFriends.jsp">查看联系人</s:a>
</td>
<td width="33%">
<s:text name="修删联系人:"></s:text>
<input type="text" name="friendname"/>
<input type="submit" value="查找"/>
</td>
</tr>
</table>
</s:form>