maven依赖坐标网站
https://mvnrepository.com/
参考https://www.cnblogs.com/dzblog/p/6913809.html
1.新建maven项目,不选择骨架
4.0.0
com.east
databaseTest
1.0-SNAPSHOT
mysql
mysql-connector-java
6.0.2
mysql
mysql-connector-java
5.1.34
com.oracle
ojdbc6
11.2.0.1.0
com.oracle
ojdbc14
10.2.0.3.0
com.oracle
ojdbc14
10.2.0.4.0
org.apache.maven.plugins
maven-jar-plugin
./resources/
${project.build.directory}
org.springframework.boot
spring-boot-maven-plugin
ZIP
true
${project.build.directory}
repackage
org.apache.maven.plugins
maven-assembly-plugin
src/main/assembly/package.xml
make-assembly
package
single
4.package.xml
package
zip
true
${project.basedir}/src/main/resources
/resources
${project.build.directory}
/
*.jar
5.DataConnection.java
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DataConnection {
private Properties p;
private Connection conn;
private FileInputStream f;
public static void main(String[] args) {
new DataConnection().loadDriver();
}
public void loadDriver() {
p = new Properties();
try {
// f = new FileInputStream(new File("D:\\jdbc.properties"));
// p.load(f);
p.load(this.getClass().getResourceAsStream("/jdbc.properties"));
System.out.println("数据库正在连接,请等待...");
Class.forName(p.getProperty("Driver").trim());
System.out.println("驱动加载成功!!!");
try {
conn = DriverManager.getConnection(p.getProperty("url").trim(), p.getProperty("user").trim(), p.getProperty("password").trim());
System.out.println("数据库连接成功!!!");
} catch (SQLException e) {
System.out.println("不能连接到指定的数据库,请检查相应的基本信息!!!");
e.printStackTrace();
}
} catch (FileNotFoundException e) {
System.out.println("指定路径的文件不存在或者无权限访问!!!");
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
System.out.println("无法找到所加载的驱动,或驱动文件不存在!!!");
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
6.Maven Projects -> package