1. 测试Maven的时候发现引用 mysql-connector-java-5.1.10-bin.jar
有点问题 搞了好久还是没解决
索性用最简单的方法 直接新建一个文件夹lib 然后进行引用
程序结构如下:
2.pom.xml代码已经注释了
<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>mm</groupId>
<artifactId>mm</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>mm</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>5.1.10</version>
</dependency>
-->
</dependencies>
</project>
3.java部分代码
package mm.mm;
/**
* Hello world!
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Apptest {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
long start = System.currentTimeMillis();
try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root")) {
long end = System.currentTimeMillis();
System.out.println("建立连接耗时:" + (end - start) + "ms 毫秒");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}