linkdatabean.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 145 行

/*
 * 创建日期 2006-6-16
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.icefish.bean;

import java.sql.*;
import net.icefish.bean.Conn;
import net.icefish.bean.LinkBean;

/**
 * @author LittleChild
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class LinkDataBean {
	
	private Connection conn;	
	
	public LinkDataBean(){
		this.conn=Conn.connection();
	}
	
	//增加新帮助
	public boolean addLink(LinkBean linkBean){
		boolean flag=false;
        
		String link_pass=new String();
		if(linkBean.getLink_Pass()){
			link_pass="true";
		}else{
			link_pass="false";
		}
		String link_islogo=new String();
		if(linkBean.getLink_Islogo()){
			link_islogo="true";
		}else{
			link_islogo="false";
		}
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("insert into icefish_link(link_name,link_info,link_url,link_logo,link_islogo,link_pass) values(?,?,?,?,?,?)");
    		pstmt1.setString(1, linkBean.getLink_Name());
    		pstmt1.setString(2, linkBean.getLink_Info());
    		pstmt1.setString(3, linkBean.getLink_Url());
    		pstmt1.setString(4, linkBean.getLink_Logo());
    		pstmt1.setString(5, link_islogo);
    		pstmt1.setString(6, link_pass);
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
                flag = true;
            }
            else{
                flag = false;
            }
    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
    	
		return flag;		
	}
	
	//修改帮助内容
	public boolean editLink(LinkBean linkBean){
		boolean flag=false;
        
		String link_pass=new String();
		if(linkBean.getLink_Pass()){
			link_pass="true";
		}else{
			link_pass="false";
		}
		String link_islogo=new String();
		if(linkBean.getLink_Islogo()){
			link_islogo="true";
		}else{
			link_islogo="false";
		}
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("update icefish_link set link_name=?,link_info=?,link_url=?,link_logo=?,link_islogo=?,link_pass=? where link_id="+linkBean.getLink_ID());
    		pstmt1.setString(1, linkBean.getLink_Name());
    		pstmt1.setString(2, linkBean.getLink_Info());
    		pstmt1.setString(3, linkBean.getLink_Url());
    		pstmt1.setString(4, linkBean.getLink_Logo());
    		pstmt1.setString(5, link_islogo);
    		pstmt1.setString(6, link_pass);
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
    			flag = true;
    		}
    		else{
    			flag = false;
    		}    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		
    	return flag;	
	}

	//删除帮助内容
	public boolean delLink(LinkBean linkBean){
		boolean flag=false;
		
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("delete from icefish_link where link_id=?");
    		pstmt1.setString(1, linkBean.getLink_ID());
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
    			flag = true;
    		}
    		else{
    			flag = false;
    		}    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		
    	return flag;		
	}
	
	
	
	

}