JAVA Á¬½ÓORACLEÊý¾Ý¿â´úÂë

import java.net.url;
import java.sql.*;
public class javaoracle {
public javaoracle() {
}
public static void main(string[] args){
try
{
try{
class.forname("oracle.jdbc.driver.oracledriver");
}
catch(java.lang.classnotfoundexception e)
{
system.err.print(e.getmessage());
}
string url="jdbc:oracle:thin:@server:1521:sdcdb";
connection conn=drivermanager.getconnection(url,"test","test");
statement stmt=conn.createstatement();
resultset rs=stmt.executequery("select score from my");
while(rs.next())
{
system.out.println(rs.getstring(1));
}
conn.close();
}
catch(sqlexception ex)
{
while(ex!=null)
{system.out.println(ex.getsqlstate());
}
}
}
}
///////////////////////
ÔÚtry{}ÖУº     Class.forName("oracle.jdbc.driver.OracleDriver");
                           //½«OracleDriverÔØÈëJVM¶ÔÏó³Ø
Å׳ö£ºClassNotFoundException
3.Á¬½ÓÊý¾Ý¿â£º   Connection con=DriverManager.getConnection("jdbc:oracle:thin:ordertemp/ordetemp@localhost:1521:GY");
Êý¾Ý¿âÀàÐͱêʶ·û£º  jdbc:odbc:thin
µÇ½Óû§Ãû£º        ordertemp
µÇ½ÃÜÂ룺          ordertemp
Êý¾Ý¿â·þÎñÆ÷IPµØÖ·£ºlocalhost  (»òÕßÓÃ127.0.0.1£¬Èç¹ûÊÇÍøÂ磬ÔòΪURL)
Êý¾ÝÐéÄâ¶Ë¿ÚºÅ£º    1521       (oracleĬÈ϶˿ںÅ)              //(sqlserverĬÈ϶˿ںÅ1433)
Êý¾Ý¿âSID£º         GY        
Å׳ö£ºSQLException
4.´´½¨Statement¶ÔÏó£¨PreparedStatementÒ²¿ÉÒÔ£©
Statement stm=con.createStatement();
PreparedStatement psm=con.prepareStatement(String sql);
5.Ö´ÐÐÏà¹ØSQL²éѯÓï¾ä¼°»ñµÃ½á¹û¡£
6.½áÊøÖ®ºó£¬±ØÐëʹÓ㺠 stm.close();