package com.ym.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 com.ym.dao.ShouruqingkuangymDao;
import com.ym.entity.Shouruqingkuangym;

public class ShouruqingkuangymImpl implements ShouruqingkuangymDao{

	public Shouruqingkuangym findById(String id) {
		Shouruqingkuangym acym=new Shouruqingkuangym();
		try {
			
		    Connection conn = JDBCUtil.getConnection();
		    String sql = "select*from shouruqingkuang where id = ?";
		    PreparedStatement prestm=conn.prepareStatement(sql);
		    prestm.setInt(1, Integer.valueOf(id));
		    ResultSet rs=prestm.executeQuery();
		    
		    	while(rs.next()) {
		    		Shouruqingkuangym shouruqingkuang=new Shouruqingkuangym();
		    		shouruqingkuang.setId(rs.getInt("id"));
		    		shouruqingkuang.setFashengfeiyongym(rs.getString("fashengfeiyongym"));
		    		shouruqingkuang.setFashengriqiym(rs.getString("fashengriqiym"));
		    		shouruqingkuang.setHuzhuym(rs.getString("huzhuym"));
		    		shouruqingkuang.setMingxiym(rs.getString("mingxiym"));
					acym=shouruqingkuang;
		    	}
				rs.close();
				prestm.close();
				conn.close();
			}
			catch(Exception e) {
				e.printStackTrace();
			}
			return acym;
	}


	@Override
	public List<Shouruqingkuangym> findAll() {
		ArrayList<Shouruqingkuangym> zhushus=new ArrayList<Shouruqingkuangym>();
		try {
			Connection conn = JDBCUtil.getConnection();
			
			String sqlym ="select *from shouruqingkuang";
			Statement stsym =conn.createStatement();
			ResultSet rs=stsym.executeQuery(sqlym);
			
			while(rs.next()) {
				Shouruqingkuangym shouruqingkuang=new Shouruqingkuangym();
				shouruqingkuang.setId(rs.getInt("id"));
	    		shouruqingkuang.setFashengfeiyongym(rs.getString("fashengfeiyongym"));
	    		shouruqingkuang.setFashengriqiym(rs.getString("fashengriqiym"));
	    		shouruqingkuang.setHuzhuym(rs.getString("huzhuym"));
	    		shouruqingkuang.setMingxiym(rs.getString("mingxiym"));
				zhushus.add(shouruqingkuang);
			}
			rs.close();
			stsym.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		// TODO 自动生成的方法存根
		return zhushus;
	}


	@Override
	public int modify(Shouruqingkuangym shouruqingkuang) {
		try {
			Connection conn = JDBCUtil.getConnection();
			
			String sqlym ="update shouruqingkuang set fashengfeiyongym=?,fashengriqiym=?,huzhuym=?,mingxiym=? where id=?";
			PreparedStatement prestmym=conn.prepareStatement(sqlym);
			prestmym.setString(1,shouruqingkuang.getFashengfeiyongym());
			prestmym.setString(2,shouruqingkuang.getFashengriqiym());
			prestmym.setString(3,shouruqingkuang.getHuzhuym());
			prestmym.setString(4,shouruqingkuang.getMingxiym());
			prestmym.setInt(5,shouruqingkuang.getId());
			prestmym.executeUpdate();
			prestmym.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return 0;
	}


	@Override
	public int create(Shouruqingkuangym shouruqingkuang) {
		try {
			Connection conn = JDBCUtil.getConnection();
			String sqlym ="Insert into shouruqingkuang (fashengfeiyongym,fashengriqiym,huzhuym,mingxiym) values(?,?,?,?)";
			PreparedStatement prestmym=conn.prepareStatement(sqlym);
			prestmym.setString(1,shouruqingkuang.getFashengfeiyongym());
			prestmym.setString(2,shouruqingkuang.getFashengriqiym());
			prestmym.setString(3,shouruqingkuang.getHuzhuym());
			prestmym.setString(4,shouruqingkuang.getMingxiym());
			prestmym.executeUpdate();
			prestmym.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return 0;
	}


	@Override
	public int remove(Shouruqingkuangym shouruqingkuang) {
		int flagym=0;
		try {
			Connection conn = JDBCUtil.getConnection();
			String sqlym ="delete from shouruqingkuang where id=?";
			PreparedStatement prestmym=conn.prepareStatement(sqlym);
			prestmym.setInt(1, shouruqingkuang.getId());
			flagym = prestmym.executeUpdate();
			prestmym.close();
			conn.close();
		}
		catch(Exception e) {
			e.printStackTrace();
		}
		return flagym;
	}


	@Override
	public Shouruqingkuangym findByIdym(String idym) {
		// TODO 自动生成的方法存根
		return null;
	}


	@Override
	public Shouruqingkuangym findByUsername(String text) {
		// TODO 自动生成的方法存根
		return null;
	}


}