clientdao.java

来自「struts做得固定资产管理系统 带毕业论文完整版」· Java 代码 · 共 165 行

package com.qrsx.appcam.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.qrsx.appcam.model.Client;

public class ClientDAO extends BaseDAO {
	/**
	 * 创建工厂信息
	 * 
	 * @param factory
	 * @throws SQLException
	 */
	public void create(Client client) throws SQLException {

		String sql = "Insert Into client(name,address,linkman,telephone, description) Values(?,?,?, ?,?)";
		// 设置参数
		ps = conn.prepareStatement(sql);
		ps.setString(1, client.getName());
		ps.setString(2, client.getAddress());
		ps.setString(3, client.getLinkman());
		ps.setString(4, client.getTelephone());
		ps.setString(5, client.getDescription());
		// 执行插入操作
		ps.executeUpdate();
	}

	/**
	 * 更新工厂信息操作
	 * 
	 * @param client
	 * @throws SQLException
	 */
	public void update(Client client) throws SQLException {

		String sql = "Update client set name=?,address=?,linkman=?,telephone=?, description=? where id=?";
		// 设置参数
		ps = conn.prepareStatement(sql);
		ps.setString(1, client.getName());
		ps.setString(2, client.getAddress());
		ps.setString(3, client.getLinkman());
		ps.setString(4, client.getTelephone());
		ps.setString(5, client.getDescription());
		ps.setInt(6, client.getId());
		// 执行更新操作
		ps.executeUpdate();
	}

	/**
	 * 删除操作
	 * 
	 * @param clientId
	 * @return count
	 * @throws SQLException
	 */
	public int delete(Integer clientId) throws SQLException {
		String sql = "Delete from client where id=? ";
		// 设置参数并执行删除操作
		ps = conn.prepareStatement(sql);
		ps.setInt(1, clientId);
		int count = ps.executeUpdate();
		return count;
	}

	/**
	 * 按照编号来检索工厂信息
	 * 
	 * @param clientId
	 * @return client
	 * @throws SQLException
	 */
	public Client findById(Integer clientId) throws SQLException {

		String sql = "Select *  from client  where id= ?";
		ps = conn.prepareStatement(sql);
		ps.setInt(1, clientId);
		ResultSet rs = ps.executeQuery();
		Client client = null;
		if (rs.next()) {
			client = new Client();
			client.setId(rs.getInt("id"));
			client.setName(rs.getString("name"));
			client.setLinkman(rs.getString("linkman"));
			client.setAddress(rs.getString("address"));
			client.setTelephone(rs.getString("telephone"));
			client.setDescription(rs.getString("description"));
		}
		return client;
	}

	/**
	 * 检索所有的工厂信息
	 * 
	 * @return List<client>
	 * @throws SQLException
	 */
	public List<Client> findAll() throws SQLException {
		String sql = "select *  from client ";
		ps = conn.prepareStatement(sql);
		ResultSet rs = ps.executeQuery();
		List<Client> list = new ArrayList<Client>();
		Client client = null;
		while (rs.next()) {
			client = new Client();
			client.setId(rs.getInt("id"));
			client.setName(rs.getString("name"));
			client.setLinkman(rs.getString("linkman"));
			client.setAddress(rs.getString("address"));
			client.setTelephone(rs.getString("telephone"));
			client.setDescription(rs.getString("description"));
			list.add(client);
		}
		return list;
	}

	/**
	 * 根据 名称 联系人 联系地址检索工厂信息
	 * 
	 * @param client
	 * @return List<client>
	 * @throws SQLException
	 */
	public List<Client> list(Client client) throws SQLException {

		String sql = "Select * from client where 1=1 ";

		// 根据名称检索组装条件
		String name = client.getName();
		if (name != null && !name.equals("")) {
			sql = sql + "  and name like '%" + name + "%' ";
		}
		// 根据联系人检索组装条件
		String linkman = client.getLinkman();
		if (linkman != null && !linkman.equals("")) {
			sql = sql + "   and linkman like '%" + linkman + "%' ";
		}
		// 根据联系地址组装条件
		String address = client.getAddress();
		if (address != null && !address.equals("")) {
			sql = sql + "  and address like '%" + address + "%' ";
		}
		// 设置参数并执行操作
		ps = conn.prepareStatement(sql);
		ResultSet rs = ps.executeQuery();

		List<Client> list = new ArrayList<Client>();
		Client client1 = null;

		while (rs.next()) {
			client1 = new Client();
			client1.setId(rs.getInt("id"));
			client1.setName(rs.getString("name"));
			client1.setLinkman(rs.getString("linkman"));
			client1.setAddress(rs.getString("address"));
			client1.setTelephone(rs.getString("telephone"));
			client1.setDescription(rs.getString("description"));
			list.add(client1);
		}
		return list;
	}

}