Page 906 - 3-2

}
});
}

/**
* Create the frame.
*/
public Sql() {

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 450, 300);
setVisible(true);

contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
contentPane.setLayout(new BorderLayout(0, 0));
setContentPane(contentPane);

JTextArea textArea = new JTextArea();
contentPane.add(textArea, BorderLayout.CENTER);

Connection conn = null;
Statement stmt = null;
try{
Class.forName(JDBC_DRIVER);
conn = (Connection) DriverManager.getConnection
(DB_URL,USERNAME,PASSWORD);

System.out.println("1");
stmt = (Statement) conn.createStatement();

String sql;
sql = "SELECT * FROM project where addr ="+ 301 +";";
ResultSet rs = stmt.executeQuery(sql);
//rs.close();

while(rs.next()){

String det = rs.getString("detector");
//dete = Integer.parseInt(det);
String addr = rs.getString("addr");
String room = rs.getString("room");
String fire = rs.getString("fire");
String spark = rs.getString("spark");
String gas = rs.getString("gas");

- 906 -