mysql与java的链接_java 与mysql链接

importjava.sql.*;publicclasstest{static{try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");System.out.println("SuccessloadingMySQLDriver");}catch(Exceptione){System.out.pr...

import java.sql.*;

public class test{

static{

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

System.out.println("Success loading MySQL Driver");

}

catch(Exception e){

System.out.println("Error loading MySQL Driver");

e.printStackTrace();

}

}

public static void main(String[] args){

try{

Connection con1=DriverManager.getConnection("jdbc:odbc:abccs","root","");

System.out.println("Success eastablishing the connection");

Statement stmt1=con1.createStatement();

ResultSet rs1=stmt1.executeQuery("SELECT name FROM mytable");

while(rs1.next()){

System.out.println("employee name="+rs1.getString(1));

}

con1.close();

}

catch(Exception e){

e.printStackTrace();

}

}

}

以上为原程序，已经通过编译了，在执行中出错了。错误中显示no databases are selected

请各位大虾指点一下。

谢谢你的答案。可是我已经在MySQL里创建了abccs这个数据库了。不知道是怎么回事。请指点一下。

展开