uservice.java

简单的用户管理

/**
 * 
 */
package com.howeisoft.ums.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.howeisoft.ums.entity.User;
import com.howeisoft.ums.util.Util;

/**
 * @author howei
 *
 */
public class Uservice {
	List<User> users = new ArrayList<User>();
    Connection con = null;
    Statement st = null;
    ResultSet rs = null;

	public List<User> searchUsers() {
		try {
			con = Util.getConnection();
			st = con.createStatement();
			String sql = "select * from user_table";
			rs = st.executeQuery(sql);
			
			while(rs.next()){
				User use = new User();
				use.setU_id(rs.getInt("u_id"));
				use.setU_name(rs.getString("u_name"));
				use.setU_pwd(rs.getString("u_pwd"));
				use.setAddress(rs.getString("address"));
				users.add(use);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			Util.close(con, st, rs);
		}
		return users;
	}

}