studentblogicclass.java

关于学校管理

package student.manage.student;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import student.manage.javaConnction.connectionDB;

public class StudentBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;

	int insertNum = 0;

	public Statement getConn() {

		state = db.getConnectionDB();
		return state;
	}

	public int gradeInsert(StudentBean studentBean) {
		
		int mark = 0;
		int secondeMark = 0 ;
		if(studentBean.getMARK() != null) {
			mark = studentBean.getMARK();
		}
		if(studentBean.getSECONDE_MARK()!=null){
			secondeMark = studentBean.getSECONDE_MARK();
		}
		String sql = "insert into RIKO_STUDENT(GRADE_ID,CLASS_ID,STUDENT_NAME,MARK,SECONDE_MARK) values('"
				+ studentBean.getGRADE_ID() + "','"
				+ studentBean.getCLASS_ID() + "','"
				+ studentBean.getSTUDENT_NAME() + "',"
				+ mark + ","
				+ secondeMark + ")";

		try {

			insertNum = this.getConn().executeUpdate(sql);
			if (insertNum != 0) {

				System.out.println("chenggong");

			} else {

				System.out.println("shibai");

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return insertNum;

	}

	public ArrayList getStudent() {

		String sql = "select * from RIKO_STUDENT";
		ArrayList list = new ArrayList();
		try {

			ResultSet rs = this.getConn().executeQuery(sql);
			while (rs.next()) {
				StudentBean studentBean = new StudentBean();
				
				studentBean.setGRADE_ID(rs.getString("GRADE_ID"));
				studentBean.setCLASS_ID(rs.getString("CLASS_ID"));
				studentBean.setSTUDENT_NAME(rs.getString("STUDENT_NAME"));
				list.add(studentBean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

}