/**
 * 
 */
package cn.com.aheadsoft.infomanager;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import cn.com.aheadsoft.conndb.DBConnection;
import cn.com.aheadsoft.infodata.UrlInfo;

/**
 * @author
 *
 */
public class PersonManage {

	DongtaiInfoManager manager= new DongtaiInfoManager();
	/*插入鏈接信息
	 * */
	public void AddPerson(UrlInfo perData){
		String sql="insert into Url(Board,IssuanceDate,LinkName,Url,Memo)"
			+" values('"+perData.getBoard()+"','"+perData.getIssuanceDate()+"','"+perData.getLinkName()+"','"+
			perData.getUrl()+"','"+perData.getMemo()+"')";

		manager.executeUpdate(sql);//執行插入的sql語句
	}
	/**
	 * 獲得單個鏈接的信息
	 * @return
	 */
	public Collection getOneUrl(String InfoID){
		 //String ProjectBoard="項目進度信息欄";
	     //String sql="select * from Url";//;modleId ="+modleId+"
	     String sql="select * from Url where InfoId="+InfoID;
	     return getUrlBySql(sql);
	}
	/**
	 * 獲得所有鏈接的信息
	 * @return
	 */
	public Collection getAllUrl(String Board){
		 //String ProjectBoard="項目進度信息欄";
	     //String sql="select * from Url";//;modleId ="+modleId+"
	     String sql="select * from Url where Board='"+Board+"'";
	     return getUrlBySql(sql);
	}
	/*
	 * 刪除鏈接相關信息
	 * */
	public void deleteUrl(UrlInfo perData){
		 String sql="delete from Url where InfoId="+perData.getInfoId();
		manager.executeUpdate(sql);
	}
	/*
	 * 修改鏈接相關信息
	 * */
	public void updateUrl(UrlInfo perData){
		 String sql="update Url set Board='"+perData.getBoard()
		              +"',LinkName ='"+perData.getLinkName()
					  +"',Url ='"+perData.getUrl()
					  +"',Memo ='"+perData.getMemo()
					  +"' where InfoId="+perData.getInfoId();
		manager.executeUpdate(sql);
	}
	
	private Collection getUrlBySql(String sql){
		DBConnection dbcn=new DBConnection();
		Connection con= null;
		Statement stm = null;
		ResultSet rs = null;
		List userlist = null;
		try{
			con=dbcn.getConnection();
    	    stm =con.createStatement();
    	    rs=stm.executeQuery(sql);
    	    userlist = new ArrayList();
    	    while(rs.next()){
    	    	UrlInfo UrlDate = new UrlInfo();
    	    	UrlDate.setInfoId(rs.getString("InfoId"));
    	    	UrlDate.setLinkName(rs.getString("LinkName"));
    	    	UrlDate.setBoard(rs.getString("Board"));
    	    	UrlDate.setIssuanceDate(rs.getString("IssuanceDate"));
    	    	UrlDate.setUrl(rs.getString("Url"));
    	    	UrlDate.setMemo(rs.getString("Memo"));
    	    	userlist.add(UrlDate);
    	    }
		}catch(Exception ex){
		    System.out.println(ex);	
		}finally{
    		try{
         		 dbcn.CloseCon();
         		}catch(Exception ex){
         			System.out.println(ex);
         		}
         	}
		return userlist;
	}
}