java的编译
编译JdbcConnectTest.java文件,生成 JdbcConnectTest.class文件到目录 D:\JAVA\class下
javac -d D:\JAVA\class D:\JAVA\JdbcConnectTest.java
java文件的内容
就拿一个jdbc的链接代码来举例子吧
这java代码其实还依附于驱动 ojdbc8-12.2.0.1.jar
import java.sql.*;
import java.util.List;
public class JdbcConnectTest {
public static void main(String[] args) {
connect();
}
public static void connect() {
String url = "jdbc:oracle:thin:@192.168.1.135:1521/dbc";
String username = "xxx";
String password = "xxx";
try {
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection(url, username, password);
if(conn!=null){
System.err.println("aaa");
}else{
System.err.println("bbbb");
}
Statement statement = null;
ResultSet resultSet = null;
try {
statement = conn.createStatement();
String sqlQuery = "SELECT name FROM TEST_SOURCE";
resultSet = statement.executeQuery(sqlQuery);
while (resultSet.next()) {
String name = resultSet.getString("name");
System.out.println("NAME: " + name);
}
System.out.println("finally Success=====================^-^==============");
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
System.err.println("ccc");
e.printStackTrace();
} catch (SQLException e) {
System.err.println("连接数据库或执行SQL查询时出错!");
e.printStackTrace();
}
}
}
执行java代码
如果当前这个class依赖于objdc8.jar
D:\JAVA\class\JdbcConnectTest.class
D:\JAVA\jar\ojdbc8-12.2.0.1.jar
java -classpath D:\JAVA\class;D:\JAVA\jar\ojdbc8-12.2.0.1.jar JdbcConnectTest
这个路径就是,代码的依赖路径:什么是依赖路径,其实就是生成的class文件和这个代码所需要的jar包的路径,windows的用分号隔开
D:\JAVA\class;D:\JAVA\jar\ojdbc8-12.2.0.1.jar
JdbcConnectTest是类名
JdbcConnectTest
执行结果: