roomtypesettingdao.java

一个KTV管理系统

package dao.roomtypesetting;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JOptionPane;

import vo.Room;
import vo.RoomType;

import common.dbconnection.DbConnection;


public class RoomTypeSettingDao {
  
	//插入包间语句
	public boolean insertRoomType(RoomType value) {
		boolean flag = false;
		Connection con = null;
		Statement stmt = null;
		ResultSet set = null;
		String sql = "insert into ktv_room_type(roomType,roomPrice,chargePlan,roomCapacity"
				+ "roomtype,roomprice,chargePlan,roomcapacity)"
				+ " values('"
				+ value.getRoomType()
				+ "','"
				+ value.getRoomPrice()
				+ "','"
				+ value.getChargePlan()
				+ "','"
				+ value.getRoomCapacity()
				+ "')";
		System.out.println(sql);
		try {
			con = new DbConnection().getConnection();
			stmt = con.createStatement();
			set = stmt.executeQuery(sql);
			if (set.next()) {
				flag = true;
			}
		} catch (Exception e) {
			JOptionPane.showMessageDialog(null, "增加的房间类型"
					+ e.getMessage().substring(10), "插入提示",
					JOptionPane.YES_OPTION);
		}
		return flag;
	}
	//获得房间信息		
	public Vector getRoomType() {
		Vector v = null;
		Connection con = null;
		Statement stmt = null;
		ResultSet set = null;
		String sql = "select * from KTV_ROOM_TYPE";
		System.out.println(sql);
		try {
			con = new DbConnection().getConnection();
			stmt = con.createStatement();
			set = stmt.executeQuery(sql);
			v = new Vector();
			while (set.next()) {
				
				String roomType = set.getString(0);
				double roomPrice = set.getDouble(1);
				String chargePlan = set.getString(2);
				double roomCapacity = set.getDouble(3);
				
				v.addElement(new RoomType( roomType, roomPrice,
						chargePlan,  roomCapacity));
			}
		} catch (Exception e) {
			System.out.println("异常信息: " + e.getMessage());
		}
		return v;
	}
	
	//删除包间类型语句
	public boolean deleteRoomType(String roomType) {
		boolean flag = false;
		Connection con = null;
		PreparedStatement stmt = null;
		ResultSet set = null;
		String sql = "delete from ktv_waiter where roomtype =?";
		System.out.println(sql);
		try {
			con = new DbConnection().getConnection();
			stmt = con.prepareStatement(sql);
			stmt.setString(0, roomType);
			stmt.executeUpdate();
			flag = true;
		} catch (Exception e) {
			System.out.println("异常信息: " + e.getMessage());
		}
		return flag;
	}
	
	//构造选中数据的方法
	
	public boolean findEditInfo(String roomType) {
		  boolean flag = false;
		  Connection con = null;
		  PreparedStatement stmt = null;
		  ResultSet set = null;
		  String sql = "select * from ktv_room_type where roomType =?";
		   System.out.println(sql);
		  try {
		    con = new DbConnection().getConnection();
		    stmt = con.prepareStatement(sql);
		    stmt.setString(1, roomType);
		    stmt.executeUpdate();
		    flag = true;
		  } catch (Exception e) {
		    System.out.println("异常信息: " + e.getMessage());
		  }
		  return flag;
		}
	
	

}