java dao层数据库查询_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 getMeetingRooms() {

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

List meer = new ArrayList();

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;

}

}