计算机生产实习项目的所有资料

package com.awp.serviceImp; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import com.awp.dao.BaseDao; import com.awp.daoImp.BaseDaoImp; import com.awp.entity.ContentInfo; import com.awp.entity.MgrInfo; import com.awp.entity.SubContentInfo; import com.awp.entity.UserInfo; import com.awp.service.BaseService; import com.awp.service.MgrService; import com.awp.service.ViewContentService; import com.awp.util.DBUtil; public class MgrServiceImp implements MgrService{ private BaseDao dao=new BaseDaoImp(); private BaseService baseSer=new BaseServiceImp(); private ViewContentService viewSer=new ViewContentServiceImp(); //管理员登录验证 public boolean isEnter(MgrInfo mgr) { String sql="select mgrname from mgrinfo where mgrname='"+ mgr.getMgrname()+"' and mgrpass='" +mgr.getMgrpass()+"'"; ResultSet set=dao.getSet(sql); boolean flag=false; try { if(set.next()){ flag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ dao.getDbutil().closeAll(); } return flag; } //得到所有文章对象列表 public ArrayList getAllContent() { String sql="select conid,userid,contitle,content,stime from content order by stime desc"; ResultSet set=dao.getSet(sql); ArrayList alist=new ArrayList(); try { while(set.next()){ ContentInfo ci=new ContentInfo(); ci.setConid(set.getInt(1)); ci.setUser(baseSer.getUserInfo(set.getInt(2))); ci.setContitle(set.getString(3)); ci.setContent(set.getString(4)); ci.setStime(set.getDate(5)); alist.add(ci); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ dao.getDbutil().closeAll(); } return alist; } //获得评论信息 public ArrayList getAllSubContent(String conid){ String sql="select subid,userid,subcontent,stime from subcontent where conid="+conid; ResultSet set=dao.getSet(sql); ArrayList list=new ArrayList(); try { while(set.next()){ SubContentInfo sub=new SubContentInfo(); sub.setContent(viewSer.getContent(conid.trim())); sub.setStime(set.getDate(4)); sub.setSubcontent(set.getString(3)); sub.setSubid(set.getInt(1)); sub.setUser(baseSer.getUserInfo(set.getInt(2))); list.add(sub); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ dao.getDbutil().closeAll(); } return list; } //根据id得到一个文章实体对象 public ContentInfo getContent(String conid) { String sql="select userid,contitle,content,stime from content where conid="+conid; ResultSet set=dao.getSet(sql); ContentInfo con=null; try { if(set.next()){ con=new ContentInfo(); con.setConid(Integer.parseInt(conid.trim())); con.setContent(set.getString(3)); con.setContitle(set.getString(2)); con.setStime(set.getDate(4)); //获得文章属于UserInfo对象的ID,根据ID得到UserInfo 对象 int userid=set.getInt(1); //根据UserInfo对象id得到Userinfo 对象 UserInfo user=baseSer.getUserInfo(userid); con.setUser(user);//设置Userinfo 对象进入文章的属性 } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ dao.getDbutil().closeAll(); } return con; } //根据文章号删除文章 public void deleteContent(String conid) { String sql="delete content where conid="+conid; dao.deleteMethod(sql); } //删除用户 public void deleteUser(int userid){ String sql="update userinfo set userdel=1 where userid="+userid; dao.deleteMethod(sql); } }