backdao.java~1~

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

package com.dao;

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

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);
        while(rs.next()){}
        
        return list;
    }


}