cmd连接不上mysql数据库_java实例（简单通讯录管理）连接mysql数据库？？？为什么cmd提示连接不上数据库...

//下面这个类部分删减还有两个类分别是contacts的持久化类和界面设计、操作事件添加类主要代码如下：packagedatabase;importjava.sql.Connection;importjava.sql.DriverManager;impor...

//下面这个类部分删减

还有两个类分别是contacts的持久化类和界面设计、操作事件添加类

主要代码如下：

package database;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

public class DBConnection {

static private DBConnection instance = null;

private Connection conn = null;

private DBConnection() {

String driverClassName = "org.gjt.mm.mysql.Driver";

String url = "jdbc:mysql://localhost:3306/contacts";

String user = "root";

String pwd = "123";

try {

Class.forName(driverClassName).newInstance();

} catch (Exception e) {

System.out.println(e.getMessage());

}

try {

conn = DriverManager.getConnection(url, user, pwd);

conn.setAutoCommit(true);

} catch (SQLException sqlex) {

sqlex.printStackTrace();

}

}

public static DBConnection getInstance() {

if (instance == null) {

instance = new DBConnection();

}

return instance;

}

private String inputToSql(Contacts c) {

String sql = "";

String temp = null;

int cnt = 0;

temp = c.getName();

if (temp != null && temp.length() > 0) {

cnt++;

if (cnt > 1) {

sql += "and name = '" + temp + "' ";

} else {

sql += "where name = '" + temp + "' ";

}

}

temp = c.getBirthday();

if (temp != null && temp.length() > 0) {

cnt++;

if (cnt > 1) {

sql += "and birthday = '" + temp + "' ";

} else {

sql += "where birthday = '" + temp + "' ";

}

}

temp = c.getEmail();

if (temp != null && temp.length() > 0) {

cnt++;

if (cnt > 1) {

sql += "and email = '" + temp + "' ";

} else {

sql += "where email = '" + temp + "' ";

}

}

temp = c.getTel();

if (temp != null && temp.length() > 0) {

cnt++;

if (cnt > 1) {

sql += "and tel = '" + temp + "' ";

} else {

sql += "where tel = '" + temp + "' ";

}

}

temp = c.getRemark();

if (temp != null && temp.length() > 0) {

cnt++;

if (cnt > 1) {

sql += "and remark = '" + temp + "' ";

} else {

sql += "where remark = '" + temp + "' ";

}

}

return sql;

}

先谢过啦

展开