【Java开源代码栏目提醒】:网学会员Java开源代码为您提供UserInfoOperation.java参考,解决您在UserInfoOperation.java学习中工作中的难题,参考学习。
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;
}
}
上一篇:
UserInfoList.java
下一篇:
村落共同体的核心架构研究