package com.xxgl.business;

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

import com.xxgl.bean.NewstudentBean;
import com.xxgl.bean.StudentBean;
import com.xxgl.data.DBUtil;
import com.xxgl.data.DBconnection;

public class NewstuBO {
	public int insertBystu(StudentBean parameter) {
		String sql = "insert into student (s_id,s_name,sex,age,jg,zzmm,adress,phone,memory,yesorno) values (?,?,?,?,?,?,?,?,?,?)";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, parameter.getS_id());
			pstmt.setString(2, parameter.getS_name());
			pstmt.setInt(3, parameter.getSex());
			pstmt.setInt(4,parameter.getAge());
			pstmt.setString(5,parameter.getJg());
			pstmt.setString(6,parameter.getZzmm());
			pstmt.setString(7,parameter.getAdress());
			pstmt.setString(8,parameter.getPhone());
			pstmt.setString(9,parameter.getMemory());
			pstmt.setInt(10,1);

			count = pstmt.executeUpdate();

			DBUtil.close(pstmt);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(con);
		}
		return count;
	}

	public int updatestu(StudentBean parameter) {
		String sql = "update parameter set s_id=?,s_name=?,sex=?,age=?,jg=?,zzmm=?,adress=?,phone=?,memory=?,yesorno=? where id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, parameter.getS_id());
			pstmt.setString(2, parameter.getS_name());
			pstmt.setInt(3, parameter.getSex());
			pstmt.setInt(4, parameter.getAge());
			pstmt.setString(5, parameter.getJg());
			pstmt.setString(6, parameter.getZzmm());
			pstmt.setString(7, parameter.getAdress());
			
			

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}

/*	public int deleteByID(int id) {
		String sql = "delete from parameter where id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, id);

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}
*/
	public StudentBean selectstu(int xh) {
		String sql = "select s_id,s_name,sex,age,jg,zzmm,adress,phone,memory from student where s_id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		StudentBean stuBean=null;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, xh);

			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				stuBean = new StudentBean();

				stuBean.setS_id(rs.getInt("s_id"));
				stuBean.setS_name(rs.getString("s_name"));
				stuBean.setSex(rs.getInt("sex"));
				stuBean.setAge(rs.getInt("age"));
				stuBean.setZzmm(rs.getString("Zzmm"));
				stuBean.setJg(rs.getString("jg"));
				stuBean.setAdress(rs.getString("adress"));
				stuBean.setPhone(rs.getString("phone"));
				stuBean.setMemory(rs.getString("memory"));
							
		}
			
			DBUtil.close(rs);
			

		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return stuBean;
	}

	
	
	public List selectNewstu(String rxnf) {
		String sql = "select s_name,sex,age,zzmm,jg,adress,phone,yesorno,memory,in_year from newstudent where in_year=? and yesorno=1 ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		List list = new ArrayList();
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setString(1, rxnf);

			ResultSet rs = pstmt.executeQuery();

			while (rs.next()) {
				NewstudentBean newstuBean = new NewstudentBean();

				newstuBean.setS_name(rs.getString("s_name"));
				newstuBean.setSex(rs.getInt("sex"));
				newstuBean.setAge(rs.getInt("age"));
				newstuBean.setZzmm(rs.getString("Zzmm"));
				newstuBean.setJg(rs.getString("jg"));
				newstuBean.setAdress(rs.getString("adress"));
				newstuBean.setPhone(rs.getString("phone"));
				newstuBean.setMemory(rs.getString("memory"));
				newstuBean.setIn_year(rs.getString("in_year"));
				list.add(newstuBean);
			}
			
			DBUtil.close(rs);
			

		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return list;
	}

	public List selectAllstu() {
		String sql = "select s_id,s_name,sex,age,jg,zzmm,adress,phone,memory from student ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		List list = new ArrayList();
		
		try {
			pstmt = con.prepareStatement(sql);

			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				StudentBean pdBean = new StudentBean();
				
				 pdBean.setS_id(rs.getInt("s_id"));
				 pdBean.setS_name(rs.getString("s_name"));
				 pdBean.setSex(rs.getInt("sex"));
				 pdBean.setAge(rs.getInt("age"));
				 pdBean.setZzmm(rs.getString("Zzmm"));
				 pdBean.setJg(rs.getString("jg"));
				 pdBean.setAdress(rs.getString("adress"));
				 pdBean.setPhone(rs.getString("phone"));
				 pdBean.setMemory(rs.getString("memory"));
				
				
				list.add(pdBean);
			}
			DBUtil.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return list;
	}
}