java oracle 数据库连接和增删改查

import org.testng.Assert;
import org.testng.annotations.Test;

import java.sql.*;

public class DButil {

    public static Connection getConnection(String urlP,String userName,String pwd,String driverName){
        Connection conn=null;

        try {
            String url = urlP;
            String user= userName;
            String password= pwd;

            Class.forName(driverName);//加载数据驱动
            conn = DriverManager.getConnection(url, user, password);// 连接数据库

        } catch (ClassNotFoundException e) {
            Assert.assertTrue(false,"加载数据库驱动失败：" + e.getMessage());
            e.printStackTrace();
            System.out.println("加载数据库驱动失败");
        }catch(Exception e){
            Assert.assertTrue(false,"连接数据库失败:" + e.getMessage());

            e.printStackTrace();
            System.out.println("连接数据库失败");
        }
        return conn;
    }
    public static void close(Connection conn, PreparedStatement ps, ResultSet rs){
        try {
            if(rs!=null){
                rs.close();
            }
        } catch (SQLException e) {
            Assert.assertTrue(false,"数据库关闭失败:" + e.getMessage());

            e.printStackTrace();
        }

        try {
            if(ps!=null){
                ps.close();
            }
        } catch (SQLException e) {
            Assert.assertTrue(false,"数据库关闭失败:" + e.getMessage());

            e.printStackTrace();
        }

        try {
            if(conn!=null){
                conn.close();
            }
        } catch (SQLException e) {
            Assert.assertTrue(false,"数据库关闭失败:" + e.getMessage());

            e.printStackTrace();
        }

    }

    public static void closeState(PreparedStatement preparedStatement ) {
        try {
            if (preparedStatement != null) {
                preparedStatement.close();
            }

        } catch (SQLException e) {
            Assert.assertTrue(false,"数据库关闭失败:" + e.getMessage());

            e.printStackTrace();
        }
    }
    public static void closeResult(ResultSet resultSet ) {
        try {
            if (resultSet != null) {
                resultSet.close();
            }

        } catch (SQLException e) {
            Assert.assertTrue(false,"数据库关闭失败:" + e.getMessage());

            e.printStackTrace();
        }
    }

    public static ResultSet exeQuery(Connection conn,String sql){
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        try {
            preparedStatement = conn.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
        } catch (SQLException e) {
            Assert.assertTrue(false,"查询语句执行失败:" + e.getMessage());
            e.printStackTrace();
        }
        return  resultSet;
    }


    public static int delete(Connection con, String sql, int index, String var)
    {
        int result = 0;
        PreparedStatement pre = null;
        try
        {
            pre = con.prepareStatement(sql);
            pre.setString(index, var);
            result = pre.executeUpdate();
        }
        catch (SQLException e)
        {
            Assert.assertTrue(false,"删除语句执行失败:" + e.getMessage());
            e.printStackTrace();
        }

        return result;
    }

    public static void add(Connection conn,String sql)//添加数据
    {
        PreparedStatement preparedStatement = null;
        try {
            preparedStatement = conn.prepareStatement(sql);

            preparedStatement.executeUpdate();
            System.out.println("插入成功");
        } catch (SQLException e) {
            Assert.assertTrue(false,"增加语句执行失败:" + e.getMessage());
            e.printStackTrace();
        }
    }

    public static int update(Connection con, String sql, int index, String var)
    {
        int result = 0;
        PreparedStatement pre = null;
        try
        {
            pre = con.prepareStatement(sql);
            pre.setString(index, var);
            result = pre.executeUpdate();
        }
        catch (SQLException e)
        {
            Assert.assertTrue(false,"更新语句执行失败:" + e.getMessage());
            e.printStackTrace();
        }

        return result;
    }




//    @Test
//    public void test(){
//
//
//        Connection conn = DButil.getConnection();
//        String sql = "select bbm.LOGSYS from MARD_DALI_BBM.MARA_BBM bbm";
//        PreparedStatement pstmt = null;
//        ResultSet rs  = null;
//
//        try {
//            pstmt =  conn.prepareStatement(sql);
//            rs =  pstmt.executeQuery();
//             while(rs.next()){
//                 System.out.println("****" + rs.getString("LOGSYS"));
//             }
//
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }finally {
//            DButil.close(conn, pstmt, rs);
//
//        }
//    }

}