为什么访问不了数据库?
我用的是mysql,mydatabase在其data子文件夹下,里面有一个表,加载了驱动包 mysql-connector-java-3.1.12-bin.jar,在Eclipse写下面程序,为什么提示我访问不到mydatabase呢?
程序如下:
package mypackage;
import java.sql.*;
public class DatabaseConnection {
public static void main(String [] args)
{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/mydatabase";
String user = "root";
String password = "harmony";
try
{
Class.forName(driver);
Connection con = DriverManager.getConnection(url,user,password);
String insert = "insert friends(id,name) values(?,?)";
PreparedStatement prestatement = con.prepareStatement(insert);
String [] names = {"Rachel","Rose","Phoebe","Monica","Chandler","Joey"};
for(int i = 0;i < 6;i++ )
{
prestatement.setInt(1,i);
prestatement.setString(2,names[i]);
prestatement.execute();
}
String query = "select * from friends";
ResultSet result = prestatement.executeQuery(query);
System.out.println("The Results is:");
while (result.next())
{
System.out.println(result.getString("name"));
}
con.close();
}catch(SQLException e)
{
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
出错信息如下:
java.sql.SQLException: Unknown database 'mydatabase'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at mypackage.DatabaseConnection.main(DatabaseConnection.java:18)
请各位帮帮小弟的忙,我刚开始学习jdbc