JDBC__02

结果集示意图如下：

/*
处理查询结果集,遍历结果集
*/
import java.util.*;
import java.sql.*;
public class JDBCTest05
{
	public static void main(String[] args){
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet res = null;
		ResourceBundle bundle = ResourceBundle.getBundle("jdbc");
		
		try{
			//1.注册驱动
			Class.forName(bundle.getString("driver"));

			//2.获取连接
			String url = bundle.getString("url");
			String user = bundle.getString("user");
			String pass = bundle.getString("pass");
			conn = DriverManager.getConnection(url,user,pass);

			//3.获取数据库操作对象
			stmt = conn.createStatement();

			//4.执行sql
			String sql = "select ename,sal from emp";

			res = stmt.executeQuery(sql);//专门执行DQL语句的方法

			//5.处理查询结果集
			
			while(res.next()){
				
				System.out.print(res.getString("ename")+" "+(res.getDouble("sal")+100));
				System.out.println();
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if(res != null){
				try{
					res.close();
				}catch(Exception e){
					e.printStackTrace();
				}
			}

			if(stmt != null){
				try{
					stmt.close();
				}catch(Exception e){
					e.printStackTrace();
				}
			}

			if(conn != null){
				try{
					conn.close();
				}catch(Exception e){
					e.printStackTrace();
				}
			}
		}
	}
}

在IDEA工具里配置JDBC的jar包