struts mysql 增删改查_Struts2增删改查(完整项目版+源码+数据库) Struts2增删改查代码(完整项目版+源代码+数据库)(Struts 2 - 下载 - 搜珍网...

文件名大小更新时间

Struts2用户登录增删改查(完整)\dd\.classpath12402010-07-16

Struts2用户登录增删改查(完整)\dd\.mymetadata2792009-07-15

Struts2用户登录增删改查(完整)\dd\.project14082010-07-16

Struts2用户登录增删改查(完整)\dd\.settings\.jsdtscope5002010-07-16

Struts2用户登录增删改查(完整)\dd\.settings\org.eclipse.wst.jsdt.ui.superType.container492010-07-16

Struts2用户登录增删改查(完整)\dd\.settings\org.eclipse.wst.jsdt.ui.superType.name62010-07-16

Struts2用户登录增删改查(完整)\dd\datebase\test_Data.MDF10485762010-07-20

Struts2用户登录增删改查(完整)\dd\datebase\test_Log.LDF10485762010-07-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\actions\UserAction.java43852010-07-26

Struts2用户登录增删改查(完整)\dd\src\com\yan\biz\IUserServ.java5412008-07-15

Struts2用户登录增删改查(完整)\dd\src\com\yan\biz\UserServImpl.java18702008-07-15

Struts2用户登录增删改查(完整)\dd\src\com\yan\dao\IUserDao.java6002008-07-15

Struts2用户登录增删改查(完整)\dd\src\com\yan\dao\UserDaoImpl.java59692009-07-15

Struts2用户登录增删改查(完整)\dd\src\com\yan\domain\PageBean.java11222010-07-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\domain\UserBean.java11022008-07-15

Struts2用户登录增删改查(完整)\dd\src\com\yan\utils\DaoFactory.java1902010-07-14

Struts2用户登录增删改查(完整)\dd\src\com\yan\utils\DBConn.java7662010-07-16

Struts2用户登录增删改查(完整)\dd\src\com\yan\utils\ServFactory.java2002010-07-14

Struts2用户登录增删改查(完整)\dd\src\log4j.properties2022010-07-16

Struts2用户登录增删改查(完整)\dd\src\struts-2.1.dtd37652010-07-13

Struts2用户登录增删改查(完整)\dd\src\struts.xml16562010-07-26

Struts2用户登录增删改查(完整)\dd\WebRoot\add_user.jsp42322010-07-26

Struts2用户登录增删改查(完整)\dd\WebRoot\Copy.jsp3772010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\error.jsp5302010-07-14

Struts2用户登录增删改查(完整)\dd\WebRoot\index.jsp14352010-07-17

Struts2用户登录增删改查(完整)\dd\WebRoot\META-INF\MANIFEST.MF392010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\show_user.jsp20302008-07-15

Struts2用户登录增删改查(完整)\dd\WebRoot\success.jsp7212010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\update_user.jsp27322010-07-17

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\actions\UserAction.class57512010-07-26

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\biz\IUserServ.class5862010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\biz\UserServImpl.class26142010-07-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\dao\IUserDao.class7842010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\dao\UserDaoImpl.class68712010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\domain\PageBean.class15652010-07-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\domain\UserBean.class17592010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\utils\DaoFactory.class4112010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\utils\DBConn.class13752010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\utils\ServFactory.class4172010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\log4j.properties2022010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\struts-2.1.dtd37652010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\struts.xml16562010-07-26

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar1886712010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\commons-fileupload-1.2.1.jar577792010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\commons-io-1.3.2.jar877762010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar380152010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\freemarker-2.3.13.jar8702922010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\log4j-1.2.15.jar3918342010-07-16

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\ognl-2.6.11.jar1680812010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\sqljdbc.jar2319492010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\struts2-core-2.1.6.jar7367152010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\struts2-dojo-plugin-2.1.6.jar17285872010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib\xwork-2.1.2.jar22872612010-07-13

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\web.xml9042010-07-17

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\actions02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\biz02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\dao02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\domain02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan\utils02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com\yan02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\actions02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\biz02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\dao02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\domain02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan\utils02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes\com02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com\yan02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\classes02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF\lib02010-09-20

Struts2用户登录增删改查(完整)\dd\src\com02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\META-INF02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot\WEB-INF02010-09-20

Struts2用户登录增删改查(完整)\dd\.myeclipse02010-09-20

Struts2用户登录增删改查(完整)\dd\.settings02010-09-20

Struts2用户登录增删改查(完整)\dd\datebase02010-09-20

Struts2用户登录增删改查(完整)\dd\src02010-09-20

Struts2用户登录增删改查(完整)\dd\WebRoot02010-09-20

Struts2用户登录增删改查(完整)\dd02010-09-20

Struts2用户登录增删改查(完整)02010-09-20

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Struts2 是一个基于 MVC 设计模式的 Web 应用程序框架,可以用于快速开发 Java Web 应用程序,而 MySQL 是一个流行的关系型数据库管理系统,可以存储和管理数据。下面是一个简单的 Struts2 增删改查项目,使用 MySQL 作为后端数据库: 1. 创建数据库 首先需要创建一个名为 "struts2_crud" 的数据库,然后创建一个名为 "users" 的表,包含以下字段: id INT(11) PRIMARY KEY AUTO_INCREMENT name VARCHAR(50) email VARCHAR(50) password VARCHAR(50) 2. 配置 Struts2项目中的 "WEB-INF" 文件夹下创建一个名为 "struts.xml" 的文件,添加以下内容: ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN" "http://struts.apache.org/dtds/struts-2.3.dtd"> <struts> <constant name="struts.devMode" value="true" /> <package name="default" extends="struts-default"> <action name="list" class="com.example.struts2crud.action.ListAction"> <result name="success">/list.jsp</result> </action> <action name="add" class="com.example.struts2crud.action.AddAction"> <result name="input">/add.jsp</result> <result name="success" type="redirectAction">list</result> </action> <action name="edit" class="com.example.struts2crud.action.EditAction"> <result name="input">/edit.jsp</result> <result name="success" type="redirectAction">list</result> </action> <action name="delete" class="com.example.struts2crud.action.DeleteAction" method="execute"> <result name="success" type="redirectAction">list</result> </action> </package> </struts> ``` 此配置文件定义了四个 action,分别是 "list"、"add"、"edit" 和 "delete"。 3. 创建 Java 类 创建以下四个 Java 类,分别对应上述四个 action: ListAction.java: ``` package com.example.struts2crud.action; import java.util.List; import com.example.struts2crud.dao.UserDAO; import com.example.struts2crud.model.User; import com.opensymphony.xwork2.ActionSupport; public class ListAction extends ActionSupport { private static final long serialVersionUID = 1L; private List<User> userList; public String execute() { try { userList = new UserDAO().getAllUsers(); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } public List<User> getUserList() { return userList; } public void setUserList(List<User> userList) { this.userList = userList; } } ``` AddAction.java: ``` package com.example.struts2crud.action; import com.example.struts2crud.dao.UserDAO; import com.example.struts2crud.model.User; import com.opensymphony.xwork2.ActionSupport; public class AddAction extends ActionSupport { private static final long serialVersionUID = 1L; private User user; public String execute() { try { new UserDAO().addUser(user); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } public User getUser() { return user; } public void setUser(User user) { this.user = user; } } ``` EditAction.java: ``` package com.example.struts2crud.action; import com.example.struts2crud.dao.UserDAO; import com.example.struts2crud.model.User; import com.opensymphony.xwork2.ActionSupport; public class EditAction extends ActionSupport { private static final long serialVersionUID = 1L; private User user; public String execute() { try { new UserDAO().updateUser(user); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } public User getUser() { return user; } public void setUser(User user) { this.user = user; } } ``` DeleteAction.java: ``` package com.example.struts2crud.action; import com.example.struts2crud.dao.UserDAO; import com.opensymphony.xwork2.ActionSupport; public class DeleteAction extends ActionSupport { private static final long serialVersionUID = 1L; private int id; public String execute() { try { new UserDAO().deleteUser(id); } catch (Exception e) { e.printStackTrace(); } return SUCCESS; } public int getId() { return id; } public void setId(int id) { this.id = id; } } ``` 4. 创建 JSP 页面 创建以下三个 JSP 页面: list.jsp: ``` <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="s" uri="/struts-tags" %> <html> <head> <title>Struts2 CRUD Example</title> </head> <body> <h2>Users List</h2> <table border="1"> <tr> <th>ID</th> <th>Name</th> <th>Email</th> <th>Password</th> <th>Action</th> </tr> <s:iterator value="userList"> <tr> <td><s:property value="id"/></td> <td><s:property value="name"/></td> <td><s:property value="email"/></td> <td><s:property value="password"/></td> <td> <s:url id="editUrl" action="edit"> <s:param name="user.id" value="%{id}"/> </s:url> <s:url id="deleteUrl" action="delete"> <s:param name="id" value="%{id}"/> </s:url> <s:a href="%{editUrl}">Edit</s:a> <s:a href="%{deleteUrl}">Delete</s:a> </td> </tr> </s:iterator> </table> <br> <s:url id="addUrl" action="add"/> <s:a href="%{addUrl}">Add New User</s:a> </body> </html> ``` add.jsp: ``` <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="s" uri="/struts-tags" %> <html> <head> <title>Struts2 CRUD Example</title> </head> <body> <h2>Add New User</h2> <s:form action="add"> <s:textfield name="user.name" label="Name"/> <s:textfield name="user.email" label="Email"/> <s:textfield name="user.password" label="Password"/> <s:submit value="Save"/> </s:form> <br> <s:url id="listUrl" action="list"/> <s:a href="%{listUrl}">Back to List</s:a> </body> </html> ``` edit.jsp: ``` <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="s" uri="/struts-tags" %> <html> <head> <title>Struts2 CRUD Example</title> </head> <body> <h2>Edit User</h2> <s:form action="edit"> <s:hidden name="user.id"/> <s:textfield name="user.name" label="Name"/> <s:textfield name="user.email" label="Email"/> <s:textfield name="user.password" label="Password"/> <s:submit value="Save"/> </s:form> <br> <s:url id="listUrl" action="list"/> <s:a href="%{listUrl}">Back to List</s:a> </body> </html> ``` 5. 创建 DAO 类 创建一个名为 "UserDAO.java" 的 DAO 类,用于操作数据库: ``` package com.example.struts2crud.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import com.example.struts2crud.model.User; public class UserDAO { public static final String URL = "jdbc:mysql://localhost:3306/struts2_crud"; public static final String USER = "root"; public static final String PASSWORD = "password"; public Connection getConnection() throws Exception { Class.forName("com.mysql.jdbc.Driver"); return DriverManager.getConnection(URL, USER, PASSWORD); } public List<User> getAllUsers() throws Exception { List<User> userList = new ArrayList<>(); String sql = "SELECT * FROM users"; try (Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery()) { while (rs.next()) { User user = new User(); user.setId(rs.getInt("id")); user.setName(rs.getString("name")); user.setEmail(rs.getString("email")); user.setPassword(rs.getString("password")); userList.add(user); } } return userList; } public void addUser(User user) throws Exception { String sql = "INSERT INTO users (name, email, password) VALUES (?, ?, ?)"; try (Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql)) { stmt.setString(1, user.getName()); stmt.setString(2, user.getEmail()); stmt.setString(3, user.getPassword()); stmt.executeUpdate(); } } public void updateUser(User user) throws Exception { String sql = "UPDATE users SET name = ?, email = ?, password = ? WHERE id = ?"; try (Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql)) { stmt.setString(1, user.getName()); stmt.setString(2, user.getEmail()); stmt.setString(3, user.getPassword()); stmt.setInt(4, user.getId()); stmt.executeUpdate(); } } public void deleteUser(int id) throws Exception { String sql = "DELETE FROM users WHERE id = ?"; try (Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql)) { stmt.setInt(1, id); stmt.executeUpdate(); } } } ``` 6. 运行项目 将以上代码保存到项目中,然后启动项目,访问 "http://localhost:8080/项目名/list.action" 即可看到用户列表。可以点击 "Add New User" 按钮添加新用户,点击 "Edit" 按钮编辑用户信息,点击 "Delete" 按钮删除用户。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值