bean4.java

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

package untitled1;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;


public class Bean4 {

    public Bean4() {
    }
    Connection con=null;
    PreparedStatement s=null;
    ResultSet rs=null;

    public ResultSet sqlSearch()
    {


        try
        {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("Jdbc:Odbc:news","sa","123");
            s=con.prepareStatement("select distinct TitleName from FirstLevelTitle");
            rs=s.executeQuery();


        }catch(Exception es)
        {
            System.out.println(es);
            return null;
        }

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


}