根据id修改数据库内容
修改数据库内容
配置数据库
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>