cmsinfodaoim.java

前台:文章浏览、发表留言、Game、Music 后台:文章相关:发表文章、修改文章、删除文章、批量移动文章 栏目相关:增加栏目、修改栏目、删除栏目、栏目链接、栏目排序系统栏目分为系统内部栏目和外部栏目

		}catch(Exception e){
			yhlog.warn("When update a notice,throw an Exception!The notice id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Update a notice successfully,the notice id is:"+id+".");
			return true;
		}else{
			yhlog.info("Update a notice unsuccessfully,the notice id is:"+id+".");
			return false;
		}
	}

	public List getAllSurvey() throws DBConnException {
		List nlist = new ArrayList();
		Survey survey = null;
		String sql = "select n.id,n.title,n.content,n.times,n.ptime from survey as n order by id asc";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				survey = new Survey();
				survey.setId(dbconn.getInt(1));
				survey.setTitle(dbconn.getString(2));
				survey.setContent(dbconn.getString(3));
				survey.setTimes(dbconn.getInt(4));
				survey.setPtime(dbconn.getString(5));
				
				nlist.add(survey);
			}
			
		}catch(Exception e){
			yhlog.warn("When get system all survey,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return nlist;
	}

	public boolean addSurvey(Survey survey) throws DBConnException {
		int i = 0;
		String title = survey.getTitle();
		String content = survey.getContent();
		int times = survey.getTimes();
		String ptime = survey.getPtime();
		
		String sql = "insert into survey(title,content,times,ptime) values('"+title+"','"+content+
						"','"+times+"','"+ptime+"')";
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When insert a survey,throw an Exception!");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Insert survey successfully.");
			return true;
		}else{
			yhlog.info("Insert survey unsuccessfully.");
			return false;
		}
	}

	public boolean addLink(Link link) throws DBConnException {
		int i = 0;
		String name = link.getName();
		String url = link.getUrl();
		String type = link.getType();
		String content = link.getContent();
		String logo = link.getLogo();
		String master = link.getMaster();
		String contact = link.getContact();
		int sort = link.getSort();
		String checked = link.getChecked();
		
		String sql = "insert into link(name,url,type,content,logo,master,contact,sort,checked) values(?,?,?,?,?,?,?,?,?)";
//		String sql = "insert into link(name,url,type,content,logo,master,contact,sort,checked) values('"+name+
//		"','"+url+"','"+type+"','"+content+"','"+logo+"','"+master+"','"+contact+"','"+sort+
//		"','"+checked+"')";
		try{
			dbconn = new DBConnect(sql);
			dbconn.setString(1, name);
			dbconn.setString(2, url);
			dbconn.setString(3, type);
			dbconn.setString(4, content);
			dbconn.setString(5, logo);
			dbconn.setString(6, master);
			dbconn.setString(7, contact);
			dbconn.setInt(8, sort);
			dbconn.setString(9, checked);
			
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When insert a link,throw an Exception!");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Insert a link successfully.");
			return true;
		}else{
			yhlog.info("Insert a link unsuccessfully.");
			return false;
		}
	}

	public boolean deleteLink(int id) throws DBConnException {
		int i = 0;
		String sql = "delete from link where id="+id;
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When delete a link,throw an Exception!The link id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Delete a link successfully,the link id is:"+id+".");
			return true;
		}else{
			yhlog.info("Delete a link unsuccessfully,the link id is:"+id+".");
			return false;
		}
	}

	public boolean updateLink(Link link) throws DBConnException {
		int i = 0;
		int id = link.getId();
		String name = link.getName();
		String url = link.getUrl();
		String type = link.getType();
		String content = link.getContent();
		String logo = link.getLogo();
		String master = link.getMaster();
		String contact = link.getContact();
		int sort = link.getSort();
		String checked = link.getChecked();
		
		String sql = "update link set name=?,url=?,type=?,content=?,logo=?,master=?,contact=?,sort=?,checked=?" +
					 " where id="+id;
		try{
			dbconn = new DBConnect(sql);
			dbconn.setString(1, name);
			dbconn.setString(2, url);
			dbconn.setString(3, type);
			dbconn.setString(4, content);
			dbconn.setString(5, logo);
			dbconn.setString(6, master);
			dbconn.setString(7, contact);
			dbconn.setInt(8, sort);
			dbconn.setString(9, checked);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When update a link,throw an Exception!The link id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Update a link successfully,the link id is:"+id+".");
			return true;
		}else{
			yhlog.info("Update a link unsuccessfully!the link id is:"+id+".");
			return false;
		}
	}

	public Link getLink(int id) throws DBConnException {
		Link link = null;
		String sql = "select l.id,l.name,l.url,l.type,l.content,l.logo,l.master,l.contact," +
						"l.sort,l.checked from link as l where l.id="+id;
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			if(dbconn.next()){
				link = new Link();
				link.setId(dbconn.getInt(1));
				link.setName(dbconn.getString(2));
				link.setUrl(dbconn.getString(3));
				link.setType(dbconn.getString(4));
				link.setContent(dbconn.getString(5));
				link.setLogo(dbconn.getString(6));
				link.setMaster(dbconn.getString(7));
				link.setContact(dbconn.getString(8));
				link.setSort(dbconn.getInt(9));
				link.setChecked(dbconn.getString(10));
				
			}
			
		}catch(Exception e){
			yhlog.warn("When get a link,throw an Exception!The link id is:"+id+".");
		}finally{
			dbconn.close();
		}
		return link;
	}

	public List getAllLink() throws DBConnException {
		List llist = new ArrayList();
		Link link = null;
		String sql = "select l.id,l.name,l.url,l.type,l.content,l.logo,l.master,l.contact," +
						"l.sort,l.checked from link as l order by sort asc";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				link = new Link();
				link.setId(dbconn.getInt(1));
				link.setName(dbconn.getString(2));
				link.setUrl(dbconn.getString(3));
				link.setType(dbconn.getString(4));
				link.setContent(dbconn.getString(5));
				link.setLogo(dbconn.getString(6));
				link.setMaster(dbconn.getString(7));
				link.setContact(dbconn.getString(8));
				link.setSort(dbconn.getInt(9));
				link.setChecked(dbconn.getString(10));
				
				llist.add(link);
			}
			
		}catch(Exception e){
			yhlog.warn("When get system all links,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return llist;
	}
	
	public List getCheckedLink() throws DBConnException {
		List llist = new ArrayList();
		LinkDto link = null;
		String sql = "select l.name,l.url,l.type,l.content,l.logo from link as l where checked='1' order by type desc,sort";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				link = new LinkDto();
				link.setName(dbconn.getString(1));
				link.setUrl(dbconn.getString(2));
				link.setType(dbconn.getString(3));
				link.setContent(dbconn.getString(4));
				link.setLogo(dbconn.getString(5));
				
				llist.add(link);
			}
			
		}catch(Exception e){
			yhlog.warn("When get system all links,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return llist;
	}

	public List getAllTextLink() throws DBConnException {
		List llist = new ArrayList();
		Link link = null;
		String sql = "select l.id,l.name,l.url,l.type,l.content,l.logo,l.master,l.contact," +
						"l.sort,l.checked from link as l where l.type='1' order l.id by sort asc";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				link = new Link();
				link.setId(dbconn.getInt(1));
				link.setName(dbconn.getString(2));
				link.setUrl(dbconn.getString(3));
				link.setType(dbconn.getString(4));
				link.setContent(dbconn.getString(5));
				link.setLogo(dbconn.getString(6));
				link.setMaster(dbconn.getString(7));
				link.setContact(dbconn.getString(8));
				link.setSort(dbconn.getInt(9));
				link.setChecked(dbconn.getString(10));
				
				llist.add(link);
			}
			
		}catch(Exception e){
			yhlog.warn("When get system all text links,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return llist;
	}

	public List getAllImgLink() throws DBConnException {
		List llist = new ArrayList();
		Link link = null;
		String sql = "select l.id,l.name,l.url,l.type,l.content,l.logo,l.master,l.contact," +
						"l.sort,l.checked from link as l where l.type='0' order l.id by sort asc";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				link = new Link();
				link.setId(dbconn.getInt(1));
				link.setName(dbconn.getString(2));
				link.setUrl(dbconn.getString(3));
				link.setType(dbconn.getString(4));
				link.setContent(dbconn.getString(5));
				link.setLogo(dbconn.getString(6));
				link.setMaster(dbconn.getString(7));
				link.setContact(dbconn.getString(8));
				link.setSort(dbconn.getInt(9));
				link.setChecked(dbconn.getString(10));
				
				llist.add(link);
			}
			
		}catch(Exception e){
			yhlog.warn("When get system all image links,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return llist;
	}


}