jdbctest.java

来自「组织结构树的实现」· Java 代码 · 共 60 行

package com.model;

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

public class JDBCTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//oracle,SQLServler,
		//
		ResultSet  rs = null;
		Statement stmt = null;
		Connection conn = null;
		try {
			//注册
			 Class.forName("oracle.jdbc.driver.OracleDriver");
			//取得连接
			 conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:jytest","test","test");
			//创建Statement
			 stmt = conn.createStatement();
			//执行取得结果集(查询)
			 rs = stmt.executeQuery("select * from t_user");
			//遍历结果集
			while(rs.next()){
				
				System.out.println(rs.getString("username"));
				
			}
			//System.out.println("conn="+conn);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		
		
		
		
	}

}