為什么我的代碼未提示錯誤卻沒有運行結(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ū)動程序
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
//2.獲得數(shù)據(jù)庫連接
try {
Connection conn = DriverManager.getConnection(url, user, password);
//3.通過連接操控數(shù)據(jù)庫進行增刪改查
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ū)動了,如果添加了,你可以在連接數(shù)據(jù)庫的地方進行調(diào)試,比如輸出一句話,看看是否連接成功,如果鏈接成功了不應(yīng)該沒有結(jié)果。