Dao层的查询及插入方法

package com.bdqn.dao;

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 com.bdqn.entity.MeetingRoom;

public class MeetingRoomDao {

//查询
 public List<MeetingRoom> getMeetingRooms() {
  Connection conn = null;
  PreparedStatement ps = null;
  ResultSet rs = null;
  List<MeetingRoom> meer = new ArrayList<MeetingRoom>();
  String sql = "SELECT * FROM MEETINGROOM ORDER BY meeting_order desc";
  try {
   conn = BaseDao.getConnection();
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   while (rs.next()) {
    MeetingRoom mr = new MeetingRoom();
    mr.setId(rs.getInt("id"));
    mr.setMeeting_name(rs.getString("meeting_name"));
    mr.setMeeting_order(rs.getString("meeting_order"));
    mr.setAdvance_name(rs.getString("advance_name"));
    meer.add(mr);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   BaseDao.close(conn, ps, rs);
  }
  return meer;
 }

//增加

 public int Add(MeetingRoom mr) {
  String sql = "insert into MEETINGROOM(meeting_name,meeting_order,advance_name) values(?,?,?)";
  Connection conn = null;
  PreparedStatement ps = null;
  int row = 0;
  try {
   conn = BaseDao.getConnection();
   ps = conn.prepareStatement(sql);
   ps.setString(1, mr.getMeeting_name());
   ps.setString(2, mr.getMeeting_order());
   ps.setString(3, mr.getAdvance_name());
   row = ps.executeUpdate();
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   BaseDao.close(conn, ps, null);
  }
  return row;
 }
}

转载于:https://my.oschina.net/ypllm/blog/649474