struts1+jdbc增删改查

最新推荐文章于 2022-10-30 17:38:51 发布
最新推荐文章于 2022-10-30 17:38:51 发布
阅读量1k 收藏 3
点赞数
文章标签： jdbc struts
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhanghe687/article/details/50586871
版权

struts1+jdbc实现增删改查

数据库建表

工程目录

jar包

home.jsp

</head>
<body>
    <a href="http://localhost:8080/myStruts1/login.jsp">登录</a><br/>
    <a href="http://localhost:8080/myStruts1/register.jsp">注册</a>
 
</body>
</html>

login.jsp

<title>登录</title>
</head>
<body>
    <form action="login.do" method="post">
            用户名:<input type="text" name="username">
             密码:<input type="password" name="password">
            <input type="submit" value="登录">
    </form>
    
    <%
    String msg = (String)request.getAttribute("message");
    if(msg != null){
        out.print("<script  language = 'javascript'>alert("+ msg +")</script>");
    }
    %>
</body>

register.jsp

<body>
    <form action="addUser.do" method="post">
                用户名<input type="text" name="username"><br/><br/><br/>
                密码<input type="password" name="password"><br/><br/><br/>
                <input type="submit" value="提交">
                <input type="reset" value="取消">
    </form>
</body>
</html>

success.jsp

<body>
    
    <script language = "javascript">  
      alert("成功！");  
      window.location.href="http://localhost:8080/myStruts1/login.jsp";
      </script>
    
</body>

userList.jsp

<body>
<form action=" " method="post">
    <table border="1">
        <thead >
            <tr>
                <th>编号</th>
                <th>用户名</th>
                <th>密码</th>
                <th colspan="2">操作</th>
            </tr>
        </thead>
        
        <%
           List<User> list= (List) request.getAttribute("users");
           if(list != null){
               Iterator iter = list.iterator();
               while(iter.hasNext()){
                   User user = (User)iter.next();
                   
               %>
        <tbody>
            <tr>
                <td><input type="text" name="id" value="<%=user.getId() %>"></td>
                <td><input type="text" name="username" value="<%=user.getUsername() %>"></td>
                <td><input type="text" name="password" value="<%=user.getPassword() %>"></td>
                <td>
                    <a href="updateUser.do?id=<%=user.getId() %>">修改</a>
                </td>
                 <td>
                    <a href="deleteUser.do?id=<%=user.getId() %>">删除</a>
                </td>
            </tr>
            <%
             }
               
           }
           %>
           <a href="http://localhost:8080/myStruts1/register.jsp">添加</a>
        </tbody>
        
    </table>
   </form>
</body>

oneUserUpdate.jsp

<body>
    <form action="update.do" method="post">
        <table border="1">
            <tr>
                <td>编号</td>
                <td>用户名</td>
                <td>密码</td>
            </tr>
            <tr>
            <%
                User u =(User)request.getAttribute("user");
                
            %>
                   <td><input type="text" name="id" value="<%=u.getId() %>"></td>
                   <td><input type="text" name="username" value="<%=u.getUsername() %>"></td>
                   <td><input type="text" name="password" value="<%=u.getPassword() %>"></td>
                </tr>
        </table>
        <input type="submit" value="确定">
    </form>
</body>

public class User {
    
    private static final long serialVersionUID = -2671034378597589800L;
    private int id;
    private String username;
    private String password;
    
    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 class LoginForm extends ActionForm{
    /**
     *
     */
    private static final long serialVersionUID = 753565084538894694L;
    private int id;
    
    private String username;
    
    private String password;
    
    
    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 class DB {
    public static Connection getConnection() throws SQLException{
        String driverName = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://172.19.1.81/struts1Demo";
        String userName = "root";
        String passWord = "navinfo";
        Connection conn = null;
        try {
            Class.forName(driverName);
            conn = DriverManager.getConnection(url, userName, passWord);
            conn.setAutoCommit(false);//支持事物
            System.out.println("connection success");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }
    
    public static void closeConnection(Connection conn){
        try {
            if(conn != null){
                conn.close();
            }
            conn = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    public static void closeStatement(Statement stmt){
        try {
            if(stmt != null){
                stmt.close();
            }
            stmt = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    
    public static void closeResultSet(ResultSet rs){
        try {
            if(rs != null){
                rs.close();
            }
            rs = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
}

public class AddUserDao {
    public void add(User user){
        Connection conn = null;
        PreparedStatement pstm = null;
        
        try {
            conn = DB.getConnection();
            String sql = "insert into userInfo(username , password) values(?,?)";
            pstm = conn.prepareStatement(sql);
            //pstm.setInt(1, user.getId());
            pstm.setString(1, user.getUsername());
            pstm.setString(2, user.getPassword());
            pstm.executeUpdate();
            System.out.println("*****");
            conn.commit();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

public class DeleteUserDao {
    public boolean delete(int id){
        Connection conn = null;
        PreparedStatement pstm = null;
        int count = 0;
        try {
            conn = DB.getConnection();
            String sql = "delete from userInfo where id = ?";
            pstm = conn.prepareStatement(sql);
            pstm.setInt(1, id);
            count = pstm.executeUpdate();
           conn.commit();
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
                try {
                    if(pstm!= null){
                        pstm.close();}
                    if(conn!=null){
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
       if(count == 0){
           return false;
       }else{
           return true;
       }
    }
}

public class FindAllUserDao {
    public List<User> find(){
        Connection conn = null;
        ResultSet rs = null;
        User user = null;
        List<User> listUser = new ArrayList<User>();
        try {
            conn = DB.getConnection();
            String sql = "select * from userInfo ";
            rs = conn.prepareStatement(sql).executeQuery();
            while(rs.next()){
                user = new User();
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
                listUser.add(user);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return listUser;
    }
}

public class SearchDao {
    public User findByUsername(String username , String password){
        Connection conn = null;
        PreparedStatement pstm = null;
        ResultSet rs = null;
        User user = null;
        try {
            conn = DB.getConnection();
            String sql = "select * from userInfo where username = ? and password = ?";
            pstm = conn.prepareStatement(sql);
            pstm.setString(1, username);
            pstm.setString(2, password);
            rs = pstm.executeQuery();
            if(rs.next()){
                user = new User();
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
                
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return user;
    }
}


public class UpdateUser {
    public void update(User user){
        Connection conn = null;
        PreparedStatement pstm = null;
        try {
            conn = DB.getConnection();
            String sql = "update userInfo set username= ? , password = ? where id = ?";
            pstm = conn.prepareStatement(sql);
            pstm.setString(1, user.getUsername());
            pstm.setString(2, user.getPassword());
            pstm.setInt(3, user.getId());
            pstm.executeUpdate();
            
            conn.commit();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    
    
    public User getUserById(int id){
        Connection  conn = null;
        PreparedStatement pstm = null;
        ResultSet rs = null;
        User user = null;
         try {
            conn = DB.getConnection();
            String sql = "select *　from userInfo where id = ?";
            pstm = conn.prepareStatement(sql);
            pstm.setInt(1,id);
            rs = pstm.executeQuery();
            if(rs.next()){
                user = new User();
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
            }
        } catch (Exception e) {
            e.printStackTrace();
    }
         return user;
    }
}

public class UserByIdDao {
    public User getUserById(int id){
        Connection conn = null;
        PreparedStatement pstm = null;
        ResultSet rs = null;
        User user = null;
        try {
            conn = DB.getConnection();
            String sql = "select * from userInfo where id = ?";
            pstm = conn.prepareStatement(sql);
            pstm.setInt(1, id);
            rs = pstm.executeQuery();
            if(rs.next()){
                user = new User();
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
                
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            DB.closeResultSet(rs);
            DB.closeStatement(pstm);
            DB.closeConnection(conn);
        }
        return user;
    }
}

public class AddAction extends Action{
    
    public ActionForward execute(ActionMapping mapping, ActionForm form,  
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {  
       
        AddUserDao addUserDao = new AddUserDao();
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        
        User user = new User();
        user.setUsername(username);
        user.setPassword(password);
        
        addUserDao.add(user);
        System.out.println("#########");
        return mapping.findForward("add");
    }
}

public class DeleteUserAction extends Action{
    DeleteUserDao deleteUserDao = new DeleteUserDao();
    FindAllUserDao findAllUserDao = new FindAllUserDao();
    @Override
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        String id  = request.getParameter("id");
        int id1 = Integer.parseInt(id);
        deleteUserDao.delete(id1);
        List<User> users = findAllUserDao.find();
        request.setAttribute("users", users);
        return mapping.findForward("success");
    }
    
}

public class FindAllAction extends Action{
    public ActionForward excute(ActionMapping mapping, ActionForm form,  HttpServletRequest request, HttpServletResponse response) throws Exception{
        FindAllUserDao findAllUserDao = new FindAllUserDao();
       List<User> users= findAllUserDao.find();
       request.setAttribute("users", users);
        return mapping.findForward("findAllUser");
    }
}

public class FindUserByIdAction extends Action{

    @Override
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse httpservletresponse)
            throws Exception {
        UserByIdDao userByIdDao = new UserByIdDao();
        String id = request.getParameter("id");
        int id1 = Integer.parseInt(id);
        User u = userByIdDao.getUserById(id1);
        System.out.println(u.getUsername());
        request.setAttribute("user", u);
        return mapping.findForward("success");
    }
    
}
public class LoginAction extends Action{
    @Override  
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
       String str = "";
       /** 1. 获取ActonForm封装的请求对象 */
      // User login = (User) form;
      // System.out.println(login.getUsername());
       SearchDao ser = new SearchDao();
       String username = request.getParameter("username");
       String password = request.getParameter("password");
       User user = ser.findByUsername(username,password);
       if(user == null){
           request.setAttribute("message", "用户名或密码不能为空");
           str = "login";
           
       }else{
           FindAllUserDao findAllUserDao = new FindAllUserDao();
           List<User> users = findAllUserDao.find();
           request.setAttribute("users", users);
           str = "success";
       }
      return mapping.findForward(str);
    }
    
}

public class UpdateAction extends Action{
   
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {  
        
        String id = request.getParameter("id");
        int id1 = Integer.parseInt(id);
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        try {
            UpdateUser updateDao = new UpdateUser();
            User user= new User();
            user.setId(id1);
            user.setUsername(username);
            user.setPassword(password);
            updateDao.update(user);
            System.out.println("%%%%%%%%%%");
        } catch (Exception e) {
            e.printStackTrace();
        }
        FindAllUserDao findAll = new FindAllUserDao();
        List<User> list = findAll.find();
        request.setAttribute("users", list);
        return mapping.findForward("success");
        
    }
}

struts-config.xml

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE struts-config PUBLIC
          "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN"
          "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<!-- 　该元素主要用来配置表单验证的类 -->
    <form-beans>
        <!--  --><form-bean name="loginForm" type = "com.pojo.LoginForm"/>
        <!-- <form-bean name="AddUserForm" type="com.pojo.AddUserForm"/> -->
    </form-beans>

    <global-exceptions>
    </global-exceptions>
    
    <global-forwards>
    </global-forwards>


<!-- =========================================== Action Mapping Definitions -->

    <action-mappings>
          <!-- action标签中的path就是截取到的url，type就是对应的action全路径，name是这个action对应的form。 -->  
         <action path = "/login" name = "User" scope = "request"  type = "com.action.LoginAction" validate = "false">  
                <forward name = "success" path = "/userList.jsp"/>  
                <forward name = "login" path = "/login.jsp"/>  
          </action>
          
          <action path="/addUser" name="AddUserForm" scope="request" type="com.action.AddAction" validate="false">
                <forward name="add" path="/success.jsp"></forward>
          </action>
          
          <action path="/updateUser"  scope="request" type="com.action.FindUserByIdAction" validate="false">
                <forward name="success" path="/oneUserUpdate.jsp"></forward>
          </action>
          
          <action path="/update"  scope="request" type="com.action.UpdateAction" validate="false">
                <forward name="success" path="/userList.jsp"></forward>
          </action>
          
          <action path="/findAllUser"  scope="request" type="com.action.FindAllAction" validate="false">
                <forward name="findAllUser" path="/userList.jsp"></forward>
          </action>
          
           <action path="/deleteUser"  scope="request" type="com.action.DeleteUserAction" validate="false">
                <forward name="success" path="/userList.jsp"></forward>
          </action>

    </action-mappings>
    <message-resources parameter="MessageResources" />
 

</struts-config>


web.xml

 <servlet>
        <servlet-name>action</servlet-name>
        <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
        <init-param>
           <param-name>config</param-name>
           <param-value>/WEB-INF/struts-config.xml</param-value>
        </init-param>
        <load-on-startup>2</load-on-startup>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>action</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>





zhanghe687
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【Struts】数据回显
Evan_QB的博客
10-17 466
本文转自: http://blog.csdn.net/qq_35448976/article/details/64929750 数据回显 数据回显，必须要用struts标签！ Action中： [java] view plain copy  print? // 进入修改页面   public String viewUpd
struts1曾查
slnandhml的专栏
12-04 281
 package s101; import org.apache.struts.action.ActionForm; public class ViewEmpForm extends ActionForm{ Emp emp=new Emp(); public Emp getEmp() { return emp; } public void
JDBC进行数据库的增删改查
weixin_68683361的博客
10-30 3212
JDBC进行数据库的增删改查
struts1利用JDBC实现增删改查
11-27
本人初学Struts1,利用JDBC实现增删改查，功能都能运行出来，希望可以给大家一个帮助
Struts1做的增删改查
01-01
自学struts1，做的用户增，删，改，查。
struts mysql 增删改查_Struts1 增删改查
weixin_35778603的博客
02-11 165
文章说明本篇文章介绍如何使用Struts1进行增删改查，仅是对自己学习的记录，并没有深入分析每个模块(不重复造轮子O(∩_∩)O~)。Tomcat开源的Web应用服务器，apache-tomcat-8.0.35-windows-x64.zip仅有10.3M。启动服务：bin-startup.bat。1.png-28.7kB数据库MySQL建立数据库test，并在其中建立表users。CREATE ...
struts1.2.9+hibernate3.3.1完整数据库表增删改查示例
11-01
MySQL5.1.36,tomcat5.0.28 struts1.2.9,Hibernate3.3.1,struts-tags,JSTL标签库+EL,对数据库表(test.userinfo)增删改查的完整示例. 未用Eclipse或MyEclipse,几乎纯手工实现,含所需库文件. 欢迎大家下载部署,学习. 2009-12-15
struts2+jdbc增删改查
05-20
总的来说，`struts2+jdbc增删改查`的项目是一个适合初学者实践的实例，涵盖了Web开发中基础的数据库操作和业务流程处理。通过这个项目，开发者可以学习到如何在Struts2框架下利用JDBC与数据库交互，同时掌握JSP页面...
struts2+jdbc+jsp增删改查
09-24
在本项目"struts2+jdbc+jsp增删改查"中，开发者使用了Struts2来处理用户请求，通过JDBC（Java Database Connectivity）进行数据库操作，而JSP（JavaServer Pages）则作为视图层，显示数据。这个项目的核心在于实现对...
struts+jdbc增删改查
03-18
总的来说，"struts+jdbc增删改查"这个小案例涵盖了Web开发中基础的数据操作，是学习Java Web开发的典型应用场景。通过这个案例，开发者可以深入理解Struts 2的架构以及如何使用JDBC进行数据库操作，为进一步学习更...
Struts2+jdbc+mysql 实现简单的增删改查(源码+jar包)
10-23
该资源非常适合刚接触struts2的小伙伴，里面有源码个匹配的Struts2的jar包，使用方法见readme.txt。 另外提交数据后，如遇到乱码，请参考： http://blog.csdn.net/xp871038951/article/details/78322799
BBS jsp源码 struts+jdbc技术
03-31
内有数据库文件只需附加进去 按readme.doc说明部署 或直接导入eclipse 发布即可，绝无错误，但是别忘了修改代码中数据库密码 本系统共分为三种操作权限，分别为普通用户、管理员、版主：  普通用户：普通用户只可以发表帖子、回复帖子、查看自己发表的帖子及查看精华帖子。  版主：可以发表帖子、回复帖子、删除自己发布的帖子及帖子回复。  管理员：管理员可以管理用户信息及设置用户权限（普通用户或版主），论坛类别管理、版面管理、发表帖子、删除帖子、设置精华帖了及置顶帖子。
struts简易增删改查
10-14
struts简易的增删改查
JDBC+MVC实现mysql数据增删改查
08-05
JDBC+MVC实现mysql数据增删改查，代码很详细，对初学者很有用
Struts1.2+mysql实现增删改查小程序
01-18
Struts1.2+mysql实现增删改查小程序
Struts2 JDBC 增删改查
12-13
在这个"Struts2 JDBC 增删改查"项目中，我们将探讨如何结合这两者来构建一个简单的数据管理应用。 首先，让我们深入理解Struts2的核心概念。Struts2框架提供了动作（Action）和结果（Result）的概念，动作负责处理...
Struts基本标签
qq_43162517的博客
10-13 157
1、定义baseAction，存放结果码常量，请求、响应、上下文、公用的传值 2、Struts标签的使用 s:iterator S:action S:url S:form s:textfield S:select S:radio S:param s:textarea 1、不直接跳页面，跳子控制器，因为路径问题和*。action配置 2、修改页面弹栈的问题，load出的结果作为跟，属性可以直接取值 ...
详述JDBC实现过程(增删改查)
IT_Helianthus的博客
04-28 569
一、
Struts之增删改查
Cat_Jay_Fish的博客
10-18 317
1、新建maven项目 2、①导入pom.xml依赖，jar依赖；②web.xml改成3.1；③导入struts相关的配置文件 ④jdk1.5->1.8->同时pom.xml需要添加plugins->plugin;⑤web.2.3->3.1； ⑥web.xml中配置核心过滤器StrutsPrepareAndExecuteFilter； 3、导入pom.xml依赖 导入工具类（com.zking.util、com.zking.tag） ...
struts2增删改查项目mysql
最新发布
05-21
下面是一个简单的 Struts2 增删改查项目，使用 MySQL 作为后端数据库： 1. 创建数据库 首先需要创建一个名为 "struts2_crud" 的数据库，然后创建一个名为 "users" 的表，包含以下字段： id INT(11) PRIMARY KEY ...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值