找不到借口..
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?{ //?加載驅動程序 Class.forName("com.mysql.jdbc.Driver"); //?獲取數據庫連接 Connection?conn?=?DriverManager.getConnection(URL,?USER,?PASSWORD); //?通過數據庫連接操縱數據庫。實現增刪查改 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
你導包導錯了Statement?stmt=conn.createStatement();? 應該是import?java.sql.Statement;
2016-09-16
找到錯誤了。 jdbc版本不對。原來是5.1換成5.0就好了