JDBC简单例子

这是一个JDBC的简单例子，完整的演示了连接数据库、执行简单查询以及处理查询结果的过程。

import java.sql.*;public class SimpleJDBC {    public static void main(String[] args) throws ClassNotFoundException, SQLException {        //为MySql加载一个jdbc驱动程序        Class.forName("com.mysql.jdbc.Driver");             System.out.println("Driver loaded");        //连接数据库        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/javabook","scott","tiger");        System.out.println("Database connected");        //创建statement        Statement statement = connection.createStatement();        //执行sql语句并返回一个ResultSet对象        ResultSet resultSet = statement.executeQuery("select firstname,lastname from Student where lastname" + " ='Smith'");        //从ResultSet对象中获得查询结果        while(resultSet.next())            System.out.println(resultSet.getString(1) + "\t" + resultSet.getString(2));        //关闭连接并释放与连接有关的资源        connection.close();    }}