//***************************************************
//名称:funRefresh
//功能:刷新函数,从数据库中取得数据,并且添加到表格中
//输入:
//输出:
//返回:
//***************************************************
private void funRefresh()
{
String[] data1 = new String[10];
Format fmt = new SimpleDateFormat("yyyy年MM月dd日");try
{
String strSql = "SELECT * FROM IPLOG";
ResultSet rs = db.querySQL(strSql); if (rs == null)
{
System.out.println("SQL 语句执行错误!");
return;
} clearAll(tb);
while (rs.next())
{
data1[0] = fmt.format(rs.getDate("DATES"));
data1[1] = rs.getString("IPADDRESS");
data1[2] = rs.getString("DAY_GJ_IN");
data1[3] = rs.getString("NIG_GJ_IN");
data1[4] = rs.getString("DAY_GJ_OUT");
data1[5] = rs.getString("NIG_GJ_OUT");
data1[6] = rs.getString("DAY_GN_IN");
data1[7] = rs.getString("NIG_GN_IN");
data1[8] = rs.getString("DAY_GN_OUT");
data1[9] = rs.getString("NIG_GN_OUT"); ((DefaultTableModel) tb.getModel()).addRow(data1);
} if (tb.getRowCount() > 0)
{
btnModify.setEnabled(true);
tb.setRowSelectionInterval(0, 0);
}
rs.close();
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
}
//名称:funRefresh
//功能:刷新函数,从数据库中取得数据,并且添加到表格中
//输入:
//输出:
//返回:
//***************************************************
private void funRefresh()
{
String[] data1 = new String[10];
Format fmt = new SimpleDateFormat("yyyy年MM月dd日");try
{
String strSql = "SELECT * FROM IPLOG";
ResultSet rs = db.querySQL(strSql); if (rs == null)
{
System.out.println("SQL 语句执行错误!");
return;
} clearAll(tb);
while (rs.next())
{
data1[0] = fmt.format(rs.getDate("DATES"));
data1[1] = rs.getString("IPADDRESS");
data1[2] = rs.getString("DAY_GJ_IN");
data1[3] = rs.getString("NIG_GJ_IN");
data1[4] = rs.getString("DAY_GJ_OUT");
data1[5] = rs.getString("NIG_GJ_OUT");
data1[6] = rs.getString("DAY_GN_IN");
data1[7] = rs.getString("NIG_GN_IN");
data1[8] = rs.getString("DAY_GN_OUT");
data1[9] = rs.getString("NIG_GN_OUT"); ((DefaultTableModel) tb.getModel()).addRow(data1);
} if (tb.getRowCount() > 0)
{
btnModify.setEnabled(true);
tb.setRowSelectionInterval(0, 0);
}
rs.close();
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货