menudaotest.java

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

package com.oa.lp.dao.test;

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

import com.oa.lp.dao.MenuDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Menu;

public class MenuDAOTest {

	public static void main(String[] args) throws Exception {
		Connection conn = DataBase.getConnection();
		MenuDAO menuDao = new MenuDAO();
		
		menuDao.setConn(conn);
		
		Menu menu = new Menu();
		menu.setParentMenuId(2);
		menu.setMenuName("菜单管理");
		menu.setMenuLink("/menu/index.jsp");
		menu.setMenuOrder(1);
		menu.setMenuState(1);
		System.out.println("haha");
		//新增
		//menuDao.addMenu(menu);
		menu = menuDao.getById(2);
		System.out.println(menu.getMenuId());
		System.out.println(menu.getMenuName());
		DataBase.commit();
		DataBase.releaseConnection(conn);
	
	}

}