jdbc mysql 事务隔离级别_JDBC一对一，一对多，多对多,事务隔离级别

package com.zjy.jdbc.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.apache.commons.dbcp.BasicDataSource;

import com.zjy.jdbc.model.PageBean;

public class DBUtil {

private static BasicDataSource datasource;

public static Connection getConnectionByJdbc() {

try {

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8";

String username = "root";

String password = "密码";

Connection conn = DriverManager.getConnection(url, username,

password);

return conn;

} catch (Exception e) {

throw new IllegalArgumentException(e);

}

}

public static Connection getConnection() {

try {

return getConnectionByDataSource();

} catch (Exception e) {

throw new IllegalArgumentException(e);

}

}

public static boolean execute(String sql) {

try {

Connection conn = DBUtil.getConnection();

Statement st = conn.createStatement();

boolean result = st.execute(sql);

st.close();

conn.close();

return result;

} catch (SQLException e) {

throw new IllegalArgumentException(e);

}

}

public static List> executeQuery(String sql) {

try {

Connection conn = DBUtil.getConnection();

Statement st = conn.createStatement();

ResultSet set = st.executeQuery(sql);

ResultSetMetaData metaData = set.getMetaData();

List> result = new ArrayList>();

int columnCount = metaData.getColumnCount();

while (set.next()) {

Map map = new HashMap();

for (int i = 1; i <= columnCount; i++) {

Stri