dbmanager.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(" + 
			"id varchar2(10),name char(40)," + 
			"price number(6,2),author char(40)," + 
			"publisher char(40),note char(300)," + 
			"quantity int)");
*/
/*		//添加数据
		for(int i=0;i<50;i++){
			stmt.executeUpdate(
			"insert into bstore values(" + 
			"'ISBN" + (10000+i) + "'," +
			"'《Java实用案例教程》（第" + (i+1) + "卷）'," + 
			(30.00+i) + ",'bily','TUP','a java handbook',1000)");
		}
*/
/*		//修改数据
		String id = "ISBN10001";
		String sql = "update bstore set quantity =" + 30 + "where id ='" + id + "'";
		stmt.executeUpdate(sql);
*/
/*		//显示当前库存	
		ResultSet rs=stmt.executeQuery("select * from bstore");
		while(rs.next()){
			System.out.print(rs.getString(1).trim());
			System.out.print(rs.getString(2).trim());
			System.out.print("\t"+rs.getDouble(3));
			System.out.print("\t"+rs.getString(4).trim());
			System.out.print("\t"+rs.getString(5).trim());
			System.out.println("\t"+rs.getInt(7));
		}
//*/
		//删除表
		//stmt.execute("drop table bstore");
	}catch(Exception e){
		e.printStackTrace();
	}
}
}