Page 872 - 3-2

jframe.setVisible(false);

for(int i = 1;i<=cnt;i++)
{
flag[i]=0;
}
}
});

jframe.setBounds(100, 100, 600, 200);
jframe.setBounds(100, 100, 550, 200);
contentPane.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 5));
contentPane.add(button1);
//System.out.println("main");
ServerMain sm = new ServerMain();
}

public static void maker(){
cnt_s = cnt;
Connection conn = null;
Statement stmt = null;
try{
Class.forName(JDBC_DRIVER);
conn =
DriverManager.getConnection(DB_URL,USERNAME,PASSWORD);
stmt = conn.createStatement();

String tableSql =
"SELECT table_name FROM information_schema.tables
where table_schema = ? and table_name = ?";

pstmt = conn.prepareStatement(tableSql);

pstmt.setString(1, "and1");

pstmt.setString(2, "project");

rss = pstmt.executeQuery();

if(!rss.next())
{
String sql;

sql = "create table project(detector int, addr int(3),
room char(50), fire int, spark char(50), gas char(50),

- 872 -