menudaoimp.java

B2C的J2EE开发的 MVC +DAO 设计

package ldsj.gjm.Dao.imp;

import java.awt.Menu;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import ldsj.gjm.Dao.menuDao;
import ldsj.gjm.menudb.menudb;
import ldsj.gjm.pojo.menuBean;


public class menuDaoImp implements menuDao
{
	public ArrayList getChildMenu(String right,String menuName)
	{
	   ArrayList secondList=new ArrayList();
	   menudb mdb=new menudb();
	   Connection con=mdb.getMenuDB();
	   String sql="select * from menu where userLevel=? and headMenu=?";
	  try
	  {
		  PreparedStatement ps=con.prepareStatement(sql);
		   ps.setString(1,right);
		   ps.setString(2,menuName);
		   ResultSet rs=ps.executeQuery();
		   
		   while(rs.next())
		   {
			   String menuInfo_ch=rs.getString("menuInfo_ch");
			   String menuInfo_en=rs.getString("menuInfo_en");
			   String menupath=rs.getString("menuPath");
			   String headMenu=rs.getString("headMenu");
			   menuBean menubean=new menuBean();
			   menubean.setMenuInfo_ch(menuInfo_ch);
			   menubean.setMenuInfo_en(menuInfo_en);
			   menubean.setMenuPath(menupath);
			   menubean.setHeadMenu(headMenu);
			   secondList.add(menubean);
			   
		   }
	  }
	  catch(Exception e)
	  {
		  e.printStackTrace();
	  }
	   return secondList;
	}
}