java

public static void main(String[] args) {
		Connection connection = DBConnection.getConn();
		Statement statement = null;
		ResultSet  resultSet = null;
		try {
			 statement  =  connection.createStatement();
			 String sql = "select name,age,sex from person";
			 resultSet = statement.executeQuery(sql);
			 while(resultSet.next()){
				//getXXX(int columnIndex)方法
				 System.out.println("name:"+resultSet.getString(1));
				//getXXX(int columnName)方法								           				System.out.println("age:"+resultSet.getInt("age"));
				System.out.println("sex:"+resultSet.getString("sex"));
			 	}
			} catch (SQLException e) {
				e.printStackTrace();
		}finally{
			DBConnection.close(connection, statement, resultSet);
			}
		}