myecilpse已經和mysql連接成功了,為什么運行java文件會報錯啊
代碼如下:
package?com.imooc.db; import?java.sql.Connection; import?java.sql.DriverManager; import?java.sql.ResultSet; import?java.sql.SQLException; import?java.sql.Statement; public?class?DBUtil?{ private?static?final?String?URL="jdbc:mysql://127.0.0.1:3306/imooc"; private?static?final?String?USER="root"; private?static?final?String?PASSWORD="root"; public?static?void?main(String[]?args)?throws?Exception{ try{ //1.加載驅動程序 Class.forName("com.mysql.jdbc.Driver"); //2.獲得數據庫的連接 Connection?conn=DriverManager.getConnection(URL,?USER,?PASSWORD); //3.通過數據庫的連接操作數據庫,實現增刪改查 ????Statement?stmt=conn.createStatement(); ????ResultSet?rs=stmt.executeQuery("select?user_name,age?from?imooc_goddness"); ???? ????while(rs.next()){ ???? System.out.println(rs.getString("user_name")+","+rs.getInt("age")); ????} } catch(ClassNotFoundException?e){ e.printStackTrace(); }catch(SQLException?e){ e.printStackTrace(); } } }
2017-02-25
數據庫密碼錯誤。密碼不是root
2017-02-26
你數據庫的名字和賬號密碼對不對??你之前用過mysql嗎??