talkdao.java~9~

来自「《struts应用开发完全手册》中的源代码及安装指导」· JAVA~9~ 代码 · 共 53 行

package com.dao;

import com.tool.JDBConnection;
import java.util.*;
import com.actionForm.TalkForm;
import java.sql.ResultSet;
import java.sql.*;

public class Talkdao {
    private JDBConnection connection = null;

    public Talkdao() {
        connection = new JDBConnection();
    }

//====================================================================
    public List selectTalk() {
        List list = new ArrayList();
        TalkForm form = null;
        String sql = "select * from tb_leave order by id desc";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new TalkForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setTopic(rs.getString(2));
                form.setLeaveTime(rs.getString(3));
                form.setContent(rs.getString(4));
                form.setWho(rs.getString(5));
                list.add(form);
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return list;
    }
//=========================================================================
    public void deleteTalk(Integer id) {
        String sql = "delete from tb_leave where id='" + id + "'";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }

//========================================================================
    public void insertTalk(TalkForm form) {
        String sql = "insert into tb_leave values ('" + form.getTopic() +
                     "',getDate(),'" + form.getContent() + "','" + form.getWho() +
                     "')";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }
}