eclipse mysql查_eclipse java 查询Mysql中的数据

程序如下:importjava.sql.*;publicclassExample15_1{publicstaticvoidmain(String[]args){Connectioncon;Statementsql;ResultSetrs;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver...

程序如下:

import java.sql.*;

public class Example15_1

{

public static void main(String[] args)

{

Connection con;

Statement sql;

ResultSet rs;

try

{

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

}

catch(ClassNotFoundException e)

{

System.out.println(""+e);

}

try

{

con=DriverManager.getConnection("jdbc:odbc:sun","root","860702");

sql=con.createStatement();

rs=sql.executeQuery("SELECT * FROM chengjibiao");

while(rs.next())

{

String sno=rs.getString(1);

String name=rs.getString(2);

int math=rs.getInt("math");

System.out.println(sno+name+math);

}

con.close();

}

catch(SQLException e)

{

System.out.println(e);

}

}

}

结果怎么为:

java.sql.SQLException: No data found

但是我用sql直接查询里面有成绩表:

数据库中有:

addbook

mysql

text

那个成绩表在mysql里面,该程序里面是不是还要加上什么?

rs=sql.executeQuery("SELECT * FROM chengjibiao");

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/MySQL","root","860702");

结果

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/MySQL

展开