rctable.java

一个典型的数据库例子（酒店房间出租系统）

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

public class rctable{
	
	public static void main(String args[]){	
		String url="jdbc:odbc:Registry";
		Connection con;
		String createStr1;
		createStr1="Create table rooms (ROOM_ID VARCHAR(10), ROOM_TYPE VARCHAR(40), ROOM_STATUS VARCHAR(40), ROOM_PRICE VARCHAR(10),RESERVE_TIME VARCHAR(20), DURATION VARCHAR(10),RETURN_TIME VARCHAR(20), CUSTOMER_NAME VARCHAR(40), CUSTOMER_SSN VARCHAR(20))";
		Statement stmt;
		
		try {
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  		} catch(java.lang.ClassNotFoundException e) {
			System.err.print("ClassNotFoundException: ");
   			System.err.println(e.getMessage());
   		}
   		
   		
   		try {
    		con=DriverManager.getConnection(url);

   			stmt=con.createStatement();
   			stmt.executeUpdate(createStr1);
   			stmt.close();
   			con.close();
   		} catch(SQLException ex) {
	   		System.err.println("SQLException: "+ex.getMessage());
	   	}
	   	
	   	try {
		   	con=DriverManager.getConnection(url);
		   	stmt=con.createStatement();
		   	
		   	stmt.executeUpdate("insert into rooms values('101','single','empty','100',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values('102','single','empty','100',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values('103','single','empty','100',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values('104','single','empty','100',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values('105','single','empty','100',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values ('201','double','empty','150',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('202','double','empty','150',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('203','double','empty','150',null,null,null,null,null)");
  			stmt.executeUpdate("insert into rooms values ('204','double','empty','150',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('205','double','empty','150',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('301','luxury','empty','250',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('302','luxury','empty','250',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('303','luxury','empty','250',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('304','luxury','empty','250',null,null,null,null,null)"); 
  			stmt.executeUpdate("insert into rooms values ('305','luxury','empty','250',null,null,null,null,null)"); 
  			
  			stmt.close();
  			con.close();
  			
  			}catch(SQLException ex) {
	  			System.err.println("SQLException: "+ex.getMessage());
  			}
	}
}