Java訪問Oracle數(shù)據(jù)庫代碼

功能：將數(shù)據(jù)庫中的數(shù)據(jù)讀到j(luò)ava類cube中，并計算出正方體的體積。

1.使用PL/SQL Developor設(shè)計一個表格，名為first；
Table -> new Table,設(shè)計表空間，與字段的大小，以及主鍵；
Table -> first -> edit data，填入所需要的數(shù)據(jù)，則一個表格就生成了。

-
 
2.使用java代碼訪問Oracle數(shù)據(jù)庫，代碼如下：
import java.sql.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class Test {
static Vector<Cube> CubeObjects = new Vector<Cube>();
public static void main(String[] args) throws ClassNotFoundException, SQLException{
String driver = "Oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:Oracle:thin:@a9ae3e7c1051465:1521:idpdb";//idpdb為數(shù)據(jù)庫名稱
Connection conn = null;
ResultSet rsResult=null;
Statement stmt=null;
Class.forName(driver);
//第二個參數(shù)為數(shù)據(jù)庫用戶名，第三個參數(shù)為數(shù)據(jù)庫密碼
conn = DriverManager.getConnection(strUrl,"idp_pub_m","idpapp");
stmt=conn.createStatement();
rsResult=stmt.executeQuery("select * from first");
while(rsResult.next()){
Cube cub = new Cube(rsResult.getInt(1),rsResult.getInt(2),                                                                         rsResult.getInt(3),rsResult.getInt(4));
CubeObjects.add(cub);
}
int i = 0;
for(Cube cube:CubeObjects){
System.out.println("矩形次序"  + ++i + " : "+ calculate(cube));
}
}
static int calculate(Cube cube){
try{
if(cube.Height == cube.Length && cube.Length==cube.Width){
return cube.Height*cube.Length*cube.Width;
}else{
throw new Exception("不是正方體");
}
}catch(Exception e){
System.out.println(e.getMessage());
}
return 0;
   }
}

class Cube{
int ID = 0;
int Length = 0;
int Width = 0;
int Height = 0;
public Cube(int ID,int Length, int Width, int Height){
this.ID = ID;
this.Length = Length;
this.Width = Width;
this.Height = Height;
}
}

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]