rightdao.java~16~

《struts应用开发完全手册》中的源代码及安装指导

package com.dao;

import com.actionForm.RightForm;
import java.util.*;
import java.sql.*;

public class RightDao {
    private JDBConnection connection = null;
    public RightDao() {
        connection = new JDBConnection();
    }

//==============================================================================
    public void deleteRight(String account) {
        String sql = "delete from tb_managerRight where managerAccount='" + account + "'";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }

//==============================================================================
    public void updateRight(RightForm form) {
        String sql = "update tb_managerRight set jcxx='" + form.getJcxx() +
                     "',jczl='" + form.getJczl() +
                     "',ywgl='" + form.getYwgl() + "',xxcx='" + form.getXxcx() +
                     "',fzgj='" + form.getFzgj() +
                     "',xtsz='" + form.getXtsz() + "'where managerAccount='" +
                     form.getManagerAccount() + "'";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }

//===============================================================================
    public void insertRight(String managerAccount) {
        String sql = "insert into tb_managerRight values ('" +
                     managerAccount + "','0','0','0','0','0','0')";
        connection.executeUpdate(sql);
        connection.closeConnection();
    }

//================================================================================
    public List selectRight() {
        List list = new ArrayList();
        RightForm form = null;
        String sql = "select * from tb_managerRight order by id";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new RightForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setManagerAccount(rs.getString(2));
                form.setJcxx(Integer.valueOf(rs.getString(3)));
                form.setJczl(Integer.valueOf(rs.getString(4)));
                form.setYwgl(Integer.valueOf(rs.getString(5)));
                form.setXxcx(Integer.valueOf(rs.getString(6)));
                form.setFzgj(Integer.valueOf(rs.getString(7)));
                form.setXtsz(Integer.valueOf(rs.getString(8)));
                list.add(form);
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return list;
    }

//==============================================================
    public RightForm selectAccountRight(String account) {
        RightForm form = null;
        String sql = "select * from tb_managerRight where managerAccount='" +
                     account + "'";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new RightForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setManagerAccount(rs.getString(2));
                form.setJcxx(Integer.valueOf(rs.getString(3)));
                form.setJczl(Integer.valueOf(rs.getString(4)));
                form.setYwgl(Integer.valueOf(rs.getString(5)));
                form.setXxcx(Integer.valueOf(rs.getString(6)));
                form.setFzgj(Integer.valueOf(rs.getString(7)));
                form.setXtsz(Integer.valueOf(rs.getString(8)));
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return form;
    }

}