backdao.java

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

package com.dao;

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

public class Backdao {
    private JDBConnection connection = null;

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

//==================================================
    public void insertBack(BackForm form) {
        String sql = "insert into tb_back values ('" + form.getLeaveId() +
                     "',getDate(),'" + form.getBackWho() + "','" +
                     form.getBackContent() + "')";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }

//=====================================================
    public void deleteBack(Integer id) {
        String sql = "delete from tb_back where id='" + id + "'";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }
//======================================================
    public List selectLeave(Integer leaveId) {
        List list = new ArrayList();
        BackForm form = null;
        String sql = "select * from tb_back where leaveId='" + leaveId +
                     "' order by id desc";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new BackForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setLeaveId(Integer.valueOf(rs.getString(2)));
                form.setBackTime(rs.getString(3));
                form.setBackWho(rs.getString(4));
                form.setBackContent(rs.getString(5));
                list.add(form);
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return list;
    }


}