courseblogicclass.java

关于学校管理

package student.manage.course;

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

import student.manage.excelOutput.read;
import student.manage.javaConnction.connectionDB;

public class CourseBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;

	int insertNum = 0;

	public Statement getConn() {

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

	public int gradeInsert(String course) {
		read r = new read();
		ArrayList list = r.getGradeID(new File(course));
		ArrayList list1 = new ArrayList();
		ArrayList list2 = new ArrayList();
		for(int i = 0 ; i<list.size() ; i++) {
			if(i%2 == 0) {
				 String gradeId = (String)list.get(i);
				 list1.add(gradeId);
			} else {
				String courseId = (String)list.get(i);
				list2.add(courseId);
			}
		}
			
		for(int i = 0 ; i<list1.size();i++) {
					
			String sql = "insert into RIKO_COURSE(GRADE_ID,COURSE_NAME) values('"
				+ list1.get(i) + "','"
				+ list2.get(i) + "')";

		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;

	}
}