东软java实训日记_东软实训（Java EE）

package com.neusoft.utils;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class FirstDemo {

public static void main(String[] args) {

// 2.建立同数据库的连接

// url:统一资源定位符

String url = "jdbc:oracle:thin:@10.25.85.247:1521:orcl";

String user = "scott";

String password = "tiger";

Connection con = null;

Statement st = null;

String sql = "select * from DEPT";

ResultSet rs = null;

// 1.加载驱动

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection(url, user, password);

System.out.println("数据库连接成功！");

// 3.取得statement对象

st = con.createStatement();

// 4.发送statement到oracle中，并且查询表

rs = st.executeQuery(sql);

// 5.取出结果集中的数据

while (rs.next()) {

System.out.println("*************************");

String deptno = rs.getString(1);

System.out.println(deptno);

String dname = rs.getString(2);

System.out.println(dname);

String loc = rs.getString(3);

System.out.println(loc);

System.out.println("*************************");

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

// 6.关闭资源

try {

if (rs != null) {

rs.close();

}

} catch (SQLException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }   try {    if (st != null) {     st.close();    }   } catch (SQLException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }   try {    if (con != null) {     con.close();    }   } catch (SQLException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }  } }