使用JDBC的方法连接不上MySQL,想自己做个练习,然后就出现了一下的错误,希望各位哥哥姐姐帮忙看下!谢谢
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try
{
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8", "root", "user_xin");
}
catch (Exception e) {
e.printStackTrace();
if (resultSet != null) {
try {
resultSet.close();
}
catch (SQLException e1) {
e1.printStackTrace();
}
}
if (preparedStatement != null) {
try {
preparedStatement.close();
}
catch (SQLException e1) {
e1.printStackTrace();
}
}
if (connection != null)
try {
connection.close();
}
catch (SQLException e1) {
e1.printStackTrace();
}
}
finally
{
if (resultSet != null) {
try {
resultSet.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
if (preparedStatement != null) {
try {
preparedStatement.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null)
try {
connection.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
报错如下
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'mybatis'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at cn.itcast.mybatis.Test.main(Test.java:17)
Unknown database 'mybatis' 数据库名字错了
Unknown database 'mybatis',没有这个数据库
下面和大家分享一下简单的连接本地数据库的代码:
这是连接DBUtil的代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class D......
答案就在这里:JDBC 连接 mysql数据库
----------------------Hi,地球人,我是问答机器人小S,上面的内容就是我狂拽酷炫叼炸天的答案,除了赞同,你还有别的选择吗?
看你的数据库,错误是不认识mybatis这个库,估计你没有
查看下你的MySQL数据库 localhost用户下有没有mybatis数据库 拼音别打错
你导入jar包了吗?或者说你有没有创建那个名称的数据库?都核对一下,估计问题就能解决了。希望能帮到你!
参考下看看我写的http://blog.csdn.net/evankaka/article/details/45370609
没有mybatis这个名字的数据库,有可能是你拼错了,或者干脆就是没创建。
mybatis数据库未被创建或者你名字写错了
没有叫mybatis的数据库
检查一下你链接数据库的信息,有错误!!!!