userinfooperation.java

来自「《struts 应用开发完全手册》中的源代码第一到第五章。」· Java 代码 · 共 37 行

package com.operation;

import java.util.*;
import java.sql.*;
import com.domain.UserInfoForm;

public class UserInfoOperation {
    private JDBConnection connection = null;
    public UserInfoOperation() {
        connection = new JDBConnection();
        this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
    }

//查询用户信息的操作
    public List userList() {
        List list = new ArrayList();
        UserInfoForm form = null;
        String sql = "select * from tb_user order by id";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new UserInfoForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setName(rs.getString(2));
                form.setAge(Integer.valueOf(rs.getString(3)));
                form.setProfession(rs.getString(4));
                list.add(form);
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return list;
    }


}