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

宿9715

[代码][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	publicstaticfinalStringdrive ="oracle.jdbc.driver.OracleDriver";

12

/**

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

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

15

*/

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

17

/**

18

*用户 密码

19

*/

20	publicstaticfinalStringDBUSER="gyly";

21	publicstaticfinalStringpassword="gyly";

22

23

24	publicstaticvoidmain(String[]args)throwsException{

25	//TODO Auto-generated method stub

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

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

28	ResultSetresult =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("SELECTDEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");

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

36	intDEPTID=result.getInt(1);

37	StringDEPTNAME = result.getString(2);

38	StringADDR = result.getString(3);

39	longTEL= result.getLong(4);

40	longFAX= result.getLong(5);

41	StringLXR =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	publicstaticfinalStringdrive ="oracle.jdbc.driver.OracleDriver";

12

/**

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

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

15

*/

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

17

/**

18

*用户 密码

19

*/

20	publicstaticfinalStringDBUSER="gyly";

21	publicstaticfinalStringpassword="gyly";

22

23

24	publicstaticvoidmain(String[]args)throwsException{

25	//TODO Auto-generated method stub

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

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

28	ResultSetresult =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("SELECTDEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");

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

36	intDEPTID=result.getInt(1);

37	StringDEPTNAME = result.getString(2);

38	StringADDR = result.getString(3);

39	longTEL= result.getLong(4);

40	longFAX= result.getLong(5);

41	StringLXR =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

}