dbconnection.java

来自「基于javaSwing的图书馆信息管理系统 使用oracle数据库连接」· Java 代码 · 共 56 行

package com.lib;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;

public class DBConnection {
	public static Connection con = null;
	
	public static Connection getConnection() {
		if(con != null) return con;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:zd", "system", "zd");
		} catch (ClassNotFoundException e) {
			System.out.println(e.getMessage());
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		}
		if (con == null)
			System.out.println("数据库连接失败");
		else
			System.out.println("数据库连接成功");
		return con;
	}
	public static void closeConnection() {
		try {
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void executeStatement(Connection con, String str) {
		try {
			Statement stmt = con.createStatement();
			if (!stmt.execute(str))
				System.out.println("SQL语句执行成功");
			else
				System.out.println("SQL语句执行失败");
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		}
	}

	public static void main(String[] args) throws SQLException {
		getConnection();
//		String createDemoTable = "CREATE TABLE demo_zd(id number(6) PRIMARY KEY, name varchar2(20) NOT NULL)";
//		executeStatement(con, createDemoTable);
//		con.close();
	}
}