seconddao.java

来自「新闻发布系统」· Java 代码 · 共 105 行

package shen;

import java.sql.*;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.util.*;

public class SecondDao {
    Connection conn = null;
   PreparedStatement st = null;
   ResultSet re = null;
   public void setConn(Connection con) {
       this.conn = con;
   }

   public int insert(SecondBean vo) {
       int result=0;
        Date currentTime = new Date();
      SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
      String strCurrentTime = HMFromat.format(currentTime);

        String sql = "insert into SecondLevelTitle (TitleName,FilePath,Creater,CreatTime,ParentTitle) values(?,?,?,?,?)";
        try {
            st = conn.prepareStatement(sql);

            st.setString(1, vo.getTitleName());
            st.setString(2, vo.getFilePath());
            st.setString(3,vo.getCreater());
            st.setString(4,strCurrentTime);
            st.setInt(5, vo.getParentTitle());

         result= st.executeUpdate();
        } catch (SQLException ex2) {
        }
        try {
            st.close();
            conn.close();
        } catch (SQLException ex) {
        }
       return result;
    }

    public ArrayList select(int parent)
   {

       ArrayList list=new ArrayList();
       String sql = "select * from SecondLevelTitle where parentTitle=?";
        try {
            st = conn.prepareStatement(sql);
           st.setInt(1,parent);

            re= st.executeQuery();

            while(re.next()){
            SecondBean bean=new SecondBean();
            bean.setId(re.getInt("Id"));
            bean.setTitleName(re.getString("TitleName"));
            bean.setFilePath(re.getString("FilePath"));
            list.add(bean);

            }
        } catch (SQLException ex2) {
        }
        try {
            st.close();
            conn.close();
        } catch (SQLException ex) {
        }

       return list;
   }

   public SecondBean selectId(int id){
       SecondBean bean=new SecondBean();
       String sql = "select * from SecondLevelTitle where Id=?";
         try {
             st = conn.prepareStatement(sql);
            st.setInt(1,id);

             re= st.executeQuery();

             if(re.next()){

             bean.setId(re.getInt("Id"));
             bean.setTitleName(re.getString("TitleName"));
             bean.setFilePath(re.getString("FilePath"));


             }
         } catch (SQLException ex2) {
         }
         try {
             st.close();
             conn.close();
         } catch (SQLException ex) {
         }

        return bean;


   }


}