比如我有个 java file need to check if the oracle is connected, and it will use an ojdbc6.jar as class path.
然后在linux 下运行的时候就这样。
1.创建一个run.sh
#!/bin/bash
CLASSPATH="./ojdbc6.jar:."
java -cp $CLASSPATH test $1 $2 $3
2. 把 ojdbc6.jar 放在 test.java 同一个目录
3. 把下面的拷贝成test.java
import java.sql.DriverManager; import java.io.FileNotFoundException; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.SQLException; public class test { public static void main(String[] argv) throws FileNotFoundException, UnsupportedEncodingException { System.out.println("-------- Oracle JDBC Connection Testing ------"); String ip = argv[0]; String connStr = "jdbc:oracle:thin:@"+ip+":1521:ORCL"; String user = argv[1]; String password = argv[2]; PrintWriter writer = new PrintWriter("the-file-name.txt", "UTF-8"); writer.println("The first line"); writer.println("The second line"); try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { System.out.println("Where is your Oracle JDBC Driver?"); e.printStackTrace(); writer.close(); return; } System.out.println("Oracle JDBC Driver Registered!"); Connection connection = null; try { connection = DriverManager.getConnection( connStr, user, password); } catch (SQLException e) { System.out.println("Connection Failed! Check output console"); e.printStackTrace(); writer.close(); return; } if (connection != null) { System.out.println("You made it, take control your database now!"); writer.println("True"); } else { System.out.println("Failed to make connection!"); writer.println("False"); } writer.close(); } }
4. 运行 ./run.sh ip username password