欢迎使用CSDN-markdown编辑器

最新推荐文章于 2021-01-07 23:01:28 发布

lxh929257102

最新推荐文章于 2021-01-07 23:01:28 发布

阅读量277

点赞数

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

本文链接：https://blog.csdn.net/lxh929257102/article/details/46377425

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

private void get(String par, HttpServletRequest request,
HttpServletResponse response) throws IOException {
Dao dao = new Dao();
List list = null;
String sql = “select *,id,name from singer”;
if(null != par && !”“.equals(par)){
sql = sql + ” where (name like ‘%”+ par + “%’)”;
}
try {
list = dao.get(sql);
} catch (Exception e) {
message = e.getMessage();
e.printStackTrace();
}
response.setContentType(“text/html;charset=UTF-8”);
PrintWriter out = response.getWriter();
out.print(JSON.toJSON(list));
out.flush();
out.close();

}

private void delete(String id, HttpServletRequest request,
HttpServletResponse response) throws IOException {
String sql = “delete from singer where id=’” + id + “’”;
Dao dao = new Dao();
try {
dao.execute(sql);
} catch (ClassNotFoundException e) {
e.printStackTrace();
message = e.getMessage();
} catch (Exception e) {
e.printStackTrace();
message = e.getMessage();
}
response.setContentType(“text/html;charset=UTF-8”);
PrintWriter out = response.getWriter();
out.print(message);
message = “”;
out.flush();
out.close();
}