firstleveltitledboperation.java~71~

有发布

package DB;

import java.sql.*;
import java.util.*;

import bean.*;

public class FirstLevelTitleDbOperation {
    public FirstLevelTitleDbOperation() {
    }

    public int insterfirst(FirstLevelTitle fTitle) throws SQLException {
        int host = 0;
        Connection con = null;
        ResultSet ret = null;
        PreparedStatement stmt = null;

        try {
            ConnectionBean dbcon = ConnectionBean.newInstance();
            con = dbcon.getConnDB();
            stmt = con.prepareStatement(
                    "insert into FirstLevelTitle(TitleName,Creater) values(?,?)");
            stmt.setString(1, fTitle.getTitleName());
            stmt.setString(2, fTitle.getCreater());
            host = stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            con.close();
            stmt.close();
        }
        return host;
    }

    public ArrayList getFristTitle() throws SQLException {
        ArrayList list = new ArrayList();
        Connection con = null;
        ResultSet ret = null;

        try {
            ConnectionBean dbcon = ConnectionBean.newInstance();
            con = dbcon.getConnDB();
            PreparedStatement pre = con.prepareStatement(
                    "select * from FirstLevelTitle order by CreatTime desc");
            ret = pre.executeQuery();

            while (ret.next()) {
                FirstLevelTitle fTitle = new FirstLevelTitle();
                fTitle.setID(ret.getInt("Id"));
                fTitle.setTitleName(ret.getString("TitleName"));
                fTitle.setCreater(ret.getString("Creater"));
                fTitle.setCreatTime(ret.getDate("CreatTime"));
                list.add(fTitle);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            con.close();
            ret.close();
        }
        return list;
    }


}