teacharblogicclass.java

关于学校管理

package student.manage.teacher;

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

import student.manage.javaConnction.connectionDB;

public class TeacharBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;
	
	int insertNum = 0;

	public Statement getConn() {

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

	public int gradeInsert(TeacharBean teacharBean) {

		String sql = "insert into RIKO_TEACHER(GRADE_ID,COURSE_ID,TEACHER_NAME) values('"
				+ teacharBean.getGRADE_ID() + "','" + teacharBean.getCOURSE_ID()+ "','" + teacharBean.getTEACHAR_NAME()+"')";

		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 getTeacher() {

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

			ResultSet rs = this.getConn().executeQuery(sql);
			while (rs.next()) {
				TeacharBean  teacherBean = new TeacharBean();
				teacherBean.setGRADE_ID(rs.getString("GRADE_ID"));
				
				teacherBean.setTEACHAR_NAME(rs.getString("TEACHER_NAME"));
				
				teacherBean.setCOURSE_ID(rs.getString("COURSE_ID"));
				
				list.add(teacherBean);
			}
		} catch (SQLException e) {
			
			System.out.println("cuole");
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

}