struts2编写表单提交简单的（2）
实体
package com.oak.entity;
public class User {
private int id;
private String username;
private String password;
private int sex;
private int age;
private double salary;
private String address;
private String phone;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public double getSalary() {
return salary;
}
public void setSalary(double salary) {
this.salary = salary;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password="
+ password + ", sex=" + sex + ", age=" + age + ", salary=" + salary
+ ", address=" + address + ", phone=" + phone + "]";
}
}
dao层
package com.oak.dao;
import java.util.List;
import com.oak.entity.User;
public interface UserDao {
//登录
public User login(String username,String password);
//列表
public List<User> findAll();
//添加用户数据
public void userAdd(User user);
//删除用户
public User userdelete(int id);
//进入修改页面（回显）
public User usertoupdate(User user);
//用户修改
public void userupdate(User user);
}
daoimpl层
package com.oak.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.oak.dao.UserDao;
import com.oak.entity.User;
import com.oak.utils.DBUtil;
public class UserDaoImpl implements UserDao {
private Connection connection=null;
private PreparedStatement p = null;
private ResultSet set = null;
@Override
public User login(String username, String password) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select * from t_user where username = ? and password = ?";
p = connection.prepareStatement(sql);
p.setString(1, username);
p.setString(2, password);
set = p.executeQuery();
User user = new User();
while(set.next()){
user.setId(set.getInt("id"));
user.setUsername(set.getString("username"));
user.setPassword(set.getString("password"));
user.setSex(set.getInt("sex"));
user.setAge(set.getInt("age"));
user.setSalary(set.getDouble("salary"));
user.setAddress(set.getString("address"));
user.setPhone(set.getString("phone"));
}
return user;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
@Override
public List<User> findAll() {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select * from T_USER";
p = connection.prepareStatement(sql);
set = p.executeQuery();
List<User> list = new ArrayList<User>();
while(set.next()){
User user = new User();
user.setId(set.getInt("id"));
user.setUsername(set.getString("username"));
user.setPassword(set.getString("password"));
user.setSex(set.getInt("sex"));
user.setAge(set.getInt("age"));
user.setSalary(set.getDouble("salary"));
user.setAddress(set.getString("address"));
user.setPhone(set.getString("phone"));
list.add(user);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
@Override
public void userAdd(User user) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "insert into T_USER values(T_USER_seq.nextval,?,?,?,?,?,?,?)";
p = connection.prepareStatement(sql);
p.setString(1, user.getUsername());
p.setString(2, user.getPassword());
p.setInt(3, user.getSex());
p.setInt(4, user.getAge());
p.setDouble(5, user.getSalary());
p.setString(6, user.getAddress());
p.setString(7, user.getPhone() );
p.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public User userdelete(int id) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "delete from T_USER where id=?";
p = connection.prepareStatement(sql);
p.setInt(1, id);
p.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
@Override
public User usertoupdate(User user) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select * from T_USER where id = ?";
p = connection.prepareStatement(sql);
p.setInt(1, user.getId());
set = p.executeQuery();
if(set.next()){
user.setId(set.getInt("id"));
user.setUsername(set.getString("username"));
user.setPassword(set.getString("password"));
user.setSex(set.getInt("sex"));
user.setAge(set.getInt("age"));
user.setSalary(set.getDouble("salary"));
user.setAddress(set.getString("address"));
user.setPhone(set.getString("phone"));
}
return user;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
@Override
public void userupdate(User user) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "update T_USER set username=?,password=?,sex=?,age=?,salary=?,address=?,phone=? where id=?";
p = connection.prepareStatement(sql);
p.setString(1, user.getUsername());
p.setString(2, user.getPassword());
p.setInt(3, user.getSex());
p.setInt(4, user.getAge());
p.setDouble(5, user.getSalary());
p.setString(6, user.getAddress());
p.setString(7, user.getPhone());
p.setInt(8, user.getId());
p.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
servlet
package com.oak.service;
import java.util.List;
import com.oak.entity.User;
public interface UserService {
//登录
public User login(String username, String password);
//列表
public List<User> finfAll();
//添加用户数据
public void userAdd(User user);
//删除用户
public User userdelete(int id);
//进入修改页面
public User usertoupdate(User user);
//用户修改
public void userupdate(User user);
}
servletimpl层
package com.oak.service.impl;
import java.util.List;
import com.oak.dao.UserDao;
import com.oak.dao.impl.UserDaoImpl;
import com.oak.entity.User;
import com.oak.service.UserService;
public class UserServiceImpl implements UserService {
private UserDao userDao = new UserDaoImpl();
@Override
public User login(String username, String password) {
// TODO Auto-generated method stub
return userDao.login(username, password);
}
public UserDao getUserDao() {
return userDao;
}
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public List<User> finfAll() {
// TODO Auto-generated method stub
return userDao.findAll();
}
@Override
public void userAdd(User user) {
// TODO Auto-generated method stub
userDao.userAdd(user);
}
@Override
public User userdelete(int id) {
// TODO Auto-generated method stub
userDao.userdelete(id);
return userDao.userdelete(id);
}
@Override
public User usertoupdate(User user) {
// TODO Auto-generated method stub
return userDao.usertoupdate(user);
}
@Override
public void userupdate(User user) {
// TODO Auto-generated method stub
userDao.userupdate(user);
}
}
action
package com.oak.action;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.apache.struts2.ServletActionContext;
import com.oak.entity.User;
import com.oak.service.UserService;
import com.oak.service.impl.UserServiceImpl;
import com.opensymphony.xwork2.ActionSupport;
public class UserAction extends ActionSupport {
private User user;
private User u;
private User uu;
private String cod;
private List<User> userlist;
private UserService userService = new UserServiceImpl();
//登录
public String login(){
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("username", user.getUsername());
HttpSession session = request.getSession();
session.setAttribute("user", user.getUsername());
u = userService.login(
user.getUsername(),
user.getPassword());
if(u.getUsername() != null){
return SUCCESS;
}else {
return ERROR;
}
}
//表单
public String list(){
userlist=userService.finfAll();
return SUCCESS;
}
//增加
public String userAdd(){
userService.userAdd(user);
return SUCCESS;
}
//删除
public String userdelete(){
uu = userService.userdelete(user.getId());
return SUCCESS;
}
//进入修改页面
public String usertoupdate(){
userService.usertoupdate(user);
return SUCCESS;
}
//修改
public String userupdate(){
userService.userupdate(user);
return SUCCESS;
}
//全局变量getset方法
}
struts.xml
<package name="word" namespace="/" extends="struts-default">
<default-action-ref name="errorAction"></default-action-ref>
<action name="logindemo" class="com.oak.action.UserAction" method="login">
<result name="success">
/admin_index.jsp
</result>
<result name="error">
/login.jsp
</result>
</action>
<!-- 用户管理 -->
<action name="user_list" class="com.oak.action.UserAction" method="list">
<result name="success">
/userAdmin.jsp
</result>
</action>
<!-- 用户添加 -->
<action name="user_add" class="com.oak.action.UserAction" method="userAdd">
<result name="success" type="redirectAction">
user_list
</result>
</action>
<!-- 用户删除 -->
<action name="user_delete" class="com.oak.action.UserAction" method="userdelete">
<result name="success" type="redirectAction">
user_list
</result>
</action>
<!-- 用户修改页面 -->
<action name="user_toupdate" class="com.oak.action.UserAction" method="usertoupdate">
<result name="success">
/toupdate.jsp
</result>
</action>
<!-- 用户修改 -->
<action name="user_update" class="com.oak.action.UserAction" method="userupdate">
<result name="success" type="redirectAction">
user_list
</result>
</action>
<!-- 姓名查询 -->
<action name="user_read" class="com.oak.action.UserAction" method="usertoupdate">
<result name="success" >
/usernametoupdate.jsp
</result>
</action>
</package>
