fixage.java

ibatis + sqlserver 学生成绩管理

package util;

import bean.Student;
import dao.IStudentDAO;
import dao.IStudentDAOImpl;

/*
 * 修正Age数据
 */
public class FixAge {
	public static void main(String[] args) {
		long begin = 2007082001;
		Student studentOld;
		IStudentDAO studentDAO = new IStudentDAOImpl();
		int count = 0;

		for (int i = 0; i < 70; i++) {
			int age = (int) Math.round(20 + (Math.random() * 2));
			long number = begin + i;

			System.out.println(number);
			studentOld = studentDAO.queryAllStudentById(String.valueOf(number));

			if (studentOld == null) {
				count++;
				continue;
			}

			Student studentNew = new Student();
			studentNew.setSid(studentOld.getSid());
			studentNew.setSname(studentOld.getSname());
			studentNew.setSex(studentOld.getSex());
			studentNew.setAge(age);
			studentNew.setComment(studentOld.getComment());

			studentDAO.updateStudentById(studentNew);
		}

		System.out.println("-------------empty-------------:" + count);
	}
}