测试mysql数据库连接:
package cn.yws.fuck;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Fuck {
public static void main(String[] args) {
if(args.length!=2)
{
args=new String[]{"root","root"};
System.out.println("user==null password=null");
}
// 驱动程序名
String driver = "com.mysql.jdbc.Driver";
// URL指向要访问的数据库名scutcs
String url = "jdbc:mysql://127.0.0.1:3306/mysql";
// MySQL配置时的用户名
String user = args[0];
// MySQL配置时的密码
String password = args[1];
try {
// 加载驱动程序
Class.forName(driver);
// 连续数据库f
Connection conn = DriverManager.getConnection(url, user, password);
if (!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statement用来执行SQL语句
Statement statement = conn.createStatement();
// 要执行的SQL语句
String sql = "select * from user";
// 结果集
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1)+","+rs.getString(2)+
rs.getString(3)+","+rs.getString(4)+","+rs.getString(5));
}
rs.close();
conn.close();
System.out.println("ok");
} catch (Exception e) {
e.printStackTrace();
}
}
}
生成Jar包META-INF配置
Manifest-Version: 1.0
Main-Class: cn.yws.fuck.Fuck
Class-Path: lib/mysql-connector-java-5.1.6-bin.jar
/**
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.hadoop.util;
import java.util.Map.Entry;
import java.util.jar.*;
/**
* A micro-application that prints the main class name out of a jar file.
*/
public class PrintJarMainClass {
/**
* @param args
*/
public static void main(String[] args) {
try {
JarFile jar_file = new JarFile(args[0]);
if (jar_file != null) {
Manifest manifest = jar_file.getManifest();
if (manifest != null) {
String value = manifest.getMainAttributes().getValue("Main-Class");
if (value != null) {
System.out.println("Main-Class:"+value.replaceAll("/", "."));
//return;
}
}
for (Entry<Object, Object> data : manifest.getMainAttributes().entrySet()) {
System.out.println(data.getKey()+":"+data.getValue());
}
}
} catch (Throwable e) {
// ignore it
e.printStackTrace();
}
System.out.println("UNKNOWN");
System.exit(1);
}
}