package com.action;

import java.sql.SQLException;
import com.dao.CompUserDAO;
import com.bean.CompUser;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TestInsert {
    public static void main(String[] args) throws SQLException {
        for (int i = 500; i <20000; i++) {
            CompUser compuser = new CompUser();
            compuser.setDelFlag(0);
            compuser.setDepartment("技術部"+i);
            compuser.setPosition("程序員");
            compuser.setRealName("王五"+i);
            compuser.setSex("男");
            try {

                CompUserDAO.startTransation();
                int lastId = CompUserDAO.getLastId();
                compuser.setCompUserId(lastId + 1);
                compuser.setDelFlag(0);
                CompUserDAO.insertCompUser(compuser);
                CompUserDAO.commit();
                System.out.print(i+",");
                if(i%40==0) System.out.println();

            } catch (SQLException e) {

                e.printStackTrace();
            }finally{
                 CompUserDAO.rollback();
            }

        }
    }
}