bean1.java

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

package untitled1;

import java.sql.*;

public class Bean1 {
private String title=null;
    private String titlename;
    Connection con=null;
    PreparedStatement s=null;

    ResultSet rs=null;
    public Bean1() {
    }

    public void setTitlename(String titlename) {
        this.titlename = titlename;
    }

    public void setCreater(String creater) {
        this.creater = creater;
    }

    public void setCreattime(String creattime) {
        this.creattime = creattime;
    }

    public String getTitlename() {
        return titlename;
    }

    public String getCreater() {
        return creater;
    }

    public String getCreattime() {
        return creattime;
    }

    private String creater;
    private String creattime;


    public boolean sqlinsert()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("Jdbc:Odbc:news","sa","123");
            s =con.prepareStatement("insert into FirstLevelTitle(TitleName,Creater,CreatTime) values(?,?,?)");
            s.setString(1,getTitlename());
            s.setString(2,getCreater());
            s.setString(3,getCreattime());
            s.executeUpdate();
        } catch (Exception ex) {
            System.out.println(ex);
            return false;
        }
        return true;
    }


    public void myclose()
    {
        try
        {
            if (rs!=null)
                rs.close();
            if (s != null)
                s.close();
            if (con != null)
                con.close();
        }catch(SQLException ex)
        {
            System.out.println(ex);
        }
    }


}