employeedaotest.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.dao.test;

import java.sql.Connection;
import java.sql.Date;
import java.sql.SQLException;

import com.oa.lp.dao.EmployeeDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Employee;


public class EmployeeDAOTest {

	public static void main(String[] args) throws Exception {
		Connection conn = DataBase.getConnection();
		
		EmployeeDAO employeeDao = new EmployeeDAO();
		employeeDao.setConn(conn);
		
		Employee employee = new Employee();
		//Date date = new Date(0, 0, 0);
		
		employee.setUserName("honey");
		employee.setUserPwd("123");
		employee.setSex(1);
		employee.setAge(22);
		employee.setBirthDay("18");
		employee.setSchoolAge("20");
		employee.setSepciality("好人");
		employee.setSchool("西安培华学院");
		employee.setEmail("[e-mail]");
		employee.setQq("525119057");
		employee.setTel("8568122");
		employee.setMobileTel("13488238667");
		employee.setAddress("西巴黎");
		employee.setIdCard("888");
		//employee.setWorkDate(date);
		//employee.setDimissionDate(date);
		employee.setFlag(1);

		employeeDao.addEmployee(employee);
	
		//employee = employeeDao.getById(1);
		//System.out.println(employee.getUserName());
;		//System.out.println(employee.getUserPwd());
		DataBase.commit();
		DataBase.releaseConnection(conn);

	}

}