JSP项目 淘饭网（终极版）

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import entity.Refectorys; import entity.managers; public class manager extends BaseDao { private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null; //所有的查询（模糊，全查，） public ArrayList<managers> selectAll(){ ArrayList<managers> lists=new ArrayList<managers>(); try{ this.conn = this.getConn(); String sql="select * from admin_message"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){ managers man=new managers(); man.setId(rs.getString("a_id")); man.setName(rs.getString("a_name")); man.setPass(rs.getString("a_password")); man.setBoss(rs.getString("a_boss")); lists.add(man); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return lists; } public managers selectOne(String id){ managers man=new managers(); try{ this.conn = this.getConn(); String sql="select * from admin_message where a_id="+id; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){ man.setId(rs.getString("a_id")); man.setName(rs.getString("a_name")); man.setPass(rs.getString("a_password")); man.setBoss(rs.getString("a_boss")); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return man; } public int isNull(String name,String pass){ int count=0; try{ this.conn = this.getConn(); String sql="select * from admin_message where a_name='"+name+"' and a_password='"+pass+"'"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); System.out.println(sql); if(rs.next()) { count=1; } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return count; } public int isBoss(String name,String pass){ int count=0; try{ this.conn = this.getConn(); String sql="select * from admin_message where a_name='"+name+"' and a_password='"+pass+"'"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); System.out.println(sql); if(rs.next()) { count=rs.getInt("a_boss"); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return count; } public ArrayList<Refectorys> selectAllrefe(int a,int b){ ArrayList<Refectorys> lists=new ArrayList<Refectorys>(); try{ this.conn = this.getConn(); String sql="select top "+a+" list_id, list_address,list_name,list_dissertation,list_food_type," + "list_images,list_intention=(select i_name from intention where i_id=list_intention) ," + "list_map,list_phone,list_Pmoney,list_Time,list_advert,list_car from list_message" + " where list_id not in (select top "+b+" list_id from list_message)"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){ Refectorys refe=new Refectorys(); refe.setId(rs.getString("list_id")); refe.setDizhi(rs.getString("list_address")); refe.setName(rs.getString("list_name")); refe.setZhuanti(rs.getString("list_dissertation")); refe.setCaixi(rs.getString("list_food_type")); refe.setTupian(rs.getString("list_images")); refe.setMudi(rs.getString("list_intention")); refe.setDitu(rs.getString("list_map")); refe.setPhone(rs.getString("list_phone")); refe.setAvg(rs.getString("list_Pmoney")); refe.setTime(rs.getString("list_Time")); refe.setZhuyi(rs.getString("list_advert")); refe.setCar(rs.getString("list_car")); lists.add(refe); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return lists; } public int selectAllrefes(){ int count=0; try{ this.conn = this.getConn(); String sql="select count(*) from list_message"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){ count=rs.getInt(1); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return count; } public Refectorys selectOnerefes(String id){ Refectorys refe=new Refectorys(); try{ this.conn = this.getConn(); String sql="select list_id, list_address,list_name,list_dissertation,list_food_type,list_images,list_intention=(select i_name from intention where i_id=list_intention),list_map,list_phone,list_Pmoney,list_Time,list_advert,list_car from list_message where list_id="+id; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); System.out.println(sql); while(rs.next()){ refe.setId(rs.getString("list_id")); refe.setDizhi(rs.getString("list_address")); refe.setName(rs.getString("list_name")); refe.setZhuanti(rs.getString("list_dissertation")); refe.setCaixi(rs.getString("list_food_type")); refe.setTupian(rs.getString("list_images")); refe.setMudi(rs.getString("list_intention")); refe.setDitu(rs.getString("list_map")); refe.setPhone(rs.getString("list_phone")); refe.setAvg(rs.getString("list_Pmoney")); refe.setTime(rs.getString("list_Time")); refe.setZhuyi(rs.getString("list_advert")); refe.setCar(rs.getString("list_car")); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return refe; } }