开发学院软件开发 Java java连接jdbc读取oracle数据库的内容阅读

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

　2012-06-05 14:09:23　来源：WEB开发网　闂傚倸鍊风欢姘缚瑜嶈灋闁圭虎鍠栫粻顖炴煥閻曞倹瀚�

闂傚倸鍊风粈渚€骞夐敓鐘插瀭闁汇垹鐏氬畷鏌ユ煙閹殿喖顣奸柛搴＄У閵囧嫰骞掗幋婵冨亾閻㈢ǹ纾婚柟鐐灱濡插牊绻涢崱妤冃℃繛宀婁簽缁辨捇宕掑鎵佹瀸闂佺懓鍤栭幏锟�

濠电姷鏁告慨顓㈠箯閸愵喖宸濇い鎾寸箘閹规洟姊绘笟鈧ḿ褍煤閵堝悿娲Ω閳轰胶鍔﹀銈嗗笂閼冲爼鍩婇弴銏＄厪闁搞儮鏅涙禒褏绱掓潏鈺佷槐闁轰焦鎹囬弫鎾绘晸閿燂拷闂傚倸鍊风欢姘缚瑜嶈灋闁圭虎鍠栫粻顖炴煥閻曞倹瀚�　　闂傚倸鍊烽懗鑸电仚缂備胶绮〃鍛村煝瀹ュ鍗抽柕蹇曞У閻庮剟姊虹紒妯哄闁圭⒈鍋嗛惀顏囶樄闁哄本娲樼换婵婄疀閺囩姷鐛ラ梻浣哄帶婢瑰﹥绂嶅⿰鍫氣偓鏃堝礃椤忎礁浜鹃柨婵嗛婢ь喖霉閻樻瑥瀚粻楣冩煕椤愩倕鏋庨柣蹇嬪劜閵囧嫰寮村Ο鍝勫Е濡炪們鍨洪悷鈺呭箖閳╁啯鍎熼柕鍥у簻閹凤拷

核心提示：7.下面代码可以查询数据库种的内容：package oracle.ResultSetDemo01.org;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statemen

7.下面代码可以查询数据库种的内容：
package oracle.ResultSetDemo01.org;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectJdbc {
 //驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中
	public static final String drive = "oracle.jdbc.driver.OracleDriver";
	/**
	 * 连接地址，各个厂商提供单独记住
	 * jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。
	 */
	public static final String url = "jdbc:oracle:thin:@192.168.1.15:1521:ORCL";
	/**
	 * 用户 密码
	 */
	public static final String DBUSER="gyly";
	public static final String password="gyly";
	

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub      
		    Connection conn = null;//表示数据库连接
		    Statement stmt= null;//表示数据库的更新
		    ResultSet result = null;//查询数据库	   
			Class.forName(drive);//使用class类来加载程序
			conn =DriverManager.getConnection(url,DBUSER,password);	//连接数据库
			//Statement接口要通过connection接口来进行实例化操作
			stmt = conn.createStatement();
			//执行SQL语句来查询数据库
			result =stmt.executeQuery("SELECT DEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");
			while(result.next()){//判断有没有下一行
				int  DEPTID =result.getInt(1);
				String DEPTNAME = result.getString(2);
				String ADDR = result.getString(3);
				long TEL = result.getLong(4);
				long FAX = result.getLong(5);
				String LXR =result.getString(6);
				int PX =result.getInt(7);
				int UNITID = result.getInt(8);
				System.out.print("DEPTID="+DEPTID+";");
				System.out.print("DEPTNAME="+DEPTNAME+";");
				System.out.print("ADDR="+ADDR+";");
				System.out.print("TEL="+TEL+";");
				System.out.print("FAX="+FAX+";");
				System.out.print("LXR="+LXR+";");
				System.out.print("PX="+PX+";");
				System.out.print("UNITID="+UNITID+";");
				System.out.println();
			
			}
			
			//System.out.println(conn);	
			result.close();//数据库先开后关
			stmt.close();
			conn.close();//关闭数据库
			
	}

}

7.下面代码可以查询数据库种的内容：
package oracle.ResultSetDemo01.org;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectJdbc {
 //驱动程序就是之前在classpath中配置的jdbc的驱动程序jar中
	public static final String drive = "oracle.jdbc.driver.OracleDriver";
	/**
	 * 连接地址，各个厂商提供单独记住
	 * jdbc:oracle:thin:@localhost:1521:ORCL localhost 是ip地址。
	 */
	public static final String url = "jdbc:oracle:thin:@192.168.1.15:1521:ORCL";
	/**
	 * 用户 密码
	 */
	public static final String DBUSER="gyly";
	public static final String password="gyly";
	

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub      
		    Connection conn = null;//表示数据库连接
		    Statement stmt= null;//表示数据库的更新
		    ResultSet result = null;//查询数据库	   
			Class.forName(drive);//使用class类来加载程序
			conn =DriverManager.getConnection(url,DBUSER,password);	//连接数据库
			//Statement接口要通过connection接口来进行实例化操作
			stmt = conn.createStatement();
			//执行SQL语句来查询数据库
			result =stmt.executeQuery("SELECT DEPTID,DEPTNAME,ADDR,TEL,FAX,LXR,PX,UNITID FROM bs_dept");
			while(result.next()){//判断有没有下一行
				int  DEPTID =result.getInt(1);
				String DEPTNAME = result.getString(2);
				String ADDR = result.getString(3);
				long TEL = result.getLong(4);
				long FAX = result.getLong(5);
				String LXR =result.getString(6);
				int PX =result.getInt(7);
				int UNITID = result.getInt(8);
				System.out.print("DEPTID="+DEPTID+";");
				System.out.print("DEPTNAME="+DEPTNAME+";");
				System.out.print("ADDR="+ADDR+";");
				System.out.print("TEL="+TEL+";");
				System.out.print("FAX="+FAX+";");
				System.out.print("LXR="+LXR+";");
				System.out.print("PX="+PX+";");
				System.out.print("UNITID="+UNITID+";");
				System.out.println();
			
			}
			
			//System.out.println(conn);	
			result.close();//数据库先开后关
			stmt.close();
			conn.close();//关闭数据库
			
	}

}