gradeblogicclass.java

关于学校管理

package student.manage.grade;

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

import student.manage.javaConnction.connectionDB;

public class GradeBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;
	
	int insertNum = 0;

	public Statement getConn() {

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

	public int gradeInsert(GradeBean gradeBean) {

		String sql = "insert into RIKO_GRADE(GRADE_ID,CLASS_NUM) values('"
				+ gradeBean.getGRADE_ID() + "','" + gradeBean.getCLASS_NUM()+ "')";

		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;

	}

}