封装Java连接Oracle数据库的工具类

一、封装的工具类

 

package com.util;

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


/***
 * @author 胖浩
 * 说明：这个类封装了操作Oracle数据库的CRUD方法
 */
public class ConnectionOracleUtil {
	Connection connection = null;
	Statement statement = null;
	ResultSet resultSet=null;
	
	/***
	 * 连接数据库
	 */
	public Connection openConnection() {
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver"); // 加载oracle驱动
			connection= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "system","123456"); // 连接数据库
		} catch (Exception e) {
			e.printStackTrace();
		} 
		return connection;
	}
	
	/**
	 * @param Sql语句
	 * 功能：定义了Oracle数据库的增删改的方法
	 */
	public int update(String sql) {
		int res=0;
		try {
			statement = connection.createStatement();
			res = statement.executeUpdate(sql);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return res;
	}
	
	/**
	 * @param Sql语句
	 * 功能：查询Oracle数据库表
	 */
	public ResultSet query(String sql) {
		
		 try {
			statement= connection.createStatement();
			resultSet = statement.executeQuery(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return resultSet;
	}
	
	/**
	 * @param tableName数据库表名
	 * 功能：查看表源数据
	 * 输出：数据库表的表字段名-表字段类型名-表字段类型值
	 */
	public void getTableMataData(String tableName) {
		
		try {
			statement = connection.createStatement();
			resultSet = statement.executeQuery("select * from "+tableName);
			ResultSetMetaData rs = resultSet.getMetaData(); //获取源数据
			int count = rs.getColumnCount();
			for (int i = 1; i < count; i++) {
				System.out.println(rs.getColumnName(i)+"-"+rs.getColumnTypeName(i)+"-"+rs.getColumnType(i));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
	}
}

二、测试（提前准备好数据库）

package com.qianfeng.test;


import java.sql.ResultSet;
import java.sql.SQLException;

import com.util.ConnectionOracleUtil;

public class Test {
	
	public static void main(String[] args) {
		ConnectionOracleUtil conn = new ConnectionOracleUtil();
		conn.openConnection();
		conn.getTableMataData("student");
		//conn.update("insert into car values(6,'现代','白色','100000￥')");
		
		ResultSet resultSet = conn.query("select * from student");
		try {
			while (resultSet.next()) {
				System.out.println(resultSet.getInt("stuid")+"-"+resultSet.getString("stuname")+"-"+resultSet.getString("stusex")+"-"+resultSet.getString("stuage"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}