找不到借口..
package?JDBC; import?java.sql.Connection; import?java.sql.DriverManager; import?java.sql.ResultSet; import?com.mysql.jdbc.Statement; public?class?jdbc?{ private?static?final?String?URL?="jdbc:mysql://127.0.0.1:3306/zhao"; private?static?final?String?USER?="root"; private?static?final?String?PASSWORD?=""; public?static?void?main(String[]?args)?throws?Exception?{ //?加載驅(qū)動程序 Class.forName("com.mysql.jdbc.Driver"); //?獲取數(shù)據(jù)庫連接 Connection?conn?=?DriverManager.getConnection(URL,?USER,?PASSWORD); //?通過數(shù)據(jù)庫連接操縱數(shù)據(jù)庫。實現(xiàn)增刪查改 Statement?stmt=(Statement)?conn.createStatement(); ResultSet?rs?=?stmt .executeQuery("select?user_name,age?from?imocc_goddess"); while?(rs.next())?{ System.out.println(rs.getString("user_name")?+?"," +?rs.getInt("age")); } } }
報錯說:
Exception in thread "main" java.lang.IncompatibleClassChangeError: Found class com.mysql.jdbc.Statement, but interface was expected
at JDBC.jdbc.main(jdbc.java:25)
2016-09-16
你導(dǎo)包導(dǎo)錯了Statement?stmt=conn.createStatement();? 應(yīng)該是import?java.sql.Statement;
2016-09-16
找到錯誤了。 jdbc版本不對。原來是5.1換成5.0就好了