package com.cqqn.jdbc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.cqqn.jdbc.bean.UserBean;

public class SelectTest {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		//加载驱动
		Class.forName("com.mysql.jdbc.Driver");
		//获取链接
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fiid","root","123456");
		//sql语句
		String sql = "select * from user";
		//预编译sql
		PreparedStatement pstmt = conn.prepareStatement(sql);
		//提交sql
		ResultSet rs = pstmt.executeQuery();
		//循环遍历这个结果集
		//.next往下移动下标 下一行有数据返回true
		
		//创建Bean对象的集合
		List<UserBean> list = new ArrayList<UserBean>();
		while (rs.next()) {
			//当前下标在哪一行就获取的哪一行的数据
			UserBean ub = new UserBean();
			ub.setUserId(rs.getInt("user_id"));
			ub.setUserName(rs.getString("user_name"));
			ub.setUserUsername(rs.getString("user_username"));
			ub.setUserCreatetime(rs.getDate("user_createtime"));
			list.add(ub);
		}
		//关闭链接
		conn.close();
		//关闭sql缓存对象
		pstmt.close();
		//关闭结果缓存
		rs.close();
		
		for (int i = 0; i < list.size(); i++) {
			System.out.println(list.get(i).getUserName());
		}
		
		
	}

}

这是代码