MYSQL已经装好了, 并建立了名为 storemanagement的database , 而且也添加 了 驱动 但是运行下面代码还是说database名出错,请问该如何解决,谢谢!
package becker;import java.sql.*;public class Database {
public static void main(String argv[]) {
Connection con = null;
try {
// here is the JDBC URL for this database
String url ="jdbc:mysql://localhost:3306/storemanagement ?"+"user=root&password=backer&useUnicode=true&characterEncoding=gbk";
// more on what the Statement and ResultSet classes do later
Statement stmt;
ResultSet rs;
// either pass this as a property, i.e.
// -Djdbc.drivers=org.gjt.mm.mysql.Driver
// or load it here as we are doing in this example
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
// TODO: handle exception
System.out.println("e");
}
// here is where the connection is made
con = DriverManager.getConnection(url);
}
catch( SQLException e ) {
e.printStackTrace( );
}
finally {
if( con != null ) {
try {
System.out.println("Collection succeeded!");
con.close( ); }
catch( Exception e ) { }
}
}
}
}
出错信息是:(确定database name 名没有错)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Incorrect database name 'storemanagement '
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at becker.Database.main(Database.java:27)
package becker;import java.sql.*;public class Database {
public static void main(String argv[]) {
Connection con = null;
try {
// here is the JDBC URL for this database
String url ="jdbc:mysql://localhost:3306/storemanagement ?"+"user=root&password=backer&useUnicode=true&characterEncoding=gbk";
// more on what the Statement and ResultSet classes do later
Statement stmt;
ResultSet rs;
// either pass this as a property, i.e.
// -Djdbc.drivers=org.gjt.mm.mysql.Driver
// or load it here as we are doing in this example
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
// TODO: handle exception
System.out.println("e");
}
// here is where the connection is made
con = DriverManager.getConnection(url);
}
catch( SQLException e ) {
e.printStackTrace( );
}
finally {
if( con != null ) {
try {
System.out.println("Collection succeeded!");
con.close( ); }
catch( Exception e ) { }
}
}
}
}
出错信息是:(确定database name 名没有错)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Incorrect database name 'storemanagement '
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at becker.Database.main(Database.java:27)
解决方案 »
- MySQL关于表间关系的问题
- 求一个用于统计每天资源下载量的表结构
- mysqldump 好还是tar (文件压缩好)
- 面试题目:怎么去除表中的重复记录?
- MySql中怎样使用自增长?
- MySQL5.6不兼容MySQL5.0的配置,我在找5.6的配置文件说明,翻了半天了,有人帮忙翻翻么?
- update后,mysql_affected_rows()返回为0时,如何区分是因为没有匹配上条件,还是因为更新字段和原先字段一样的情况
- 存储过程分为两个部分单独测试没问题,写到一起出错
- navicat premium怎么用外键和候选键做组合主键
- 输入一个数值,返回符合该数值范围的数据
- 游标问题 急 请高手指点
- 请问MySQL数据库是否支持拷贝备份?
port=3306/dbname?jdbcCompliantTruncation=false&useUnicode=true&characterEncoding=GBKwww.MySQLpub.com
MySQLpub - 专业MySQL社区,MySQL,MySQL技术,MySQL中文,MySQL论坛
1.添加的那个database的驱动从工程属性里把 那个 jar文件导入就可以了是吧,其他还有
哪里需要设置下
2mysql的数据库server 和 client 服务需要手动打开吗 ,需要类似于windows那样官方火
墙吗