managerdao.java

stuts+hibernate web 权限管理

package com.dao;

import com.actionForm.ManagerForm;
import java.sql.*;


public class ManagerDao {
    private String deleteManager = "delete from tb_manager where account=?";
    private String insertManager = "insert into tb_manager values (?,?,?,?,?)";
    private String selectOneManager =
            "select * from tb_manager where account=?";
    private Connection connection = null; //定义连接的对象
    private PreparedStatement ps = null; //定义预准备的对象
    private JDBConnection jdbc = null; //定义数据库连接对象
    public ManagerDao() {
        jdbc = new JDBConnection();
        connection = jdbc.connection; //利用构造方法取得数据库连接
    }

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

//==============================================================================
    public void insertManager(ManagerForm form) {
        try {
            ps = connection.prepareStatement(this.insertManager);
            ps.setString(1, form.getAccount());
            ps.setString(2, form.getPassword());
            ps.setString(3, form.getName());
            ps.setString(4, String.valueOf(form.getAge()));
            ps.setString(5, form.getSex());
            ps.executeUpdate();
            ps.close();
        } catch (SQLException ex) {
        }
    }

//==============================================================================
    public ManagerForm selectOne(String account) {
        ManagerForm form = null;
        try {
            ps = connection.prepareStatement(this.selectOneManager);
            ps.setString(1, account);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                form = new ManagerForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setAccount(rs.getString(2));
                form.setPassword(rs.getString(3));
                form.setName(rs.getString(4));
                form.setAge(Integer.valueOf(rs.getString(5)));
                form.setSex(rs.getString(6));
            }
        } catch (SQLException ex) {
        }
        return form;
    }
}