入门连接JDBC

JDBC连接步骤

加载驱动
获取数据库连接
通过连接，获取Satement，用来执行SQL
关闭连接

放在<dependencies>中间

    <dependencies>
        
    </dependencies>

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.15</version>
</dependency>

package com.xsz.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDemo {
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        try {
        	//加载数据库驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            //通过驱动管理类获取数据库链接
            //java12是数据库的名字，localhost是IP地址
            String url="jdbc:mysql://localhost:3306/java12?useSSL=false&serverTimezone=UTC";
            //登录数据库用户名
            String username="root";
            //登录数据库密码
            String pwd="********";
            //建立连接
            Connection conn = DriverManager.getConnection(url,username,pwd);
            //通过Statement处理SQL语句
            Statement st=conn.createStatement();
            ResultSet rs=st.executeQuery("select name,id,score,subject from student");
            while(rs.next()){
                System.out.println("名字"+rs.getString("name"));
                System.out.println("分数"+rs.getString("score"));
            }
            rs.close();
            st.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}