bean2.java

新闻发布页面(不带数据库), 路径用的是绝对路径,放自己 本机上要改的说.

package untitled1;
import java.sql.*;

public class Bean2 {
    private String titlename2;
    private String filrpath;
    private String creater2;
    private String creattime2;
    private String parenttitle;
    Connection con=null;
    PreparedStatement s=null;

    public Bean2() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void setTitlename2(String titlename2) {
        this.titlename2 = titlename2;
    }

    public void setFilrpath(String filrpath) {
        this.filrpath = filrpath;
    }

    public void setCreater2(String creater2) {
        this.creater2 = creater2;
    }

    public void setCreattime2(String creattime2) {
        this.creattime2 = creattime2;
    }

    public void setParenttitle(String parenttitle) {
        this.parenttitle = parenttitle;
    }

    public String getTitlename2() {
        return titlename2;
    }

    public String getFilrpath() {
        return filrpath;
    }

    public String getCreater2() {
        return creater2;
    }

    public String getCreattime2() {
        return creattime2;
    }

    public String getParenttitle() {
        return parenttitle;
    }
    public boolean sqlinsert2()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("Jdbc:Odbc:news","sa","123");
            s=con.prepareStatement("insert into SecondLevelTitle(TitleName,FilePath,Creater,CreatTime,ParentTitle) values(?,?,?,?,?)");
            s.setString(1,getTitlename2());
            s.setString(2,getFilrpath());
            s.setString(3,getCreater2());
            s.setString(4,getCreattime2());
            s.setString(5,getParenttitle());
            s.executeUpdate();
        } catch (Exception ex) {
            System.out.println(ex);
            return false;
        }
        return true;
    }
    public void myclose()
    {
        try {
            if (s != null)
                s.close();
            if (con != null)
                con.close();
        } catch (SQLException ex) {
            System.out.println(ex);
        }
    }

    private void jbInit() throws Exception {
    }

}