?? input.java
字號:
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);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -