friendlinkbean.java

来自「就业管理系统 源代码 可以运行 没有错误」· Java 代码 · 共 348 行

package com.bean;

/**
 * 友情链接操作类 增加 修改 删除 申请
 * @author Administrator
 *
 */

import java.io.File;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import com.util.Constant;
import com.util.DBO;

public class FriendLinkBean {

	private List list;
	private ResultSet rs;
	private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	
	//友情链接分页
	private int EVERYPAGENUM = 2;
	private int count = -1;
	private int qq = 0;
	private String sql="select count(*) from fz_friendlink where ifhide!='2'";
	private String sql2="select * from fz_friendlink where ifhide!='2' order by ordervalue desc ";
    public void setEVERYPAGENUM(int EVERYPAGENUM){
    	this.EVERYPAGENUM=EVERYPAGENUM;
    }
    public int getMessageCount() { //得到信息总数
       DBO dbo=new DBO();
       dbo.open();
        try { 
            rs = dbo.executeQuery(sql);
            rs.next();
            count = rs.getInt(1);
            return count;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return -1;
        } finally {
            dbo.close();
        }
    }
    public int getPageCount() { //得到共多少页（根据每页要显示几条信息）
        if (count % EVERYPAGENUM == 0) {
            return count / EVERYPAGENUM;
        } else {
            return count / EVERYPAGENUM + 1;
        }
    }
    public List getMessage(int page) { //得到每页要显示的信息
        DBO dbo=new DBO();
        dbo.open();
        List list = new ArrayList();
        try {
            rs = dbo.executeQuery(sql2);
            for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
                rs.next();
            }
            for (int t = 0; t < EVERYPAGENUM; t++) {
                if (rs.next()) {
                    qq++;
                    List list2=new ArrayList();
                    list2.add(rs.getInt(1));
    				list2.add(rs.getString(2));
    				list2.add(rs.getString(3));
    				list2.add(rs.getString(4));
    				list2.add(rs.getString(5));
    				list2.add(rs.getInt(6));
    				list2.add(rs.getInt(7));
    				list2.add(rs.getString(8));
    				list.add(list2);
                } else {
                    break; //减少空循环的时间
                }
            }
            return list;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return list;
        } finally {
            dbo.close();
        }
    }
	//add friendlink
	public int addFriendLink(String linkname,String linkurl,String linkpic,String intero,String ifhide,String ordervalue){
		String sql = "insert into fz_friendlink (linkname,linkurl,linkpic,intero,ifhide,ordervalue,addtime) " +
				"values ('"+linkname+"','"+linkurl+"','"+linkpic+"','"+intero+"','"+ifhide+"','"+ordervalue+"','"+date+"')";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	
	//update friendlink with logo
	public int updateFriendLink(int id,String linkname,String linkurl,String linkpic,String intero,String ifhide,String ordervalue){
		String sql = "update fz_friendlink set linkname = '"+linkname+"',linkurl='"+linkurl+"',linkpic='"+linkpic+"'," +
				"intero='"+intero+"',ifhide='"+ifhide+"',ordervalue='"+ordervalue+"' where id = '"+id+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	
////	update friendlink without logo
//	public int updateFriendLinkNoLogo(int id,String linkname,String linkurl,String intero,String ifhide,String ordervalue){
//		String sql = "update fz_friendlink set linkname = '"+linkname+"',linkurl='"+linkurl+"'," +
//				"intero='"+intero+"',ifhide='"+ifhide+"',ordervalue='"+ordervalue+"' where id = '"+id+"' ";
//		DBO dbo = new DBO();
//		dbo.open();
//		try{
//			int i = dbo.executeUpdate(sql);
//			if(i == 1){
//				return Constant.SUCCESS;
//			}
//			else{
//				return Constant.SYSTEM_ERROR;
//			}
//		}catch(Exception e){
//			e.printStackTrace();
//			return Constant.SYSTEM_ERROR;
//		}finally{
//			dbo.close();
//		}
//	}
	//delete friendlink
	public int delFriendLink(int id,String dir){
		String sql = "delete from fz_friendlink where id = '"+id+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
//			rs = dbo.executeQuery("select linkpic from fz_friendlink where id='"+id+"'");
//			rs.next();
//			String str=rs.getString(1);
//			del(dir+str);
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	public void del(String filepath) {
		try{
			File f = new File(filepath);//定义文件路径        
			if(f.exists()){//判断是文件还是目录
			    f.delete();//递归调用
			}
		}catch(Exception e){
			
		}
	}


	
	//get one friendlink to update
	public List getOneFriendLink(int id){
		String sql = "select * from fz_friendlink where id = '"+id+"'";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				list.add(rs.getInt(1));
				list.add(rs.getString(2));
				list.add(rs.getString(3));
				list.add(rs.getString(4));
				list.add(rs.getString(5));
				list.add(rs.getInt(6));
				list.add(rs.getInt(7));
				list.add(rs.getString(8));
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	
	//get friendlink count
	public int getFriendLinkCount(){
		String sql = "select count(*) from fz_friendlink ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				return rs.getInt(1);
			}
			else{
				return 0;
			}
		}catch(Exception e){
			e.printStackTrace();
			return 0;
		}finally{
			dbo.close();
		}
	}
	
//	order friendlink 
	public int orderFriendLink(int id,int ordervalue){
		String sql = "update fz_friendlink set ordervalue = '"+ordervalue+"' where id='"+id+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			return i;
		}catch(Exception e){
			e.printStackTrace();
			return Constant.DEFAULT_ERROR;
		}finally{
			dbo.close();
		}
	}
	/**********************************************************
	 * 申请链接
	 *********************************************************/
	//申请链接
	public int shenqingFriendLink(String linkname,String linkurl,String linkpic,String intero){
		String sql = "insert into fz_friendlink (linkname,linkurl,linkpic,intero,ifhide,ordervalue,addtime) " +
				"values ('"+linkname+"','"+linkurl+"','"+linkpic+"','"+intero+"','2','0','"+date+"')";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	//审核链接
	public int shFriendLink(int id){
		String sql = "update fz_friendlink set ifhide = '1' where id='"+id+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			return i;
		}catch(Exception e){
			e.printStackTrace();
			return Constant.DEFAULT_ERROR;
		}finally{
			dbo.close();
		}
	}
	//新申请未审核的链接
	public List getAllNeedFriendLink(){
		String sql = "select id,linkname,linkurl,linkpic,intero,addtime from fz_friendlink where ifhide='2' order by ordervalue desc";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				List list2 = new ArrayList();
				list2.add(rs.getInt(1));
				list2.add(rs.getString(2));
				list2.add(rs.getString(3));
				list2.add(rs.getString(4));
				list2.add(rs.getString(5));
				list2.add(rs.getString(6));
				list.add(list2);
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	/*******************************************************
	 * 首页显示链接
	 ***************************************************/
	//新申请未审核的链接
	public List getAllShowFriendLink(){
		String sql = "select linkname,linkurl,linkpic,intero from fz_friendlink where ifhide='1' order by ordervalue desc";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				List list2 = new ArrayList();
				list2.add(rs.getString(1));
				list2.add(rs.getString(2));
				list2.add(rs.getString(3));
				list2.add(rs.getString(4));
				list.add(list2);
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
}