talkdao.java

留言簿或论坛是网站必备的组成部分。它不仅是网站访问者发表意见的场所

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(Integer id) {
        String sql = null;
        List list = new ArrayList();
        TalkForm form = null;
        if (id == null) {
            sql = "select * from tb_leave order by id desc";
        } else {
            sql = "select * from tb_leave where id='" + id + "'";
        }
        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();
    }
}