mysql cc_mysqlcc下载

匿名用户

1级

2014-03-04 回答

http://www.sunjava.cn/jdbc/driver/mysql-connector-java-5.0.6.zip

//连接代码

import java.io.File;

import java.io.FileInputStream;

import java.net.URI;

import java.sql.*;

import java.util.PropertyResourceBundle;

public class MySqlConnector {

/*

* 先在该class文件目录下新建一个dbCon.ini

* 如:eclipse 则 your project/bin/dbCon.ini

* 内容 如下：

* userName=你的数据库用户名

* password=你的数据库用户密码

* database=要连接的数据库名称

*/

private static final String CON_NAME = "userName";

private static final String CON_PASS = "password";

private static final String CON_DNAME = "databaseName";

private Connection connection = null;

private MySqlConnector() {

}

public static MySqlConnector getInstance() {

return new MySqlConnector();

}

private boolean dataInit() {

boolean isOK = false;

String userName = null;

String password = null;

String databaseName = null;

PropertyResourceBundle rBoundle = null;

try {

String conPath = MySqlConnector.class.getResource("/").toString() + "/dbCon.ini";

URI uri = new URI(conPath);

File file = new File(uri);

rBoundle = new PropertyResourceBundle(new FileInputStream(file));

userName = rBoundle.getString(MySqlConnector.CON_NAME);

password = rBoundle.getString(MySqlConnector.CON_PASS);

databaseName = rBoundle.getString(MySqlConnector.CON_DNAME);

String url;

url = "jdbc:mysql://localhost/" + databaseName + "?user="

+ userName + "&password=" + password;

System.out.println(url);

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection(url);

isOK = true;

} catch (Exception e) {

e.printStackTrace();

isOK = false;

}

return isOK;

}

public Connection getConnection() {

if (dataInit()) {

return connection;

} else {

return null;

}

}

public static void main(String [] args){

MySqlConnector.getInstance().getConnection();

}

}