myecilpse已經(jīng)和mysql連接成功了,為什么運(yùn)行java文件會(huì)報(bào)錯(cuò)啊
代碼如下:
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.加載驅(qū)動(dòng)程序 Class.forName("com.mysql.jdbc.Driver"); //2.獲得數(shù)據(jù)庫的連接 Connection?conn=DriverManager.getConnection(URL,?USER,?PASSWORD); //3.通過數(shù)據(jù)庫的連接操作數(shù)據(jù)庫,實(shí)現(xiàn)增刪改查 ????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
數(shù)據(jù)庫密碼錯(cuò)誤。密碼不是root
2017-02-26
你數(shù)據(jù)庫的名字和賬號(hào)密碼對(duì)不對(duì)??你之前用過mysql嗎??