đâ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
Đại lý thiết bị tự động hóa chuyên cung cấp van đều khiển khí nén Lanny tại Việt Nam. Chủ sở hữu công ty và giám đốc điều hành Michael Lanny thành lập công ty vào năm 1991. Những chiếc van đầu...
Van điều khiển khí nén Lanny Việt Nam