package dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import dao.ZhichuqingkuangDao;
import entity.Zhichuqingkuang;

public class ZhichuqingkuangImpl implements ZhichuqingkuangDao{


	public Zhichuqingkuang findById(String id) {
		Zhichuqingkuang achss=new Zhichuqingkuang();
		try {
			
		    Connection conn = JDBCUtil.getConnection();
		    String sqlhss = "select*from zhichuqingkuang where id = ?";
		    PreparedStatement prestm=conn.prepareStatement(sqlhss);
		    prestm.setInt(1, Integer.valueOf(id));
		    ResultSet rs=prestm.executeQuery();
		    
		    	while(rs.next()) {
		    		Zhichuqingkuang zhichuqingkuang=new Zhichuqingkuang();
		    		zhichuqingkuang.setId(rs.getInt("id"));
		    		zhichuqingkuang.setFashengfeiyonghss(rs.getString("fashengfeiyonghss"));
		    		zhichuqingkuang.setFashengriqihss(rs.getString("fashengriqihss"));
		    		zhichuqingkuang.setHuzhuhss(rs.getString("huzhuhss"));
		    		zhichuqingkuang.setMingxihss(rs.getString("mingxihss"));
					achss=zhichuqingkuang;
		    	}
				rs.close();
				prestm.close();
				conn.close();
			}
			catch(Exception e) {
				e.printStackTrace();
			}
			return achss;
	}


	@Override
	public List<Zhichuqingkuang> findAll() {
		ArrayList<Zhichuqingkuang> zhushus=new ArrayList<Zhichuqingkuang>();
		try {
			Connection conn = JDBCUtil.getConnection();
			
			String sqlhss ="select *from zhichuqingkuang";
			Statement stshss =conn.createStatement();
			ResultSet rs=stshss.executeQuery(sqlhss);
			
			while(rs.next()) {
				Zhichuqingkuang zhichuqingkuang=new Zhichuqingkuang();
				zhichuqingkuang.setId(rs.getInt("id"));
				zhichuqingkuang.setFashengfeiyonghss(rs.getString("fashengfeiyonghss"));
	    		zhichuqingkuang.setFashengriqihss(rs.getString("fashengriqihss"));
	    		zhichuqingkuang.setHuzhuhss(rs.getString("huzhuhss"));
	    		zhichuqingkuang.setMingxihss(rs.getString("mingxihss"));
				zhushus.add(zhichuqingkuang);
			}
			rs.close();
			stshss.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		// TODO 自动生成的方法存根
		return zhushus;
	}


	@Override
	public int modify(Zhichuqingkuang zhichuqingkuang) {
		try {
			Connection conn = JDBCUtil.getConnection();
			
			String sqlhss ="update zhichuqingkuang set fashengfeiyonghss=?,fashengriqihss=?,huzhuhss=?,mingxihss=? where id=?";
			PreparedStatement prestmhss=conn.prepareStatement(sqlhss);
			prestmhss.setString(1,zhichuqingkuang.getFashengfeiyonghss());
			prestmhss.setString(2,zhichuqingkuang.getFashengriqihss());
			prestmhss.setString(3,zhichuqingkuang.getHuzhuhss());
			prestmhss.setString(4,zhichuqingkuang.getMingxihss());
			prestmhss.setInt(5,zhichuqingkuang.getId());
			prestmhss.executeUpdate();
			prestmhss.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return 0;
	}


	@Override
	public int create(Zhichuqingkuang zhichuqingkuang) {
		try {
			Connection conn = JDBCUtil.getConnection();
			String sqlhss ="Insert into zhichuqingkuang (fashengfeiyonghss,fashengriqihss,huzhuhss,mingxihss) values(?,?,?,?)";
			PreparedStatement prestmhss=conn.prepareStatement(sqlhss);
			prestmhss.setString(1,zhichuqingkuang.getFashengfeiyonghss());
			prestmhss.setString(2,zhichuqingkuang.getFashengriqihss());
			prestmhss.setString(3,zhichuqingkuang.getHuzhuhss());
			prestmhss.setString(4,zhichuqingkuang.getMingxihss());
			prestmhss.executeUpdate();
			prestmhss.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return 0;
	}


	@Override
	public int remove(Zhichuqingkuang zhichuqingkuang) {
		int flaghss=0;
		try {
			Connection conn = JDBCUtil.getConnection();
			String sqlhss ="delete from zhichuqingkuang where id=?";
			PreparedStatement prestmhss=conn.prepareStatement(sqlhss);
			prestmhss.setInt(1, zhichuqingkuang.getId());
			flaghss = prestmhss.executeUpdate();
			prestmhss.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return flaghss;
	}

}