1. 引入mysql驱动包依赖
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.30</version> </dependency>需求： 查询demo数据库中stu表所有记录并打印出来。
2. 创建main方法如下
package whf; import java.sql.*; public class JdbcDemo { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/demo"; String username = "root"; String password = "admin"; String sql = "select * from stu"; Connection connection = null; PreparedStatement preparedStatement = null; ResultSet resultSet = null; try { // 1.注册mysql驱动 Class.forName("com.mysql.jdbc.Driver"); // 2.获取数据库连接 connection = DriverManager.getConnection(url, username, password); // 3.获取语句对象 preparedStatement = connection.prepareStatement(sql); // 4.执行语句 resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { System.out.println(resultSet.getString(1)); System.out.println(resultSet.getInt(2)); System.out.println("******************************"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { // 5.释放资源 if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } if (preparedStatement != null) { try { preparedStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { e.printStackTrace(); } } } } }3. 执行结果展示
lucy 1 ****************************** tom 2 ******************************
