bean3.java~6~

来自「新闻发布页面(不带数据库), 路径用的是绝对路径,放自己 本机上要改的说.」· JAVA~6~ 代码 · 共 53 行

package untitled1;
import java.sql.*;

public class Bean3 {

    private String parenttile;
    Connection con=null;
    PreparedStatement s=null;
    ResultSet rs=null;


    public Bean3() {
    }



    public void setParenttile(String parenttile) {
        this.parenttile = parenttile;
    }



    public String getParenttile() {
        return parenttile;
    }
    public ResultSet sqlsearch()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("Jdbc:Odbc:news","sa","123");
            s=con.prepareStatement("select TitleName,FilePath,CreatTime from SecondLevelTitle where ParentTitle=?");
            s.setString(1,getParenttile());
            rs=s.executeQuery();
        } catch (Exception ex) {
            System.out.println(ex);
            return null;
        }
        return rs;
    }
    public void myclose()
    {
        try {
            if (s != null)
                s.close();
            if (con != null)
                con.close();
        } catch (SQLException ex) {
            System.out.println(ex);
        }
    }

}