usrinfooperatebean.java

一个图片管理程序

package com.sunnitech.bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class UsrInfoOperateBean {
    private usrInfo _usrinfo = new usrInfo();

    public usrInfo getusrInfo() {
        return this._usrinfo;
    }

    public void setusrInfo(usrInfo usrinfo) {
        this._usrinfo = usrinfo;
    }

    public boolean selectUsrInfo() {
        Connection conn = null;
        PreparedStatement prst = null;
        ResultSet rs = null;

        try {
            conn = DBConnection.getDBConnection();

            String sql = "select * from usrinfo where UsrID=?";
            prst = conn.prepareStatement(sql);
            prst.setString(1, _usrinfo.getUsrID());
            rs = prst.executeQuery();

            while(rs.next()) {
                _usrinfo.setUsrID(rs.getString("UsrID"));
                _usrinfo.setUsrName(rs.getString("UsrName"));
                _usrinfo.setPwd(rs.getString("Pwd"));
                _usrinfo.setIDCard(rs.getString("IDCard"));
                _usrinfo.seteMail(rs.getString("eMail"));
            }
        } catch(Exception e) {
            System.out.println("user select error: " + e.toString());

            return false;
        } finally {
            try {
                rs.close();
                prst.close();
                conn.close();
            } catch(Exception e) {
                System.out.println("user select error0: " + e.toString());
            }
        }

        return true;
    }

    public boolean updateUsrInfo() {
        Connection conn = null;
        PreparedStatement prst = null;

        try {
            conn = DBConnection.getDBConnection();

            String sql = "update usrinfo set UsrName=?, Pwd=?, IDCard=?, eMail=? where UsrID=?";
            prst = conn.prepareStatement(sql);
            prst.setString(1, _usrinfo.getUsrName());
            prst.setString(2, _usrinfo.getPwd());
            prst.setString(3, _usrinfo.getIDCard());
            prst.setString(4, _usrinfo.geteMail());
            prst.setString(5, _usrinfo.getUsrID());
            prst.executeUpdate();
        } catch(Exception e) {
            System.out.println("user update error: " + e.toString());

            return false;
        } finally {
            try {
                prst.close();
                conn.close();
            } catch(Exception e) {
                System.out.println("user update error0: " + e.toString());
            }
        }

        return true;
    }

    public boolean insertUsrInfo() {
        Connection conn = null;
        PreparedStatement prst = null;

        try {
            conn = DBConnection.getDBConnection();

            String sql = "insert into usrinfo values(?,?,?,?,?)";
            prst = conn.prepareStatement(sql);
            prst.setString(1, _usrinfo.getUsrID());
            prst.setString(2, _usrinfo.getUsrName());
            prst.setString(3, _usrinfo.getPwd());
            prst.setString(4, _usrinfo.getIDCard());
            prst.setString(5, _usrinfo.geteMail());
            prst.executeUpdate();
        } catch(Exception e) {
            System.out.println("user insert error: " + e.toString());

            return false;
        } finally {
            try {
                prst.close();
                conn.close();
            } catch(Exception e) {
                System.out.println("user insert error: " + e.toString());
            }
        }

        return true;
    }

    public boolean deleteUsrInfo() {
        Connection conn = null;

        try {
            conn = DBConnection.getDBConnection();

            String sql = "delete from usrinfo where UsrID=?";
            PreparedStatement prst = conn.prepareStatement(sql);
            prst.setString(1, _usrinfo.getUsrID());
            prst.executeUpdate();
        } catch(Exception e) {
            System.out.println("user delete error: " + e.toString());

            return false;
        } finally {
            try {
                conn.close();
            } catch(Exception e) {
                System.out.println("user delete error: " + e.toString());
            }
        }

        return true;
    }

    public boolean TakeBackPwd() {
        // 添加向指定用户的邮件地址发送邮件的代码;邮件内容为该用户的用户ID和密码.
        // 发送代码操作完成
        return true;
    }
}