import java.sql.*;
import java.io.*;
import java.util.*;


public class Input
{
public static void main(String [] args)
{
try{
      Connection conn = getConnection("酒店管理");
      Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                        ResultSet.CONCUR_UPDATABLE);

//在此輸入SQL語句進行循環(huán)
	for(int i = 400;i<422;i++)
           stat.execute("insert into 酒店房 values ('"+i+"', '空閑', '豪華雙人')");



stat.close();
stat.close();
}catch(SQLException e){e.printStackTrace();}
catch(IOException e){e.printStackTrace();}
}
public static Connection getConnection(String DBName)
     throws SQLException, IOException
  {
     Properties props = new Properties();
     props.setProperty("password", "");
     props.setProperty("user", "");
     props.setProperty("url", "jdbc:odbc:" + DBName);
     System.setProperty("jdbc.drivers", "sun.jdbc.odbc.JdbcOdbcDriver");
     return
         DriverManager.getConnection(props.getProperty("url"), props);
  }
}