markblogicclass.java

关于学校管理

package student.manage.mark;

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 MarkBlogicClass {

	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();
		MarkBean markBean = new MarkBean();
		ArrayList list = r.getGradeID(new File(course));
		ArrayList list1 = new ArrayList();
		ArrayList list2 = new ArrayList();
		ArrayList list3 = new ArrayList();
		ArrayList list4 = new ArrayList();
		ArrayList list5 = new ArrayList();
		ArrayList list6 = new ArrayList();
		ArrayList list7 = new ArrayList();
		ArrayList list8 = new ArrayList();
		ArrayList list9 = new ArrayList();
		ArrayList list10 = new ArrayList();
		ArrayList list11 = new ArrayList();
		ArrayList list12 = new ArrayList();
		ArrayList list13 = new ArrayList();
		
		int zong = 0;
		for(int i = 0 ; i<list.size();i++) {
			
			if(i%12 == 0) {
				zong = 0;
				String grade_id = (String)list.get(i);
				list1.add(grade_id);
		    }else if(i%12 == 1) {
		    	
		    	String class_id = (String)list.get(i);
		    	list2.add(class_id);
		    } else if(i%12 == 2) {
		    	
		    	String student_id = (String)list.get(i);
		    	list3.add(student_id);
		    }else if(i%12 == 3) {
		    	
		    	String yuwen = (String)list.get(i);
		    	list4.add(yuwen);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 4) {
		    	
		    	String shuxue = (String)list.get(i);
		    	list5.add(shuxue);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 5) {
		    	
		    	String yingyu = (String)list.get(i);
		    	list6.add(yingyu);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 6) {
		    	
		    	String zhengzhi = (String)list.get(i);
		    	list7.add(zhengzhi);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 7) {
		    	
		    	String lishi = (String)list.get(i);
		    	list8.add(lishi);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 8) {
		    	
		    	String shengwu = (String)list.get(i);
		    	list9.add(shengwu);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 9) {
		    	
		    	String huaxue = (String)list.get(i);
		    	list10.add(huaxue);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 10) {
		    	
		    	String wuli = (String)list.get(i);
		    	list11.add(wuli);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    }else if(i%12 == 11) {
		    	
		    	String dili = (String)list.get(i);
		    	list12.add(dili);
		    	zong = Integer.parseInt((String)list.get(i))+zong;
		    	list13.add(zong);
		    }
			
		}
		
			for(int k = 0 ; k<list1.size();k++) {
				
					
				String sql = "insert into RIKO_MARK (GRADE_ID,CLASS_ID,STUDENT_NAME,YUWEN,SHUXUE,YINGYU,ZHENGZHI,LISHI,SHENGWU,HUAXUE,WULI,DILI,ZONG)values('"
						+ list1.get(k) + "','" + list2.get(k)+ "','" + getChn((String)list3.get(k))+ "','" + list4.get(k)+ "','" + list5.get(k)+ "','" + list6.get(k)+ "','" + list7.get(k)+ "','" + list8.get(k)+ "','" + list9.get(k)+ "','" + list10.get(k)+ "','" + list11.get(k)+ "','" + list12.get(k)+ "','" + list13.get(k)+ "')";
		
				System.out.println(sql);
				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 static String getChn(String str)	
	{
		String outStr = "";	
		try
		{
			str = new String(str.getBytes("gb2312"),"GBK");	
			outStr = str;
		}catch(Exception ex)
		{
		
		}
		return outStr;
	}
}