使用jdbc对数据库执行查询操作&查询到结果的处理

package com.wyq.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.bjsxt.entity.Emp;

public class TestStatement {
	public static void main(String[] args) {
		// 声明jdbc参数
		String driver = "oracle.jdbc.OracleDriver";
		String url = "jdbc:oracle:thin:@localhost:1521:XE";
		String username = "scott";
		String passworld = "123456";
		// 创建jdbc变量
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		ArrayList<Emp> list = null;
		// 加载驱动
		try {
			Class.forName(driver);

			// 创建连接
			conn = DriverManager.getConnection(url, username, passworld);
			// 创建连接对象
			stmt = conn.createStatement();
			// 创建SQL命令
			String sql = "select * from emp";
			// 执行SQL命令
			rs = stmt.executeQuery(sql);