JDBC java连接Oracle基本方法

来源：互联网发布：网络热销产品编辑：程序博客网时间：2024/06/06 08:52

import java.sql.*;public class test {public static void main(String[] args) {Connection connection = null;Statement statement = null;ResultSet rs = null;try {// 1.加载驱动类Class.forName("oracle.jdbc.driver.OracleDriver");// 2.连接oracle java.sql.Connection// getConnection(url,username,password);//// url格式:jdbc:oracle:thin:@//<host>:<port>/ServiceNameconnection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:User", "scott", "tiger");// System.out.println(connection);打印成功即连接成功.// 3.执行sql语句 java.sql.Statementstatement = connection.createStatement();// 4.执行查询语句-->查询得到的结果存到结果集java.sql.ResultSetrs = statement.executeQuery("select * from emp");// 5.访问结果集(这样访问可能会有异常)while (rs.next()) {for (int i = 1; i <= rs.getRow(); i++) {// if(rs.getObject(i)!=null)System.out.print(rs.getObject(i) + "");}System.out.println();}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();} finally {try {rs.close();statement.close();connection.close();} catch (Exception e) {e.printStackTrace();}}}}

0 0