1、执行class时指定加载的jar包;
java -cp .;lib;mysql-connector-java-5.1.10-bin.jar testMysql
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class testMysql{
public static void main(String[] args) {
if(args.length<2)
{
args=new String[]{"root","root"};
}
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/mysql";
//String user = "root";
//String password = "root";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, args[0], args[1]);
if (!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
else{
System.out.println("连接失败1");
}
Statement statement = conn.createStatement();
String sql = "select * from user";
ResultSet rs = statement.executeQuery(sql);
System.out.println("-----------------");
while (rs.next()) {
System.out.println(rs.getString(1) + "\t"+rs.getString(2)+"\t"+rs.getString(3));
}
statement.close();
rs.close();
conn.close();
}catch (Exception e) {
e.printStackTrace();
}
}
}
2、java 执行jar包:
java -cp tree.jar;crimson-1.1.3.jar cn.yws.MyTree
3、Java运行程序
java -Djava.ext.dirs=lib loganalyzer.core.AnalyseLogTaskLauncher -log log4j.xml -task task.yaml
4、执行Java程序加载指定目录中的Jar文件
java -cp lib/LogAnalyzerFramework-1.0-SNAPSHOT.jar;lib/log4j-1.2.16.jar;lib/jyaml-1.3.jar;lib/commons-lang-2.6.jar;lib/commons-collections-3.2.1.jar;lib/commons-cli-1.2.jar;lib/mail-1.4.7.jar;lib/commons-io-2.4.jar loganalyzer.core.AnalyseLogTaskLauncher -log log4j.xml -task task.yaml