adminleavelanguagebean.java

j2ee框架下的mvc模式的一个网上销售系统

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

}