这是一个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();
}
}