createdb.java

一个书店的例子

import java.sql.*;
public class DBManager{
	public static void main(String args[]){
		String serverName = "127.0.0.1";
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url="jdbc:oracle:thin:@"+serverName+":1521:oradb";
			Connection conn=DriverManager.getConnection(url,"scott","tiger");
			Statement stmt=conn.createStatement();
/*
			//创建表
			stmt.execute("create table bstore(" + 
				"name char(40),price number(6,2)," + 
				"author char(40),publisher char(40)," + 
				"note char(300),quantity int)");

			//添加数据
			for(int i=0;i<70;i++){
				stmt.executeUpdate("insert into bstore values('《Java实用案例教程》'," + (30+i) + ",'bily','TUP','a java handbook',100)");
			}
*/
/*			ResultSet rs=stmt.executeQuery("select * from bstore");
			while(rs.next()){
				System.out.print(rs.getString(1).trim());
				System.out.print("\t"+rs.getDouble(2));
				System.out.print("\t"+rs.getString(3).trim());
				System.out.print("\t"+rs.getString(4).trim());
				System.out.print("\t"+rs.getString(5).trim());
				System.out.println("\t"+rs.getInt(6));
			}
			//*/
			
			//删除表
			stmt.execute("drop table bstore");
			
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}