đây là ví dụ:
Mã nguồn PHP:
[color=#000000]
import java[/color][color=#007700].[/color][color=#0000bb]sql[/color][color=#007700].[/color][color=#0000bb]drivermanager[/color][color=#007700];[/color][color=#0000bb]import java[/color][color=#007700].[/color][color=#0000bb]sql[/color][color=#007700].[/color][color=#0000bb]connection[/color][color=#007700];[/color][color=#0000bb]import java[/color][color=#007700].[/color][color=#0000bb]sql[/color][color=#007700].[/color][color=#0000bb]sqlexception[/color][color=#007700]; public class [/color][color=#0000bb]oraclejdbc [/color][color=#007700]{ public static [/color][color=#0000bb]void main[/color][color=#007700]([/color][color=#0000bb]string[/color][color=#007700][] [/color][color=#0000bb]argv[/color][color=#007700]) { [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"-------- oracle jdbc connection testing ------"[/color][color=#007700]); try { class.[/color][color=#0000bb]forname[/color][color=#007700]([/color][color=#dd0000]"oracle.jdbc.driver.oracledriver"[/color][color=#007700]); } catch ([/color][color=#0000bb]classnotfoundexception e[/color][color=#007700]) { [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"where is your oracle jdbc driver?"[/color][color=#007700]); [/color][color=#0000bb]e[/color][color=#007700].[/color][color=#0000bb]printstacktrace[/color][color=#007700](); return; } [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"oracle jdbc driver registered!"[/color][color=#007700]); [/color][color=#0000bb]connection connection [/color][color=#007700]= [/color][color=#0000bb]null[/color][color=#007700]; try { [/color][color=#0000bb]connection [/color][color=#007700]= [/color][color=#0000bb]drivermanager[/color][color=#007700].[/color][color=#0000bb]getconnection[/color][color=#007700]( [/color][color=#dd0000]"jdbc:oracle:thin:@localhost:1521:mkyong"[/color][color=#007700], [/color][color=#dd0000]"username"[/color][color=#007700], [/color][color=#dd0000]"password"[/color][color=#007700]); } catch ([/color][color=#0000bb]sqlexception e[/color][color=#007700]) { [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"connection failed! check output console"[/color][color=#007700]); [/color][color=#0000bb]e[/color][color=#007700].[/color][color=#0000bb]printstacktrace[/color][color=#007700](); return; } if ([/color][color=#0000bb]connection [/color][color=#007700]!= [/color][color=#0000bb]null[/color][color=#007700]) { [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"you made it, take control your database now!"[/color][color=#007700]); } else { [/color][color=#0000bb]system[/color][color=#007700].[/color][color=#0000bb]out[/color][color=#007700].[/color][color=#0000bb]println[/color][color=#007700]([/color][color=#dd0000]"failed to make connection!"[/color][color=#007700]); } } }[/color]
còn đây là kết quả:
Mã nguồn PHP:
[color=#000000]
c[/color][color=#007700]:\[/color][color=#0000bb]jdbc[/color][color=#007700]-[/color][color=#0000bb]test[/color][color=#007700]>[/color][color=#0000bb]javac oraclejdbc[/color][color=#007700].[/color][color=#0000bb]java c[/color][color=#007700]:\[/color][color=#0000bb]jdbc[/color][color=#007700]-[/color][color=#0000bb]test[/color][color=#007700]>[/color][color=#0000bb]java [/color][color=#007700]-[/color][color=#0000bb]cp c[/color][color=#007700]:\[/color][color=#0000bb]jdbc[/color][color=#007700]-[/color][color=#0000bb]test[/color][color=#007700]\[/color][color=#0000bb]ojdbc6[/color][color=#007700].[/color][color=#0000bb]jar[/color][color=#007700];[/color][color=#0000bb]c[/color][color=#007700]:\[/color][color=#0000bb]jdbc[/color][color=#007700]-[/color][color=#0000bb]test oraclejdbc[/color][color=#007700]-------- [/color][color=#0000bb]oracle jdbc connection testing [/color][color=#007700]------------[/color][color=#0000bb]oracle jdbc driver registered[/color][color=#007700]![/color][color=#0000bb]you made it[/color][color=#007700], [/color][color=#0000bb]take control your database now[/color][color=#007700]! [/color][color=#0000bb]c[/color][color=#007700]:\[/color][color=#0000bb]jdbc[/color][color=#007700]-[/color][color=#0000bb]test[/color][color=#007700]>[/color]
chú ý: oraclejdbc.java đc lưu tại c:\jdbc-test
Ngọc Bích xanh thực chất thuộc dòng đá cẩm thạch (jade). Và đá hoa là tên gọi chung của ngọc bích. Vì thực chất chúng thuộc dòng đá đa khoáng được hình thành từ chất Silicat dưới dạng dioxy. Ngọc...
Chia sẻ Vòng tay ngọc bích xanh là gì? (13) Có lợi ích gì cho sức khỏe