package edu.hwadee.pro.control;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import edu.hwadee.pro.bean.sql_data;
public class updateServlet extends HttpServlet {
/**
* Constructor of the object.
*/
public updateServlet() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String aa = null, bb = null, cc = null, dd = null;
aa = request.getParameter("id"); //接收表单传来的四个数据
bb = request.getParameter("name");
cc = request.getParameter("psd");
dd = request.getParameter("tel");
String sql = "update users set name='" + bb + "',psd='" + cc
+ "',tel='" + dd + "'where id='" + aa + "'"; //条件修改语句的定义
sql_data db = new sql_data();
db.executeUpdate(sql); //修改执行
response.sendRedirect("../index.jsp");
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
Servlet实现对SQLServer数据库的增删改查(工程源码)
5星 · 超过95%的资源 需积分: 49 98 浏览量
2015-06-24
14:09:45
上传
评论 5
收藏 19KB RAR 举报 
Servlet实现对SQLServer数据库的增删改查.rar （20个子文件） 
Servlet实现对SQLServer数据库的增删改查 0623p src edu hwadee pro control 
addServlet.java 3KB updateServlet.java 3KB delServlet.java 2KB bean sql_data.java 2KB .classpath 362B .mymetadata 288B .settings org.eclipse.wst.jsdt.ui.superType.container 49B org.eclipse.wst.jsdt.ui.superType.name 6B .jsdtscope 500B org.eclipse.jdt.core.prefs 330B .myeclipse .project 1KB WebRoot META-INF MANIFEST.MF 36B add.jsp 559B index.jsp 2KB update.jsp 992B WEB-INF classes edu hwadee pro control delServlet.class 2KB addServlet.class 2KB updateServlet.class 2KB bean sql_data.class 3KB lib web.xml 2KB
- 1
- 2
前往页