rightdao.java~11~

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

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 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;
}

}