firstleveltitledboperation.java~67~

有发布

package DB;

import bean.ConnectionBean;
import bean.FirstLevelTitle;
import bean.SecondLevelTitle;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

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())
           {
               SecondLevelTitle sTitle = new SecondLevelTitle();
               sTitle.setId(ret.getInt("Id"));
               sTitle.setTitleName(ret.getString("TitleName"));
               sTitle.setFilePath(ret.getString("FilePath"));
               sTitle.setCreater(ret.getString("Creater"));
               sTitle.setCreatTime(ret.getDate("CreatTime"));
               sTitle.setParentTitle(ret.getInt("ParentTitle"));
               list.add(sTitle);
           }
       }
       catch(Exception e)
       {
           e.printStackTrace();
       }
       finally
       {
           con.close();
           ret.close();
       }
       return list;
   }


}