相关代码
import java.sql.*;
public class JDBCexecuteQuery {
public static void main(String[] args) {
ResultSet resultSet = null;
Statement statement = null;
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/db3_2";
String user = "root";
String pw = "root";
conn = DriverManager.getConnection(url, user, pw);
statement = conn.createStatement();
String sql = "select * from dept;";
resultSet = statement.executeQuery(sql);
String id, dname, loc;
while (resultSet.next()) {
id = resultSet.getString("id");
dname = resultSet.getString("dname");
loc = resultSet.getString("loc");
System.out.println("id:" + id + ",\tdname:" + dname + ",\tloc:" + loc);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (resultSet != null) {
resultSet.close();
statement.close();
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
运行结果