c004346ed4a3001d16ddcf45cb43ae9f

实习的时候做的数字校园系统

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 List selectNewstu(String rxnf) {
		String sql = "select s_name,sex,age,zzmm,jg,adress,phone,yesorno,memory 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 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;
	}
}*/