根据id修改数据库内容

清疚 2023-06-20 10:46 13阅读 0赞

## 修改数据库内容 ##

配置数据库

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql:///test
    jdbc.user=root
    jdbc.pwd=123456

创建实体类

/**
     * 
     */
    package entity;
    
    /**
     * @author xiao
     *
     */
    public class User {
        
              private String uname;
              private String uid;
              private String sal;
    		public String getUname() {
        
    			return uname;
    		}
    		public void setUname(String uname) {
        
    			this.uname = uname;
    		}
    		public String getUid() {
        
    			return uid;
    		}
    		public void setUid(String uid) {
        
    			this.uid = uid;
    		}
    		public String getSal() {
        
    			return sal;
    		}
    		public void setSal(String sal) {
        
    			this.sal = sal;
    		}
    		@Override
    		public String toString() {
        
    			return "User [uname=" + uname + ", uid=" + uid + ", sal=" + sal + "]";
    		}
              
    }

连接数据库

/**
     * 
     */
    package dao;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    
    import utils.JdbcUtils;
    
    /**
     * @author xiao
     *
     */
    public class Del {
        
    	public void Del(int uid ,String sal) {
        
    		  Connection conn=null;
    		  PreparedStatement ps=null;
    		  try {
        
    			conn=JdbcUtils.getConnection();
    			String sql="update user set sal=? where uid=?";
    			ps=conn.prepareStatement(sql);
    			ps.setString(1, sal);
    			ps.setInt(2, uid);
    			int s=ps.executeUpdate();
    		     if(s>0){
        
    	                System.out.println("修改成功");
    	            }else{
        
    	                System.out.println("修改失败");
    	            }
    		} catch (Exception e) {
        
    			e.printStackTrace();		
    		}finally {
        
    			JdbcUtils.release(conn, ps, null);
    		}
    	}
    
    }

servlet方法

package dao;
    
    import java.io.IOException;
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    /**
     * Servlet implementation class UpDao
     */
    @WebServlet("/UpDao")
    public class UpDao extends HttpServlet {
        
    	
    	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
    		Del del =new Del();
    		String uid = request.getParameter("uid");
    		String sal = request.getParameter("sal");
    		int i = Integer.parseInt(uid);
    		del.Del(i, sal);
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
    	 */
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
    		// TODO Auto-generated method stub
    		doGet(request, response);
    	}
    
    }

jsp前台代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>修改页面</title>
    </head>
    <body>
    <form action="UpDao"  method="post">
    要修改的id：<input type="text" name="uid"><br/>
    要修改的工资：<input type="text" name="sal"><br/>
    <input type="submit"  value="确认">
    
    </form>
    </body>
    </html>