flex dispatchEvent 实例工程

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import jdbc.JdbcUtil; import vo.User; public class UserDao { private Connection conn=null; public UserDao(){ } /* * 获得全部数据 */ public List<User> getUserList() throws SQLException{ conn=JdbcUtil.getConnection(); List<User> list=new ArrayList<User>(); User user = null; String sql="select * from t_user"; PreparedStatement pstm=conn.prepareStatement(sql); ResultSet rs=pstm.executeQuery(); while(rs.next()){ user=new User(); user.setUserName(rs.getString("user_name")); user.setPassword(rs.getString("password")); user.setCredits(rs.getInt("credits")); user.setLastVisit((Date)rs.getDate("last_visit")); user.setLastIp(rs.getString("last_ip")); user.setUserId(rs.getInt("user_id")); list.add(user); } JdbcUtil.close(rs, pstm, conn); return list; } /** * 通过页数和每页数据条数获取数据 * @return * @throws SQLException */ public List<User> getUserList(int currPage,int pageSize) throws SQLException{ /*int maxPage=this.getRecords()/pageSize; if(currPage>maxPage){ currPage=maxPage; }*/ conn=JdbcUtil.getConnection(); List<User> list=new ArrayList<User>(); User user = null; String sql="select * from t_user where user_id>=? and user_id<?"; PreparedStatement pstm=conn.prepareStatement(sql); int fromUser=currPage*pageSize+1; int toUser=currPage*pageSize+pageSize+1; pstm.setInt(1, fromUser); pstm.setInt(2, toUser); ResultSet rs=pstm.executeQuery(); while(rs.next()){ user=new User(); user.setUserName(rs.getString("user_name")); user.setPassword(rs.getString("password")); user.setCredits(rs.getInt("credits")); user.setLastVisit((Date)rs.getDate("last_visit")); user.setLastIp(rs.getString("last_ip")); user.setUserId(rs.getInt("user_id")); list.add(user); } JdbcUtil.close(rs, pstm, conn); return list; } public int getRecords() throws SQLException{ int records=0; records=this.getUserList().size(); return records; } }