求一个 servlet jquery ajax mysql增删改查简单例子

发布网友发布时间：2022-04-11 09:37

共2个回答

懂视网时间：2022-04-11 13:58

xml version="1.0" encoding="UTF-8"?> <c3p0-config>  <named-config name="c3p0">  <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://localhost:3306/manager</property> <property name="user">root</property> <property name="password">root</property>  <property name="idleConnectionTestPeriodInMinutes" value="240"/> <property name="idleMaxAgeInMinutes" value="60"/> <property name="maxConnectionsPerPartition" value="250"/> <property name="minConnectionsPerPartition" value="40"/> <property name="partitionCount" value="2"/> <property name="acquireIncrement" value="10"/> <property name="statementsCacheSize" value="0"/> <property name="releaseHelperThreads" value="5"/> <property name="connectionTimeoutInMs" value="5000"/> </named-config> </c3p0-config>

1.1.获得c3p0数据连接池的数据源

public class ComboPooledDataSourceUtil {
 //无参构造硬编码(配置这个后无需配置xml)
 public static DataSource getDataSource() throws PropertyVetoException {
 ComboPooledDataSource dataSource=new ComboPooledDataSource();
 dataSource.setDriverClass("com.mysql.jdbc.Driver");
 dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/manager");
 dataSource.setUser("root");
 dataSource.setPassword("root");
 return dataSource;
 }
 //xml编码
 public static DataSource getDataSourceByxml(){
 ComboPooledDataSource cpds=new ComboPooledDataSource("c3p0");
 return cpds;
 }
}

2. dao层采用dbutils工具类操作数据库语句

 @Override
 public Integer delmany(Integer[] ids) throws SQLException {
 String sql = "delete from `grade` where gradeId=?";
 int n=0;
 for (int i = 0; i <ids.length; i++) {
  n = queryRunner.update(sql, ids[i]);
 }

 return n;
 }

3.jsonresult类,向页面输送json格式数据,用于ajax

public class JsonResult {
 private int code;
 private String msg;
 private Object data;

 public JsonResult() {
 super();
 }

 public JsonResult(int code) {
 this.code = code;
 }

 public JsonResult(int code, String msg, Object data) {
 this.code = code;
 this.msg = msg;
 this.data = data;
 }

 public JsonResult(int code, Object data) {
 this.code = code;
 this.data = data;
 }

 public JsonResult(int code, String msg) {
 this.code = code;
 this.msg = msg;
 }

 public int getCode() {
 return code;
 }

 public void setCode(int code) {
 this.code = code;
 }

 public String getMsg() {
 return msg;
 }

 public void setMsg(String msg) {
 this.msg = msg;
 }

 public Object getData() {
 return data;
 }

 public void setData(Object data) {
 this.data = data;
 }
}

3.1实体类

public class Grade implements Serializable {


 private Integer gradeid;
 
 private String gradename;
 
 private Integer orderid;

 public Grade(Integer gradeid, String gradename, Integer orderid) {
 this.gradeid = gradeid;
 this.gradename = gradename;
 this.orderid = orderid;
 }
 public Grade() {
 }
 public Integer getGradeid() {
 return gradeid;
 }

 public void setGradeid(Integer gradeid) {
 this.gradeid = gradeid;
 }

 public String getGradename() {
 return gradename;
 }

 public void setGradename(String gradename) {
 this.gradename = gradename;
 }

 public Integer getOrderid() {
 return orderid;
 }

 public void setOrderid(Integer orderid) {
 this.orderid = orderid;
 }
}

4.service层,做业务逻辑

 @Override
 public JsonResult delMnayResult(Integer[] ids) {
 JsonResult jsonResult = null;

 try {
  Integer delmany = gradeDao.delmany(ids);
  if (delmany>0){
   jsonResult = new JsonResult(200);
  }else {
  jsonResult = new JsonResult(400);
  }
 } catch (SQLException e) {
  e.printStackTrace();
 }
 return jsonResult;
 }

5.创建servlet抽象类,避免以后一个请求建一个servlet处理类

public abstract class BaseServlet extends HttpServlet {
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 //获取模块中方法标识符
 String action = request.getParameter("action");
 if (action == null) {
  action = "index";
 }
 try {
  //1:获取类的字节码
  Class aClass = this.getClass();

  Object o = aClass.newInstance();// 通过类实例化对象

  //方法 方法都是定义在类中，找方法 在类中
  Method method = aClass.getDeclaredMethod(action,
   HttpServletRequest.class, HttpServletResponse.class);

  Object obj = method.invoke(o, request, response);
  if (obj instanceof String) {
  //转发
  request.getRequestDispatcher(obj.toString()).forward(request, response);
  } else if (obj instanceof JsonResult) {
  //json
  PrintWriter writer = response.getWriter();

  JsonResult jsonResult = (JsonResult) obj;
  String json = JSON.toJSONString(jsonResult);
  writer.print(json);
  }
 } catch (Exception e) {
  e.printStackTrace();
 } finally {
 }
 }
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 doPost(request, response);
 }
}

5.1.批量删除servlet类

@WebServlet("/main/grade")

public class GradeServlet extends BaseServlet {

GradeService service = new GradeServiceImpl();

//批量删除
 public JsonResult delMany(HttpServletRequest request, HttpServletResponse response){
 String[]ids=request.getParameterValues("gIDs");
 Integer[]delIds=new Integer[ids.length];
 for (int i = 0; i < ids.length; i++) {
  delIds[i]=Integer.parseInt(ids[i]);
 }
 JsonResult jsonResult = service.delMnayResult(delIds);
 return jsonResult;
 }
}

6. 前端部分代码,此处是列表页面,一般要先做好列表页才能删除,划线代码为预删除勾选按钮

<c:forEach items="${requestScope.grades}" var="grade">
  <tr class="text-c">
   <td><input type="checkbox" value="${grade.gradeid}" id="gIDs" name="gIDs"></td>
  <td id="gid">${grade.gradeid}</td>
  <td><u style="cursor:pointer" class="text-primary">${grade.gradename}</u></td>
  <td>${grade.orderid}</td>
  <td hidden="hidden">13000000000</td>
  <td hidden="hidden">admin@mail.com</td>
  <td class="text-l" hidden="hidden">北京市 海淀区</td>
  <td hidden="hidden">2014-6-11 11:11:42</td>
  <td class="td-status" hidden="hidden"><span class="label label-success radius">已启用</span></td>
  <td class="td-manage"><a style="text-decoration:none" onClick="member_stop(this,‘10001‘)" href="javascript:;" title="停用"><i class="Hui-iconfont"></i></a> <a title="编辑" href="javascript:;" onclick="member_edit(‘编辑‘,‘/main/grade?action=gradePage&gradeId=${grade.gradeid}‘,‘4‘,‘‘,‘510‘)" class="ml-5" style="text-decoration:none"><i class="Hui-iconfont"></i></a> <a style="text-decoration:none" class="ml-5" onClick="change_password(‘修改密码‘,‘change-password.html‘,‘10001‘,‘600‘,‘270‘)" href="javascript:;" title="修改密码"><i class="Hui-iconfont"></i></a> <a title="删除" href="javascript:;" onclick="member_del(${grade.gradeid})" class="ml-5" style="text-decoration:none"><i class="Hui-iconfont"></i></a></td>
  </tr>
  </c:forEach>
/////代码过多已省略,可在H-UI下载模板

<a href="javascript:;" onclick="datadel()" class="btn btn-danger radius"><i class="Hui-iconfont"></i> 批量删除</a>

6.1 重点

 /**批量删除*/
 function datadel() {
 $(‘input[name="gIDs"]:checked‘).each(
  function () {
  delgra($(this).val(), this)
  }
 );
 }
 function delgra(id, dome) {
 var url="/main/grade?action=delMany";
 var obj={
  gIDs:id
 }
 $.get(url,obj,function (data) {
  if(data.code=="200"){
  layer.msg("删除成功", {time: 1000, icon: 6, shift: 6});
  location.href="/main/grade";
  }else {
  layer.msg("删除失败", {time: 1000, icon: 5, shift: 6});
  }
 },"json")
 }

7.效果图如下:

技术图片

‘ 技术图片

mysql+servlet+ajax实现批量删除功能

标签：sql ems tst art over protected dmi ice update

热心网友时间：2022-04-11 11:06

假设：
1、你的页面在Web-Root下，内容为： <div id="showMsg"></div><input type="text" id="userName" />，所用编码为utf-8
2、你的servlet为： HelloWorldServlet.java 映射路径为 servlet/helloWorldServlet
步骤：
1、引入jquery-1.6.4.min.js
2、编写id为userName的输入框的点击触发函数：

     $("#userName").keyup(function(){
            $.ajax({
                  type: "post",
                  url: "servlet/helloWorldServlet?userName="+$(this).val(),
                  dataType: "json",
                  success: function(data){
                        $("#showMsg").html(data.msg);//修改id为showMsg标签的html
                  }, error: function(){
                        alert("请求出错");
                  }
            })
      })

求 一个 servlet jquery ajax mysql增删改查 简单例子

求一个 servlet jquery ajax mysql增删改查简单例子