rightdao.java

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

package com.dao;

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

public class RightDao {
    private String deleteRight =
            "delete from tb_managerRight where managerAccount=?";
    private String updateRight = "update tb_managerRight set jcxx=?,jczl=?,ywgl=?,xxcx=?,fzgj=?,xtsz=? where managerAccount=?";
    private String insertRight =
            "insert into tb_managerRight values (?,'0','0','0','0','0','0')";
    private String selectRight = "select * from tb_managerRight order by id";
    private String selectAccountRight =
            "select * from tb_managerRight where managerAccount=?";
    private Connection connection = null; //定义连接的对象
    private PreparedStatement ps = null; //定义预准备的对象
    private JDBConnection jdbc = null; //定义数据库连接对象
    public RightDao() {
        jdbc = new JDBConnection();
        connection = jdbc.connection; //利用构造方法取得数据库连接
    }


//==============================================================================
    public void deleteRight(String managerAccount) {
        try {
            ps = connection.prepareStatement(this.deleteRight);
            ps.setString(1, managerAccount);
            ps.executeUpdate();
            ps.close();
        } catch (SQLException ex) {
        }
    }

//==============================================================================
    public void updateRight(RightForm form) {
        try {
            ps = connection.prepareStatement(this.updateRight);
            ps.setString(1, String.valueOf(form.getJcxx()));
            ps.setString(2, String.valueOf(form.getJczl()));
            ps.setString(3, String.valueOf(form.getYwgl()));
            ps.setString(4, String.valueOf(form.getXxcx()));
            ps.setString(5, String.valueOf(form.getFzgj()));
            ps.setString(6, String.valueOf(form.getXtsz()));
            ps.setString(7, String.valueOf(form.getManagerAccount()));
            ps.executeUpdate();
            ps.close();
        } catch (SQLException ex) {
        }
    }

//===============================================================================
    public void insertRight(String managerAccount) {
        try {
            ps = connection.prepareStatement(this.insertRight);
            ps.setString(1, managerAccount);
            ps.executeUpdate();
            ps.close();
        } catch (SQLException ex) {
        }

    }

//================================================================================
    public List selectRight() {
        List list = new ArrayList();
        RightForm form = null;
        try {
            ps = connection.prepareStatement(this.selectRight);
            ResultSet rs = ps.executeQuery();
            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) {
        }
        return list;
    }

//==============================================================
    public RightForm selectAccountRight(String account) {
        RightForm form = null;
        try {
            ps = connection.prepareStatement(this.selectAccountRight);
            ps.setString(1,account);
            ResultSet rs = ps.executeQuery();
            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) {
        }
        return form;
    }

}