www.pudn.com > BuyFlowers.rar > LeaveLanguageBean.java

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; 
	} 
}