input.java

来自「酒店管理软件的源代码」· Java 代码 · 共 37 行

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语句进行循环
	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);
  }
}