Maven的东西

1.maven的jar包下载流程

安装
解压压缩包

创建一个文件来当本地仓库
打开conf文件找到setting文件

打开修改setting文件
第一处是添加这句话,内容添加你本地仓库文件地址

第二处是添加镜像阿里云仓库

<mirror>
      <id>alimaven</id>
      <name>aliyun maven</name>
      <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
      <mirrorOf>central</mirrorOf>        
    </mirror>
  </mirrors>

创建maven工程

连接数据

public static void main(String[] args) throws ClassNotFoundException, SQLException {
    //用户名
    String user = "root";
    //密码
    String password = "123456";
    //url
    String url = "jdbc:mysql://localhost:3306/db_place?serverTimezone=GMT%2B8";
    //注册驱动
    Class.forName("com.mysql.cj.jdbc.Driver");
    //建立连接
    Connection connection = DriverManager.getConnection(url, user, password);
    //sql语句
    String sql = "select * from t_log" ;
    //预处理sql语句
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    //执行sql语句
    ResultSet resultSet = preparedStatement.executeQuery();
    //处理sql语句执行的结果
    while (resultSet.next()) {
        System.out.print(resultSet.getString("id"));
        System.out.print(resultSet.getString("ip"));
        System.out.println(resultSet.getString("userid"));
    }
    //释放资源
    connection.close();
    preparedStatement.close();
}

pom.xml添加

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