java连接jdbc读取oracle数据库的内容

[代码][Java]代码

01	7.下面代码可以查询数据库种的内容：

02	packageoracle.ResultSetDemo01.org;

03

04	importjava.sql.Connection;

05	importjava.sql.DriverManager;

06	importjava.sql.ResultSet;

07	importjava.sql.Statement;

08

09	publicclassConnectJdbc {

10	//驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中

11	publicstaticfinalString drive ="oracle.jdbc.driver.OracleDriver";

12

/**

13	* 连接地址，各个厂商提供单独记住

14	* jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。

15

*/

16	publicstaticfinalString url ="jdbc:oracle:thin:@192.168.1.15:1521:ORCL";

17

/**

18

* 用户 密码

19

*/

20	publicstaticfinalString DBUSER="gyly";

21	publicstaticfinalString password="gyly";

22

23

24	publicstaticvoidmain(String[] args)throwsException{

25	// TODO Auto-generated method stub

26	Connection conn =null;//表示数据库连接

27	Statement stmt=null;//表示数据库的更新

28	ResultSet result =null;//查询数据库

29	Class.forName(drive);//使用class类来加载程序

30	conn =DriverManager.getConnection(url,DBUSER,password);//连接数据库

31	//Statement接口要通过connection接口来进行实例化操作

32	stmt = conn.createStatement();

33	//执行SQL语句来查询数据库

34	result =stmt.executeQuery("SELECT DEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");

35	while(result.next()){//判断有没有下一行

36	intDEPTID =result.getInt(1);

37	String DEPTNAME = result.getString(2);

38	String ADDR = result.getString(3);

39	longTEL = result.getLong(4);

40	longFAX = result.getLong(5);

41	String LXR =result.getString(6);

42	intPX =result.getInt(7);

43	intUNITID = result.getInt(8);

44	System.out.print("DEPTID="+DEPTID+";");

45	System.out.print("DEPTNAME="+DEPTNAME+";");

46	System.out.print("ADDR="+ADDR+";");

47	System.out.print("TEL="+TEL+";");

48	System.out.print("FAX="+FAX+";");

49	System.out.print("LXR="+LXR+";");

50	System.out.print("PX="+PX+";");

51	System.out.print("UNITID="+UNITID+";");

52	System.out.println();

53

54

}

55

56	//System.out.println(conn);

57	result.close();//数据库先开后关

58	stmt.close();

59	conn.close();//关闭数据库

60

61

}

62

63

}

[代码][Java]代码

01	7.下面代码可以查询数据库种的内容：

02	packageoracle.ResultSetDemo01.org;

03

04	importjava.sql.Connection;

05	importjava.sql.DriverManager;

06	importjava.sql.ResultSet;

07	importjava.sql.Statement;

08

09	publicclassConnectJdbc {

10	//驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中

11	publicstaticfinalString drive ="oracle.jdbc.driver.OracleDriver";

12

/**

13	* 连接地址，各个厂商提供单独记住

14	* jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。

15

*/

16	publicstaticfinalString url ="jdbc:oracle:thin:@192.168.1.15:1521:ORCL";

17

/**

18

* 用户 密码

19

*/

20	publicstaticfinalString DBUSER="gyly";

21	publicstaticfinalString password="gyly";

22

23

24	publicstaticvoidmain(String[] args)throwsException{

25	// TODO Auto-generated method stub

26	Connection conn =null;//表示数据库连接

27	Statement stmt=null;//表示数据库的更新

28	ResultSet result =null;//查询数据库

29	Class.forName(drive);//使用class类来加载程序

30	conn =DriverManager.getConnection(url,DBUSER,password);//连接数据库

31	//Statement接口要通过connection接口来进行实例化操作

32	stmt = conn.createStatement();

33	//执行SQL语句来查询数据库

34	result =stmt.executeQuery("SELECT DEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");

35	while(result.next()){//判断有没有下一行

36	intDEPTID =result.getInt(1);

37	String DEPTNAME = result.getString(2);

38	String ADDR = result.getString(3);

39	longTEL = result.getLong(4);

40	longFAX = result.getLong(5);

41	String LXR =result.getString(6);

42	intPX =result.getInt(7);

43	intUNITID = result.getInt(8);

44	System.out.print("DEPTID="+DEPTID+";");

45	System.out.print("DEPTNAME="+DEPTNAME+";");

46	System.out.print("ADDR="+ADDR+";");

47	System.out.print("TEL="+TEL+";");

48	System.out.print("FAX="+FAX+";");

49	System.out.print("LXR="+LXR+";");

50	System.out.print("PX="+PX+";");

51	System.out.print("UNITID="+UNITID+";");

52	System.out.println();

53

54

}

55

56	//System.out.println(conn);

57	result.close();//数据库先开后关

58	stmt.close();

59	conn.close();//关闭数据库

60

61

}

62

63

}