managerdao.java~7~

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

package com.dao;

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

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

//==============================================================================
    public void insertManager(ManagerForm form) {
        String sql = "insert into tb_manager values ('" + form.getAccount() +
                     "','" + form.getPassword() + "','" + form.getName() +
                     "','" + form.getAge() + "','" +
                     form.getSex() + "')";
        System.out.println("sql=" + sql);
        connection.executeUpdate(sql);
        connection.closeConnection();
    }
//==============================================================================
    public ManagerForm selectOne(String account) {
        ManagerForm form = null;
        String sql = "select * from tb_manager where account='" + account + "'";
        ResultSet rs = connection.executeQuery(sql);
        try {
            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;
    }
}