连接数据库的DBUtils工具类

最新推荐文章于 2021-03-13 08:08:35 发布

weixin_30919919

最新推荐文章于 2021-03-13 08:08:35 发布

阅读量119

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java

原文链接：http://www.cnblogs.com/E-star/p/3386687.html

本文提供了一个Java程序示例，展示了如何使用Oracle JDBC驱动连接到Oracle数据库，并执行简单的SQL查询来获取数据。该程序首先加载Oracle驱动，然后通过JDBC URL建立数据库连接，并使用PreparedStatement执行SQL查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

public class DBUtils {
	static{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static Connection getConnection() throws SQLException{
		String url = "jdbc:oracle:thin:@10.25.116.138:1521:orcl";
		Connection conn = DriverManager.getConnection(url, "scott", "tiger");
		return conn;
	}
	public static void close(PreparedStatement ps){
		if(ps != null){
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	public static void close(ResultSet rs){
		if(rs != null){
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	public static void close(Connection conn){
		if(conn != null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public static void main(String[] args) {
		
		String answer = "";
		try {
			Connection conn = DBUtils.getConnection();
			StringBuilder sql = new StringBuilder("select name from t_emp");
			PreparedStatement ps = conn.prepareStatement(sql.toString());
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				answer += rs.getString("name");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("answer = " + answer);
	}
}

转载于:https://www.cnblogs.com/E-star/p/3386687.html