link.java

新闻发布系统

package dsp.web;

/**
 * <p>Title: DSP实验室</p>
 * <p>Description: DSP教学网
 *                 友情链接类
 * </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author 李艳生
 * @version 1.0
 */
import java.sql.*;
import java.io.*;
import dsp.utils.*;
import dsp.database.*;

public class Link {
	int id;
	String name;
	String url;
	String logo;
	boolean status;  //状态
	String msg;  //提示信息
	//分隔符
	private String s= File.separator;

    public Link() {
		id = 0;
		name = "";
		url = "";
		logo = "0";
		status = false;
		msg = "";
    }
    public String getLogo() {
		return logo;
    }
    public String getMsg() {
		return msg;
    }
    public String getName() {
		return name;
    }
    public boolean isStatus() {
		return status;
    }
    public String getUrl() {
		return url;
    }
    public void setUrl(String url) {
		this.url = url;
    }
    public void setStatus(boolean status) {
		this.status = status;
    }
    public void setName(String name) {
		this.name = name;
    }
    public void setMsg(String msg) {
		this.msg = msg;
    }
    public void setLogo(String logo) {
		this.logo = logo;
    }
    public int getId() {
		return id;
    }
    public void setId(int id) {
		this.id = id;
    }

	/** 删除logo文件
	 *
	 */
	public void delLogo(String path, String file)throws IOException{
		if(!(file.equals("0"))){
			File nf = new File(path +"web" + s + "logo" + s +file);
			if(nf.exists()){
				nf.delete();
			}
		}
	}


	/**添加友情链接:
	 *
	 */
	public void addLink() throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "INSERT INTO web_link (name, url,logo) VALUES ('" + name + "', '" + url + "', '" + logo + "')";

		try{
			conn.update(sql);
			status = true;
		}
		catch(Exception e){
			status = false;
			msg = e.getMessage();
		}
		finally{
			conn.closestmt();
			conn.closeconn();
		}
	}

	/**修改友情链接:
	 *
	 */
	public void modLink(String path) throws ClassNotFoundException, SQLException{
		Operation conn = new Operation();
		String sql = "SELECT * FROM web_link WHERE id="+id;
		ResultSet rs = null;

		try{
			rs = conn.query(sql);
			rs.next();
			if((!(logo.equals(rs.getString("logo")))) &&(!((rs.getString("logo")).equals("0")))){
				delLogo(path, rs.getString("logo"));

				sql = "UPDATE web_link SET name='" + name + "', url= '" + url + "',logo='" + logo + "' WHERE id="+id;
				conn.update(sql);
				status = true;
			}
			else{
				sql = "UPDATE web_link SET name='" + name + "', url= '" + url +"' WHERE id=" + id;
				conn.update(sql);
				status = true;
			}
		}
		catch(Exception e){
			status = false;
			msg = e.getMessage();
		}
		finally{
			conn.closestmt();
			conn.closeconn();
		}
	}

	/**删除友情链接:
	 *
	 */
	public void delLink(String path) throws ClassNotFoundException, SQLException{
	Operation conn = new Operation();
	String sql = "SELECT * FROM web_link WHERE id="+id;
	ResultSet rs = null;

	try{
		rs = conn.query(sql);
		rs.next();
		if(!((rs.getString("logo")).equals("0"))){
			delLogo(path, rs.getString("logo"));
		}

	    sql = "DELETE FROM web_link WHERE id="+id;
		conn.update(sql);
		status = true;
	}
	catch(Exception e){
		status = false;
		msg = e.getMessage();
	}
	finally{
		conn.closestmt();
		conn.closeconn();
	}
}

}