ResultSet 结果集

package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * ResultSet 接口 结果集
 * @author Administrator
 *
 */
public class ResultTest {

	public static void main(String[] args) {
		//获取数据库连接对象
		Connection conn=null;
		Statement stmt=null;

		ResultSet rs = null;

		//String sql="SELECT * FROM score";
		//String sql="SELECT sno,sname,score FROM score";
		String sno="200608001";
		String sql="SELECT sno,sname,score FROM score WHERE sno="+sno;
		try {

			conn = JDBCUtil.getConnection();
			stmt=conn.createStatement();
			//查询出来的结果都在此结果集中
			rs=stmt.executeQuery(sql);
			//rs.next()将指针从当前位置下移一行。
			while(rs.next()){
				//根据数据库字段名读取相应值
				System.out.println("学号:"+rs.getString("sno"));
				System.out.println("姓名:"+rs.getString("sname"));
				System.out.println("分数:"+rs.getDouble("score"));

				//根据数据库字段id读取相应值
				System.out.println("学号:"+rs.getString(1));
				System.out.println("姓名:"+rs.getString(2));
				System.out.println("分数:"+rs.getDouble(3));
				System.out.println("------------------------------");

			}

		} catch (SQLException e) {
			e.printStackTrace();
		}

		JDBCUtil.close(rs, stmt, conn);


	}

}