www.pudn.com > BuyFlowers.rar > AdminLeaveLanguageBean.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 AdminLeaveLanguageBean extends DBConnection { 
 
	private LeaveLanguageClass leaveLanguageClass = null; 
 
	private PreparedStatement ptst; 
 
	private ResultSet rs; 
 
	private Collection collection; 
 
	public AdminLeaveLanguageBean() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
 
	// 设置实体 
	public void setLeaveLanguage(LeaveLanguageClass leaveLanguageClass) { 
		this.leaveLanguageClass = leaveLanguageClass; 
	} 
 
	// 添加记录 
	/*public void addLeaveLanguage(String leaveLanguage) { 
		String sql = "insert into leaveLanguage(name,qq,email,leaveLanguage) values(?,?,?,?);"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, this.leaveLanguageClass.getName()); 
			ptst.setString(2, this.leaveLanguageClass.getQq()); 
			ptst.setString(3, this.leaveLanguageClass.getEmail()); 
			ptst.setString(4, "管理员说:" + leaveLanguage); 
			ptst.executeUpdate(); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
	}*/ 
 
	//添加记录 
	public void addLeaveLanguage(LeaveLanguageClass leaveLanguage) { 
		String sql = "insert into leaveLanguage(name,qq,email,leaveLanguage) values(?,?,?,?);"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, leaveLanguage.getName()); 
			ptst.setString(2, leaveLanguage.getQq()); 
			ptst.setString(3, leaveLanguage.getEmail()); 
			ptst.setString(4, "管理员说:" + leaveLanguage.getLeaveLanguage()); 
			ptst.executeUpdate(); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
	} 
	// 获取所有留言 
	public Collection getAllLanguage() { 
		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.setEmail(rs.getString("email")); 
				leaveLanguageClass.setLeaveLanguage(rs 
						.getString("leaveLanguage")); 
				leaveLanguageClass.setLeaveLanguageId(rs 
						.getString("leaveLanguageId")); 
				leaveLanguageClass.setName(rs.getString("name")); 
				leaveLanguageClass.setQq(rs.getString("qq")); 
				collection.add(leaveLanguageClass); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		return collection; 
	} 
 
	// 删除 
	public void deleteLanguage(String leaveLanguageId) { 
		String sql = "delete from leaveLanguage where leaveLanguageId=?;"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, leaveLanguageId); 
			ptst.executeUpdate(); 
 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
	} 
 
	// 按姓名查询 
	public Collection getLauguageByUsersName(String name) { 
		String sql = "select * from leaveLanguage where name=?"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, name); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
				leaveLanguageClass = new LeaveLanguageClass(); 
				leaveLanguageClass.setDateTime(rs.getString("dateTime")); 
				leaveLanguageClass.setEmail(rs.getString("email")); 
				leaveLanguageClass.setLeaveLanguage(rs 
						.getString("leaveLanguage")); 
				leaveLanguageClass.setLeaveLanguageId(rs 
						.getString("leaveLanguageId")); 
				leaveLanguageClass.setName(rs.getString("name")); 
				leaveLanguageClass.setQq(rs.getString("qq")); 
				collection.add(leaveLanguageClass); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
		return collection; 
	} 
 
	// 按日期查询 
 
	public Collection getLauguageByDateTime(String year, String month, 
			String day) { 
		String sql = "select * from leaveLanguage where datetime like ?"; 
		String dataTime = "%" + year + "%" + month + "%" + day + "%;"; 
		try { 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, dataTime); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
 
				leaveLanguageClass = new LeaveLanguageClass(); 
				leaveLanguageClass.setDateTime(rs.getString("dateTime")); 
				leaveLanguageClass.setEmail(rs.getString("email")); 
				leaveLanguageClass.setLeaveLanguage(rs 
						.getString("leaveLanguage")); 
				leaveLanguageClass.setLeaveLanguageId(rs 
						.getString("leaveLanguageId")); 
				leaveLanguageClass.setName(rs.getString("name")); 
				leaveLanguageClass.setQq(rs.getString("qq")); 
				collection.add(leaveLanguageClass); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
		return collection; 
	} 
 
}