我正在一个小桌子上执行一个简单的查询
SELECT * FROM SYSTEM
系统表只有三列(Id,Name,Progress)和1300行.
我获取数据的代码是:
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = (Connection) DriverManager.getConnection(
"jdbc:mysql://192.168.0.107:3306/my_database",
username.getText(), password.getText());
String query = "select * from system";
stmt = (Statement) conn.createStatement();
rs = (ResultSet) stmt.executeQuery(query);
while (rs.next()) {
tableModel.addRow(new Object[] { rs.getInt("Number"),
rs.getString("Name"), rs.getFloat("Progress") });
}
} catch (Exception e) {
// some other code
}`
此代码在我的JTable中显示日期大约需要15秒,而如果我在phpmyadmin中执行查询则需要不到一秒钟.
解决方法:
我会使用PreparedStatment,我会增加默认的ResultSet fetchSize,我会将查询限制为三列(注意id!= Number) –
String query = "select Number, Name, Progress from system";
stmt = conn.prepareStatement(query);
rs = stmt.executeQuery();
rs.setFetchSize(250);
最后,建立这样的连接可能是获得性能的错误方法.您应该查找连接池,如BoneCP或c3p0或HikariCP.
标签:java,mysql,sql,jdbc
来源: https://codeday.me/bug/20190628/1320930.html