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.*;
import com.xxgl.data.DBUtil;
import com.xxgl.data.DBconnection;

public class NewstuBO {
	/*public int insertByParameter(NewstudentBean parameter) {
		String sql = "insert into parameter (name,writedate,fvalue) values (?,?,?)";

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

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

			pstmt.setString(1, parameter.getName());
			pstmt.setDate(2, parameter.getWritedate());
			pstmt.setFloat(3, parameter.getFvalue());

			count = pstmt.executeUpdate();

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

	public int updateParameter(ParameterBean parameter) {
		String sql = "update parameter set name=?,writedate=?,fvalue=? where id=? ";

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

			pstmt.setString(1, parameter.getName());
			pstmt.setDate(2, parameter.getWritedate());
			pstmt.setFloat(3, parameter.getFvalue());
			pstmt.setInt(4, parameter.getId());

			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 NewstudentBean selectNewstu(String rxnf) {
		String sql = "select S_name,Sex,age,Zzmm,jg from newstudent where in_year=?";

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

			pstmt.setString(1, rxnf);

			ResultSet rs = pstmt.executeQuery();

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

				newstuBean.setS_name(rs.getInt("S_name"));
				newstuBean.setSex(rs.getString("sex"));
				newstuBean(rs.getFloat("fvalue"));
				pdBean.setWritedate(rs.getDate("writedate"));
			}
			
			DBUtil.close(rs);
			

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

		return pdBean;
	}

	/*public List selectAllNewstu() {
		String sql = "select id,name,fvalue,writedate from parameter ";

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

			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				ParameterBean pdBean = new ParameterBean();

				pdBean.setId(rs.getInt("id"));
				pdBean.setName(rs.getString("name"));
				pdBean.setFvalue(rs.getFloat("fvalue"));
				pdBean.setWritedate(rs.getDate("writedate"));
				
				list.add(pdBean);
			}
			DBUtil.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}
*/
		return list;
	}
}