java web数据交互+layui.zip

package com.ls.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Map; import com.ls.entity.Students; import com.ls.util.Dbutil; import com.ls.util.PageModel; public class Istudent implements Impstudent{ @Override public List<Students> queryStu(String name, int age) { // TODO Auto-generated method stub List<Students> list =new ArrayList<Students>(); Dbutil db=new Dbutil(); Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; String sql="select * from students"; try { conn=db.getConnection(); ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ Students stu=new Students( rs.getInt("stu_no"), rs.getString("stu_name"), rs.getString("stu_sex"), rs.getInt("stu_age"), rs.getString("stu_birth")); list.add(stu); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.closeDb(rs, ps, conn); } return list; } @Override public boolean saveorupdate(Students stuEnt) { // TODO Auto-generated method stub Connection conn=null; PreparedStatement ps=null; conn=new Dbutil().getConnection(); boolean bool=false; try { if(stuEnt.getStu_no()>0&& !("").equals(stuEnt.getStu_no())){ String sqluadate="Update students set stu_name=?,stu_sex=?,stu_age=?,stu_birth=? where stu_no=?"; ps=conn.prepareStatement(sqluadate); ps.setString(1, stuEnt.getStu_name()); ps.setString(2, stuEnt.getStu_sex()); ps.setInt(3, stuEnt.getStu_age()); ps.setString(4, stuEnt.getStu_birth()); ps.setInt(5, stuEnt.getStu_no()); int rowNum=ps.executeUpdate(); if(rowNum>0){ bool=true; } }else{ String addsql="insert into students(stu_no,stu_name,stu_sex,stu_age,stu_birth) values(?,?,?,?,?)"; ps=conn.prepareStatement(addsql); ps.setInt(1, stuEnt.getStu_no()); ps.setString(2, stuEnt.getStu_name()); ps.setString(3, stuEnt.getStu_sex()); ps.setInt(4, stuEnt.getStu_age()); ps.setString(5, stuEnt.getStu_birth()); int rowNum=ps.executeUpdate(); if(rowNum>0){ bool=true; } } } catch (Exception e) { // TODO: handle exception }finally{ new Dbutil().closeDb(null, ps, conn); } return bool; } @Override public Students getStudentsInfo(int id) { // TODO Auto-generated method stub Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; Students stu=null; conn=new Dbutil().getConnection(); String sql="select * from students where stu_no=?"; try { ps=conn.prepareStatement(sql); ps.setInt(1, id); rs=ps.executeQuery(); if(rs.next()){ stu=new Students( rs.getInt("stu_no"), rs.getString("stu_name"), rs.getString("stu_sex"), rs.getInt("stu_age"), rs.getString("stu_birth")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ new Dbutil().closeDb(rs, ps, conn); } return stu; } @Override public boolean deleteStu(int id) { // TODO Auto-generated method stub Connection conn=null; PreparedStatement ps=null; boolean bool=false; conn=new Dbutil().getConnection(); String sql="delete from students where stu_no=?"; try { ps=conn.prepareStatement(sql); ps.setInt(1, id); int i=ps.executeUpdate(); if(i>0){ bool=true; }else{ bool=false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ new Dbutil().closeDb(null, ps, conn); } return bool; } @Override public List<Students> selectInfo(int id, String name) { // TODO Auto-generated method stub Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; List<Students> list=new ArrayList<Students>(); conn=new Dbutil().getConnection(); String sql="select * from students where stu_no=? or stu_name=?"; try { ps=conn.prepareStatement(sql); ps.setInt(1, id); ps.setString(2, name); rs=ps.executeQuery(); while(rs.next()){ Students stuEnt=new Students( rs.getInt("stu_no"), rs.getString("stu_name"), rs.getString("stu_sex"), rs.getInt("stu_age"), rs.getString("stu_birth")); list.add(stuEnt); }; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ new Dbutil().closeDb(null, ps, conn); } return list; } public List<Students> selectInfo(String name) { // TODO Auto-generated method stub Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; List<Students> list=new ArrayList<Students>(); conn=new Dbutil().getConnection(); String sql="select * from students where stu_no=? or stu_name=?"; try { ps=conn.prepareStatement(sql); ps.setString(1, name); ps.setString(2, name); rs=ps.executeQuery(); while(rs.next()){ Students stuEnt=new Students( rs.getInt("stu_no"), rs.getString("stu_name"), rs.getString("stu_sex"), rs.getInt("stu_age"), rs.getString("stu_birth")); list.add(stuEnt); }; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ new Dbutil().closeDb(null, ps, conn); } return list; } @Override public int countRow(Map<String, Object> map) { // TODO Auto-generated method stub Dbutil db=new Dbutil(); Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; int retNum=0; String sql="select count(stu_no) from students"; conn=db.getConnection(); try { ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ retNum=rs.getInt(1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { db.closeDb(rs, ps, conn); } return retNum; } @Override public PageModel<Students> queryPage(Map<String, Object> map) { // TODO Auto-generated method stub PageModel<Students> pm=new PageModel<Students>(); int size=Integer.parseInt(map.get("size")+""); int currPage=Integer.parseInt(map.get("currentPage")+""); //赋值每页查询的条数 pm.setSize(size); //计算当前是多少页 pm.setCurrentPage(currPage); //计算总页数 pm.setSumcount(this.countRow(map)); //调用方法 String sql="select * from students limit "+(currPage-1)*size+","+size; ArrayList<Students> list=this.arrayList(sql); pm.setList(list); return pm; } /*分页查询*/ public ArrayList<Students> arrayList(String sql){ ArrayList<Students> list=new ArrayList<Students>(); Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; conn=new Dbutil().getConnection(); try { ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ Students stu=new Students( rs.getInt("stu_no"), rs.getString("stu_name"), rs.getString("stu_sex"), rs.getInt("stu_age"), rs.getString("stu_birth")); list.add(stu); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ new Dbutil().closeDb(rs, ps, conn); } return list; } public ArrayList<Students> listUi(Map<String, Object> map){ ArrayList<Students> list=new ArrayList<Students>(); Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; int size=Integer.parseInt(map.get("limitNum")+""); int currPage=Integer.parseInt(map.get("page")+""); String sql="select * from students limit "+(currPage-1)*size+","+size; conn=new Dbutil().getConnection(); try { ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ Students stu=new Students( rs.getInt("stu_no"),