waiterconsumeddao.java

一个KTV管理系统

package dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;
import vo.WaiterInfo;
import common.dbconnection.DbConnection;

public class WaiterConsumedDao {

	private Connection con = null;
	private Statement sta = null;
	private ResultSet res = null;
	private Vector v = null;

	public boolean hasWaiterConsumedInfo() {
		boolean flag = false;
		Vector v = null;
		Connection con = null;
		Statement stmt = null;
		ResultSet set = null;
		String sql = "select * from KTV_Waiter";
		System.out.println(sql);
		try {
			con = new DbConnection().getConnection();
			stmt = con.createStatement();
			set = stmt.executeQuery(sql);
			v = new Vector();
			while (set.next()) {
				flag = true;
				System.out.println("存在");
			}
		} catch (Exception e) {
			System.out.println("异常信息: " + e.getMessage());
		}
		return flag;
	}
	// 构造从数据库获得服务员信息的方法
	public Vector getWaiterInfo() {
		Vector v = null;//泛型
		Connection con = null;
		Statement stmt = null;
		ResultSet set = null;
		
		String sql = "select * from KTV_Waiter";
		try {
			con = new DbConnection().getConnection();
			stmt = con.createStatement();
			set = stmt.executeQuery(sql);
			
			v = new Vector();
			while (set.next()) {
				int waiter_id = Integer.parseInt(set.getString(1));
				String waiter_name = set.getString(2);
				String waiter_sex = set.getString(3);
				String waiter_tel = set.getString(4);
				String waiter_area = set.getString(5);
				String leveling = set.getString(6);
				v.addElement(new WaiterInfo(waiter_id, waiter_name, waiter_sex,
						waiter_tel, waiter_area, leveling));
			}
		} catch (Exception e) {

		}
		return v;
	}

	
}