介绍
这篇文章主要介绍了AJAX实现数据增删改查的方法,具有一定借鉴价值,需要的朋友可以参考下。希望大家阅读完这篇文章后大有收获。下面让小编带着大家一起了解一下。
主页:索引。html
& lt; !DOCTYPE html> & lt; html> & lt; head> & lt;元charset=癠TF-8"祝辞 & lt; title> & lt;/title> https://www.yisu.com/zixun/& lt;脚本src=" http://libs.baidu.com/jquery/2.1.4/jquery.min.js "> 脚本> 头 <身体> 编号:
姓名:
性别:男:女:
年龄:<选择id="年龄"> <选项值=" 15 "> 选项> 15 <选项值=" 16 "> 选项> 16 <选项值=?7”> 选项> 17 <选项值=?8”> 18> 选项 <选项值=" 19 "> 选项> 19日 20 <选项值=" 20 "> 选项> <选项值=?1”> 21> 选项 <选项值=" 22 "> 选项> 22 <选项值=" 23 "> 选项> 23日 <选项值=" 24 "> 24> 选项 <选项值=" 25 "> 选项> 25 选择>
身高:
体重:
包com.web; 进口java.io.IOException; 进口javax.servlet.ServletException; 进口javax.servlet.annotation.WebServlet; 进口javax.servlet.http.HttpServlet; 进口javax.servlet.http.HttpServletRequest; 进口javax.servlet.http.HttpServletResponse; 进口com.mysql.MysqlUtil;/* * * Servlet实现类你好 */@WebServlet (“/Hello") 公开课你好扩展HttpServlet { 私有静态最终长serialVersionUID l=1;/* * * @see HttpServlet # HttpServlet () */公共Hello () { 超级();//TODO自动生成构造函数存根 }/* * * @see HttpServlet # doGet (HttpServletRequest请求,HttpServletResponse响应) */保护无效doGet (HttpServletRequest请求,HttpServletResponse响应)抛出ServletException IOException {//TODO自动生成方法存根 response.getWriter () .append(“在:“).append (request.getContextPath ()); }/* * * @see HttpServlet # doPost (HttpServletRequest请求,HttpServletResponse响应) */保护无效doPost (HttpServletRequest请求,HttpServletResponse响应)抛出ServletException IOException { response.setCharacterEncoding (“utf-8"); application/json response.setContentType (“;;charset=utf-8"); 字符串pno=request.getParameter (“pno"); 字符串名称=request.getParameter (“name"); 字符串性=request.getParameter (“sex"); 字符串的年龄=request.getParameter (“age"); 字符串高度=request.getParameter (“height"); 字符串重量=request.getParameter (“weight"); 字符串sqlInsert=安迦肴?Pno, Pname、Psex、页面、Pheight Pweight)值(& # 39;“; sqlInsert +=pno +“& # 39; & # 39;“; sqlInsert +=名称+“& # 39;& # 39;“; sqlInsert +=性+“& # 39;“; sqlInsert +=年龄+“,“; sqlInsert +=身高+“,“; sqlInsert重量+=+,)“; int消息=MysqlUtil.add (sqlInsert); 字符串代表=?“; 如果(消息==1){ 代表=皗\ \“代码”:200年,\“\“消息:\“成功插入数据库\“}”; 其他}{ 代表=皗\“\“代码:\“999 \“,\“\“消息:\“插入失败了\“}”; } response.getWriter () .write(代表); } }
删除的Servlet: HelloDelete。java
包com.web; 进口java.io.IOException; 进口javax.servlet.ServletException; 进口javax.servlet.annotation.WebServlet; 进口javax.servlet.http.HttpServlet; 进口javax.servlet.http.HttpServletRequest; 进口javax.servlet.http.HttpServletResponse; 进口com.mysql.MysqlUtil;/* * * HelloDelete Servlet实现类 */@WebServlet (“/HelloDelete") 公开课HelloDelete扩展HttpServlet { 私有静态最终长serialVersionUID l=1;/* * * @see HttpServlet # HttpServlet () */公共HelloDelete () { 超级();//TODO自动生成构造函数存根 }/* * * @see HttpServlet # doGet (HttpServletRequest请求,HttpServletResponse响应) */保护无效doGet (HttpServletRequest请求,HttpServletResponse响应)抛出ServletException IOException {//TODO自动生成方法存根 response.getWriter () .append(“在:“).append (request.getContextPath ()); }/* * * @see HttpServlet # doPost (HttpServletRequest请求,HttpServletResponse响应) */保护无效doPost (HttpServletRequest请求,HttpServletResponse响应)抛出ServletException IOException { response.setCharacterEncoding (“utf-8"); application/json response.setContentType (“;;charset=utf-8"); 字符串pno=request.getParameter (“pno"); 字符串sqlDel=吧境右桓鋈四抢飌no=? pno; int消息=MysqlUtil.del (sqlDel); 字符串代表=?“; 如果(消息==1){ 代表=皗\“\“代码:\“200 \“,\“\“消息:\“成功删除\“}”; 其他}{ 代表=皗\“\“代码:\“999 \“,\“\“消息:\“删除失败\“}”; } response.getWriter () .write(代表); } }AJAX实现数据增删改查的方法