使用步骤:
1、导入依赖:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.25</version>
</dependency>
2、配置相关信息
public class TestJdbc {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//配置信息
String url="jdbc:mysql://localhost:3306/guet?useUnicode=true&characterEncoding=utf-8";
String username="root";
String password="Zt200198.";
//1、加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//2、连接数据库
DriverManager.getConnection(url,username,password);
Connection connection=DriverManager.getConnection(url,username,password);
//3、向数据库发送SQL的对象Statement
Statement statement = connection.createStatement();
//4、编写SQL
String sql="select * from t_major";
//5、执行SQL
ResultSet rs=statement.executeQuery(sql);
while(rs.next()){
System.out.println("id:"+rs.getObject("major_id"));
}
//6、关闭连接
rs.close();
statement.close();
connection.close();
}
}