firstdao.java

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

package shen;

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


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


   public ArrayList select()
   {

       ArrayList list=new ArrayList();
       String sql = "select Id, titleName from FirstLevelTitle";
        try {
            st = conn.prepareStatement(sql);

            re= st.executeQuery();

            while(re.next()){
            FirstBean bean=new FirstBean();
            bean.setId(re.getInt(1));
            bean.setTitleName(re.getString(2));
            list.add(bean);

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

       return list;
   }

    public int insert(FirstBean 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 FirstLevelTitle(TitleName,Creater,CreatTime)values(?,?,?)";
        try {
            st = conn.prepareStatement(sql);

            st.setString(1, vo.getTitleName());
            st.setString(2,vo.getCreater());
            st.setString(3,strCurrentTime);

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