eclipse中使用maven连接mysql（二）

一、修改pom文件

查看自身的mysql版本，寻找对应的mysql-connection-java文件，在pom中插入以下代码

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.20</version>
      <scope>test</scope>
    </dependency>

完整pom代码：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.panzi.cn</groupId>
  <artifactId>Hello</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>Hello</name>
  <url>http://maven.apache.org</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.20</version>
      <scope>test</scope>
    </dependency>
  </dependencies>
</project>

二、创建main文件

在src的main文件夹下的包中创建一个HelloWorld的class文件

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

public class HelloWorld {
	public void test(){
		System.out.println("Hello world");
	}
	public void test1(){
		System.out.println("Hello world!hhhh");
	}
	public Connection getConn(){	
		Connection conn = null;	
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			try{
			conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mysql?serverTimezone=UTC", "root", "password");
			}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
		}catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	}
}

“jdbc:mysql://127.0.0.1:3306/mysql?serverTimezone=UTC”, “root”, "password"此处的3306是端口号，mysql为表名（如下图），root为用户名，password为密码

三、创建测试类

在src的test文件夹下的包中创建一个testHello的class文件

import java.sql.Connection;

import org.junit.Test;

public class testHello {
	@Test
	public void test(){
		HelloWorld hw = new HelloWorld();
		hw.test();
	}
	@Test
	public void test1(){
		HelloWorld hw = new HelloWorld();
		hw.test1();
	}
	@Test
	public void testConn(){
		HelloWorld cn = new HelloWorld();
		Connection con = cn.getConn();
		System.out.println(con);
	}
}

运行结果