usage.java

jsp 应用开发技术光盘 是《jsp应用开发技术》这本书的源代码

package ch13;

import java.sql.*;

public class Usage {
	public static void main(String[] args) throws Exception {
		// 1、与数据库建立连接
		Connection conn = DriverManager.getConnection(
				"jdbc:mysql://localhost/sql_test", "root", "root");
		Statement stmt = conn.createStatement();
		// 2、向数据库发送SQL语句
		ResultSet rs = stmt.executeQuery("SELECT * FROM student");
		// 3、处理结果集
		while (rs.next()) {
			String name = rs.getString("name");
			System.out.println("Name: " + name);
		}

	}
}