[代码] [Java]代码
01 | 7 .下面代码可以查询数据库种的内容: |
02 | package oracle.ResultSetDemo01.org; |
03 |
04 | import java.sql.Connection; |
05 | import java.sql.DriverManager; |
06 | import java.sql.ResultSet; |
07 | import java.sql.Statement; |
08 |
09 | public class ConnectJdbc { |
10 | //驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中 |
11 | public static final String drive = "oracle.jdbc.driver.OracleDriver" ; |
12 | /** |
13 | * 连接地址,各个厂商提供单独记住 |
14 | * jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。 |
15 | */ |
16 | public static final String url = "jdbc:oracle:thin:@192.168.1.15:1521:ORCL" ; |
17 | /** |
18 | * 用户 密码 |
19 | */ |
20 | public static final String DBUSER= "gyly" ; |
21 | public static final String password= "gyly" ; |
22 | |
23 |
24 | public static void main(String[] args) throws Exception{ |
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 | int DEPTID =result.getInt( 1 ); |
37 | String DEPTNAME = result.getString( 2 ); |
38 | String ADDR = result.getString( 3 ); |
39 | long TEL = result.getLong( 4 ); |
40 | long FAX = result.getLong( 5 ); |
41 | String LXR =result.getString( 6 ); |
42 | int PX =result.getInt( 7 ); |
43 | int UNITID = 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 | package oracle.ResultSetDemo01.org; |
03 |
04 | import java.sql.Connection; |
05 | import java.sql.DriverManager; |
06 | import java.sql.ResultSet; |
07 | import java.sql.Statement; |
08 |
09 | public class ConnectJdbc { |
10 | //驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中 |
11 | public static final String drive = "oracle.jdbc.driver.OracleDriver" ; |
12 | /** |
13 | * 连接地址,各个厂商提供单独记住 |
14 | * jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。 |
15 | */ |
16 | public static final String url = "jdbc:oracle:thin:@192.168.1.15:1521:ORCL" ; |
17 | /** |
18 | * 用户 密码 |
19 | */ |
20 | public static final String DBUSER= "gyly" ; |
21 | public static final String password= "gyly" ; |
22 | |
23 |
24 | public static void main(String[] args) throws Exception{ |
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 | int DEPTID =result.getInt( 1 ); |
37 | String DEPTNAME = result.getString( 2 ); |
38 | String ADDR = result.getString( 3 ); |
39 | long TEL = result.getLong( 4 ); |
40 | long FAX = result.getLong( 5 ); |
41 | String LXR =result.getString( 6 ); |
42 | int PX =result.getInt( 7 ); |
43 | int UNITID = 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 | } |