jdbc连接数据库

package test;

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

public class JdbcExample {
    public static void main(String[] args) throws ClassNotFoundException,SQLException {
        //jdbc:mysql://主机名:端口号/数据库名?key1=value1&key2=value2...
        String url = "jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull&useSSL=false";
        String user = "root";            //mysql登录用户名
        String password = "123456";        //密码
        //1.加载驱动程序
        Class.forName("com.mysql.jdbc.Driver");
        //2.获取数据库连接
        Connection con = DriverManager.getConnection(url, user, password);
        //3.通过数据库连接操作数据库 使用statement类
        Statement s = con.createStatement();
        ResultSet rs = s.executeQuery("select * from baseInfo");
        //4.处理数据库返回的结果集
        while(rs.next()) {
            System.out.println(rs.getString("name"));
        }
        //5.关闭资源
        rs.close();
        s.close();
        con.close();
    }
}