1、创建maven jar工程,不需要任何模板
2、导入mysql连接依赖
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency>
创建连接类JdbcDemo01
package cn.kgc.jdbc; import java.sql.*; public class JdbcDemo01 { public static void main(String[] args) throws SQLException { //注册驱动 DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//或者
//class.forName("cn.kgc.jdbc.Driver");
//获取连接,数据库连接地址和账户密码 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root"); //获取操作数据库的预处理对象 PreparedStatement preparedStatement = connection.prepareStatement("select * from user"); //执行SQL语句 ResultSet resultSet = preparedStatement.executeQuery(); //遍历结果集 while (resultSet.next()){ System.out.println(resultSet.getString("name")); } //释放资源 resultSet.close(); preparedStatement.close(); connection.close(); } }