為什么我的代碼未提示錯(cuò)誤卻沒(méi)有運(yùn)行結(jié)果
package com.imooc.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
? ? public class JdbcImooc {
private static final String url = "jdbc:mysql://127.0.0.1:3306/imooc";
private static final String user = "root";
private static final String password = "123";
public static void main(String[] args) {
// TODO Auto-generated method stub
//1加載驅(qū)動(dòng)程序
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
//2.獲得數(shù)據(jù)庫(kù)連接
try {
Connection conn = DriverManager.getConnection(url, user, password);
//3.通過(guò)連接操控?cái)?shù)據(jù)庫(kù)進(jìn)行增刪改查
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select user_name, age from imooc_goddess");
while (rs.next()){
System.out.println(rs.getString("name")+","+rs.getInt("age"));
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
}
為什么我的什么也不顯示
2017-07-01
首先是否添加驅(qū)動(dòng)了，如果添加了，你可以在連接數(shù)據(jù)庫(kù)的地方進(jìn)行調(diào)試，比如輸出一句話，看看是否連接成功，如果鏈接成功了不應(yīng)該沒(méi)有結(jié)果。