firstleveltitlebean.java

源码新闻发布系统

package newsreleasesystem;

import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

public class FirstLevelTitleBean {
    private String FLId;
    private String FLTitleName;
    private String FLCreater;
    private String FLCreatTime;
    SQLBean sqlb=new SQLBean();
    ConvertGBKBean cb=new ConvertGBKBean();
    Connection con=null;

    public FirstLevelTitleBean() {
    }

    public boolean sqlvalidate(String str){
        try {
            if(sqlb.getCon()!=null){
                con=sqlb.getCon();
                String strSql="select * from FirstLevelTitle where FLTitleName='"+str+"'";
                Statement stmt=con.createStatement();
                ResultSet rs=stmt.executeQuery(strSql);
                if(rs.next()){
                    return false;
                }else{
                    return true;
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return false;
    }

    public void sqlinsertdata(String str){
        try {
            if(sqlb.getCon()!=null){
                con=sqlb.getCon();
                String strSql="insert into FirstLevelTitle(FLTitleName,FlCreater,FLCreatTime) values('"+str+"','rj',getdate())";
                Statement stmt=con.createStatement();
                stmt.executeUpdate(strSql);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }

    public void setFLId(String FLId) {
        this.FLId = FLId;
    }

    public String getFLId() {
        return FLId;
    }

    public void setFLTitleName(String FLTitleName) {
        this.FLTitleName = FLTitleName;
    }

    public String getFLTitleName() {
        return FLTitleName;
    }

    public void setFLCreater(String FLCreater) {
        this.FLCreater = FLCreater;
    }

    public String getFLCreater() {
        return FLCreater;
    }

    public void setFLCreatTime(String FLCreatTime) {
        this.FLCreatTime = FLCreatTime;
    }

    public String getFLCreatTime() {
        return FLCreatTime;
    }
}