Easyui05和Easyui06

最新推荐文章于 2022-05-10 11:16:05 发布

石头好吃喵

最新推荐文章于 2022-05-10 11:16:05 发布

阅读量57

点赞数

分类专栏： java 文章标签： java easyui

本文链接：https://blog.csdn.net/TSHILEI/article/details/124197447

版权

java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

增删改查

dao方法

@Override
   public void addBook(Book book) {
       String sql = "insert into t_book(id,bookname,price,booktype)" + "select max(id)+1,'" + ""+book.getBookname()+"'," + ""+book.getPrice()+",'"+book.getBooktype()+"' from t_book";
       Connection con = null;
       PreparedStatement ps = null;
       ResultSet rs = null;
       try {
           con = DBHelper.getsCon();
           ps = con.prepareStatement(sql);
           ps.executeUpdate();
       } catch (Exception e) {
           e.printStackTrace();
       }finally {
           DBHelper.Close(con, ps, rs);
       }

   }

@Override
public void updateBook(Book book) {
String sql = "update t_book set bookname=? booktype=? where id=?";
Connection con = null;
PreparedStatement ps = null;
try {
con = DBHelper.getCon();
ps = con.prepareStatement(sql);
ps.setObject(1,book.getBookname());
ps.setObject(2,book.getPrice());
ps.setObject(3,book.getBooktype());
ps.setObject(4,book.getId());
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
DBHelper.myClose(con, ps,null);
}

}


@Override
public void delBookById(Integer id) {
String sql = "delete from t_book where id=? ";
Connection con = null;
PreparedStatement ps = null;
try {
con = DBHelper.getCon();
ps = con.prepareStatement(sql);
ps.setObject(1,id);
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
DBHelper.myClose(con, ps,null);
}

}

增加代码

private IBookService service = new BookService();

   public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
       doPost(req, resp);
   }

   public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
       req.setCharacterEncoding("utf-8");
       resp.setContentType("application/json;charset=utf-8");
       String bookname = req.getParameter("bookname");
       String price = req.getParameter("price");
       String booktype = req.getParameter("booktype");
       Book book = new Book();
       book.setBookname(bookname);
       book.setPrice(new BigDecimal(price));
       book.setBooktype(booktype);
       Map<String,Object> data = new HashMap<>();

       try {
           service.addBook(book);
           data.put("success",true);
       } catch (Exception e) {
           data.put("success",false);
       }

       PrintWriter out = resp.getWriter();
       out.write(JSON.toJSONString(data));
       out.flush();
       out.close();
   }

效果图

点击右上角的+号时弹出

增加成功时弹出

修改代码

package com.zking.euidemo.serviet;

import java.io.IOException;
import java.io.PrintWriter;
import java.math.BigDecimal;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;
import com.zking.euidemo.model.Book;
import com.zking.euidemo.service.BookService;
import com.zking.euidemo.service.IBookService;

@WebServlet("/updateBookServlet")
public class UpdateBookServlet extends HttpServlet{
private IBookService service = new BookService();
/**
*
*/
private static final long serialVersionUID = 1L;

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}

@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//设置编码方式
req.setCharacterEncoding("utf-8");
resp.setContentType("application/json;charset=utf-8");
String id = req.getParameter("id");
String bookname = req.getParameter("bookname");
String price = req.getParameter("price");
String booktype = req.getParameter("booktype");
//System.out.println(bookname+" "+ " "+price + " "+booktype);
Book book = new Book();
book.setId(Integer.parseInt(id));
book.setBookname(bookname);
book.setPrice(price);
book.setBooktype(booktype);
PrintWriter out = resp.getWriter();
//String str = JSON.toJSONString(map);
Map<String,Object> data = new HashMap<>();

//接收表单过来的值
try {
service.updateBook(book);
data.put("success",true);
} catch (Exception e) {
data.put("success",false);
}

out.write(JSON.toJSONString(data));
out.flush();//刷新
out.close();//关闭
}
}