đâ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
lắm lắm cách giúp chị em thu bé âm tôn giáo, trong suốt đấy các bài bác xấp thu bé xứ đặc nhằm quan hoài nhiều nhất bởi một giản, tiết kiệm chi phí, lẻ hoạt và nhiều trạng thái thực hiện tại nhà. Tuy...
Cách thu nhỏ vùng kín tại nhà: Bài tập đơn giản giúp săn chắc, se khít