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);
		
		
	}

}