假如存在一张表,表结构是这样婶儿的:
id | code | name |
---|---|---|
1001 | code01 | name01 |
1002 | code02 | name02 |
使用JDBC
方式简单的查询下这张表,代码如下:
public static void main(String[] args) {
Connection connection = null;
PreparedStatement ps = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "user", "password");
String sql = "select * from test_user";
ps = connection.prepareStatement(sql);
ps.execute(sql);
ResultSet rs = ps.getResultSet();
int length = 4;
while (rs.next()) {
for (int i = 1; i < length; i++) {
System.out.print(rs.getString(i) + "\t");
if (i + 1 == length)
System.out.println();
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (!connection.isClosed()) {
connection.close();
}
if (!ps.isClosed()) {
ps.close();
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}