package com.qrsx.buyflowers.beans;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;

public class LeaveLanguageBean extends DBConnection {
	private LeaveLanguageClass leaveLanguageClass=null;// 本類的實體對象

   private  Collection collection=null;

	private PreparedStatement ptst = null;

	private ResultSet rs = null;

	public LeaveLanguageBean() throws ClassNotFoundException, SQLException {
		super();
		// TODO Auto-generated constructor stub
	}
	public void setLeaveLanguage(LeaveLanguageClass leaveLanguageClass) {
		this.leaveLanguageClass = leaveLanguageClass;
	}

	public void addLanguage(String name, String qq, String email,
			String leaveLangue) {// addLauguage(name,oicq,mail,com);
		String sql = "insert into leaveLanguage values(?,?,?,?)";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, name);
			ptst.setString(2, qq);
			ptst.setString(3, email);
			ptst.setString(4,leaveLangue);
			ptst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public Collection getAllLauguage() {
		String sql = "select * from leaveLanguage";
		try {
			ptst = con.prepareStatement(sql);
			collection = new ArrayList();
			rs = ptst.executeQuery();
			while (rs.next()) {
				leaveLanguageClass = new LeaveLanguageClass();
				leaveLanguageClass.setDateTime(rs.getString("dateTime"));
				
				leaveLanguageClass.setName(rs.getString("name"));
				leaveLanguageClass.setLeaveLanguage(rs
						.getString("leaveLanguageClass"));

				collection.add(leaveLanguageClass);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return collection;
	}
}