secondleveltitledboperation.java~38~

有发布

package DB;

import bean.FirstLevelTitle;
import java.sql.*;
import bean.ConnectionBean;
import bean.SecondLevelTitle;
import java.sql.PreparedStatement;
import java.util.ArrayList;

public class SecondLevelTitleDbOperation {
    private Object con;
    public SecondLevelTitleDbOperation() {
    }

    public int instersecond(SecondLevelTitle sTitle)
    {
         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 SecondLevelTitle(TitleName,FilePath,Creater,ParentTitle) values(?,?,?,?)");
            stmt.setString(1, sTitle.getTitleName());
            stmt.setString(2, sTitle.getFilePath());
            stmt.setString(3, sTitle.getCreater());
            stmt.setInt(4, sTitle.getParentTitle());
            host = stmt.executeUpdate();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
           con.close();
           stmt.close();
        }
        return host;
    }

    public ArrayList getSecondTitle() 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 SecondLevelTitle  where ParentTitle=(?) 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;
    }
}