package com.zz.commonsql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* oracle 数据库连接类
*
* @author 张志
*
*/
public class OracleConnDB {
static String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
/**
* 获得连接
*
* return 返回连接
*
* retrun 返回null 获得连接失败
*/
public static Connection getConnection() {
try {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return DriverManager.getConnection(url, "zz", "zz");
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 执行增删改方法
*
* @param sql
* 需要执行的sql语句
*
* @return -1表示sql语句执行失败,否则执行成功
*
*/
public int executeUpdate(String sql) {
try {
Connection conn = this.getConnection();
Statement stmt = conn.createStatement();
int rows = stmt.executeUpdate(sql);
return rows;
} catch (SQLException e) {
e.printStackTrace();
}
return -1;
}
/**
* 执行查询的方法
*
* @param sql
* 需要执行的SQL语句
*
* @return 返回查询的结果集
*/
public ResultSet executeQuery(String sql) {
try {
Connection conn = this.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
return rs;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 关闭连接方法
*
* @param queryCon
*/
public void closeConnection(Connection queryCon) {
try {
queryCon.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args){
System.out.println(getConnection());
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* oracle 数据库连接类
*
* @author 张志
*
*/
public class OracleConnDB {
static String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
/**
* 获得连接
*
* return 返回连接
*
* retrun 返回null 获得连接失败
*/
public static Connection getConnection() {
try {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return DriverManager.getConnection(url, "zz", "zz");
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 执行增删改方法
*
* @param sql
* 需要执行的sql语句
*
* @return -1表示sql语句执行失败,否则执行成功
*
*/
public int executeUpdate(String sql) {
try {
Connection conn = this.getConnection();
Statement stmt = conn.createStatement();
int rows = stmt.executeUpdate(sql);
return rows;
} catch (SQLException e) {
e.printStackTrace();
}
return -1;
}
/**
* 执行查询的方法
*
* @param sql
* 需要执行的SQL语句
*
* @return 返回查询的结果集
*/
public ResultSet executeQuery(String sql) {
try {
Connection conn = this.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
return rs;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 关闭连接方法
*
* @param queryCon
*/
public void closeConnection(Connection queryCon) {
try {
queryCon.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args){
System.out.println(getConnection());
}
}