rs.next();
int iCount = rs.getInt("count");
data = new Object[iCount][];
int i = 0;
rs = stmt.executeQuery("SELECT * from AUTHORS");
while (rs.next()) {
data[i] = new Object[iCount];
data[i][0] = rs.getString("id");
data[i][1] = rs.getString("gender");
data[i][2] = rs.getString("isMember");
i++;
}
table = new JTable();
DefaultTableModel dt = new DefaultTableModel(data, colHeads); //
table.setModel(dt);
jsp = new JScrollPane(table);
getContentPane().add(jsp, BorderLayout.CENTER);
TableColumn tc = table.getColumn("性别");
TableColumn tc2=table.getColumn("是否");
tc.setCellEditor(new DefaultCellEditor(jcb));
tc2.setCellEditor(new DefaultCellEditor(jchb));
} catch (Exception e) {
e.printStackTrace();
} finally {
if (con != null) {
try {
rs.close();
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
this.setSize(300, 300);
this.setLocation(200, 210);
JPanel jp2 = new JPanel();
this.getContentPane().add(jp2, BorderLayout.NORTH);
JPanel jp = new JPanel();
jp2.add(jp);
jp.add(new JTextField(10));
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
5.数值范围查询
[java]
//import java.sql.*;
Connection con;
Statement stmt;
ResultSet rs;
int min = Integer.parseInt(jcb1.getSelectedItem().toString());
int max = Integer.parseInt(jcb2.getSelectedItem().toString());
String sql = "select count(*) as pro_count from ProPrice where price between "
+ min + " and " + max;
try {
con = DriverManager.getConnection(url);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
rs.next();
int iCount = rs.getInt("pro_count");
Object[][] data = new Object[iCount][];
rs = stmt.executeQuery("select * from ProPrice where price between "
+ min + " and " + max);
int i = 0;
while (rs.next()) {
data[i] = new Object[3];
data[i][0] = rs.getString("id");
data[i][1] = rs.getString("name");
data[i][2] = rs.getString("price");
i++;
}
DefaultTableModel dt = new DefaultTableModel(data, colHeads);
table.setModel(dt);
} catch (Exception e1) {
e1.printStackTrace();
} finally {
try {
rs.close();
con.close();
stmt.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
//import java.sql.*;
Connection con;
Statement stmt;
ResultSet rs;
int min = Integer.parseInt(jcb1.getSelectedItem().toString());
int max = Integer.parseInt(jcb2.getSelectedItem().toString());
String sql = "select count(*) as pro_count from ProPrice where price between "
+ min + " and " + max;
try {
con = DriverManager.getConnection(url);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
rs.next();
int iCount = rs.getInt("pro_count");
Object[][] data = new Object[iCount][];
rs = stmt.executeQuery("select * from ProPrice where price between "
+ min + " and " + max);
int i = 0;
while (rs.next()) {
data[i] = new Object[3];
data[i][0] = rs.getString("id");
data[i][1] = rs.getString("name");
data[i][2] = rs.getString("price");
i++;
}
DefaultTableModel dt = new DefaultTableModel(data, colHeads);
table.setModel(dt);
} catch (Exception e1) {
e1.printStackTrace();
} finally {
try {
rs.close();
con.close();
stmt.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
6.关闭时关闭连接
[java]
//import java.sql.*;
addWindowListener(new WindowAdapter{
public void windowClosing(WindowEvent wevent){
if(stmt!=null){
try {
stmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
//impor