usebasicresultset.java

来自「jsp 应用开发技术光盘 是《jsp应用开发技术》这本书的源代码」· Java 代码 · 共 59 行

package ch13;

import java.sql.*;

public class UseBasicResultSet {
	public static void main(String[] args) {
		String url = "jdbc:mysql://localhost/sql_test";
		String userName = "root";
		String password = "root";
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch(ClassNotFoundException e) {
			System.out.println("加载驱动器类时出现异常");
		}
		
		try {
			conn = DriverManager.getConnection(url, userName, password);
			
			//创建返回基本结果集的语句对象
			Statement stmt = conn.createStatement();
			//pstmt = conn.prepareStatement("SELECT * FROM student");
			
			//执行SQL查询语句得到基本结果集
			ResultSet rs = stmt.executeQuery("SELECT * FROM student");
			
			//使用next()方法将游标向前移动一行
			while (rs.next()) {	
				
				//使用getXXX(int columnIndex)方法取得列值
				String id      = rs.getString(1);
				String name    = rs.getString(2);
				
				//使用getXXX(String columnName)方法取得列值
				String address = rs.getString("address");
				Date birthday = rs.getDate("birthdate");
				
				System.out.println(id + "   " + name + "   " + 
						address + "   " + birthday);
			}
			
			rs.close();
			stmt.close();
			
		} catch(SQLException e) {
			System.out.println("出现SQLException异常");
		} finally {
			//关闭语句和数据库连接
			try {
				if (conn != null) conn.close();
			} catch(SQLException e) {
				System.out.println("关闭数据库连接时出现异常");
			}		
		}
		
	}
}