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>