java代码:
package com.wangbingan.item;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class UpdateServlet extends HttpServlet {
private static final long serialVersionUID = 2990382094829126713L;
public void doPost(HttpServletRequest request, HttpServletResponse response) {
// 数据库链接
Connection conn = null;
// 执行sql方法
Statement stmt = null;
// 收集参数
String id = request.getParameter("id");
String name = request.getParameter("name");
String phone = request.getParameter("phone");
try {
// 加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
// 获取数据库链接
conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3307/test", "root", "wangbingan");
// 获取sql执行方法
stmt = conn.createStatement();
// 执行sql
int result = stmt.executeUpdate("update best set name=" + name
+ ",phone=" + phone + " where id=" + id);
if (result != 0) {
System.out.println("[OK]");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
// 关闭链接
try {
conn.close();
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response) {
this.doPost(request, response);
}
}