Jdbc连接数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class JdbcUtils {
String dirver = “com.mysql.jdbc.Driver”;
String url = ····";//地址
String username = “”;//用户名
String password = “”;//密码
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;

//获取连接
public Connection getConn() {
    try {
        Class.forName(dirver);
        conn = DriverManager.getConnection(url, username, password);
    } catch (Exception e) {
        e.printStackTrace();
    }
    return conn;
}

//增删改
public int excuteup(String sql, Object[] parems) {
    try {
        ps = getConn().prepareStatement(sql);
        if (parems != null) {
            for (int i = 0; i < parems.length; i++) {
                ps.setObject(i + 1, parems[i]);
            }
        }
        int result = ps.executeUpdate();
        return result;
    } catch (Exception e) {
        e.printStackTrace();
    }
    return 0;
}

//查
public ResultSet excuteSel(String sql, Object[] params) {
    try {
        ps = getConn().prepareStatement(sql);
        if (params != null) {
            for (int i = 0; i < params.length; i++) {
                ps.setObject(i + 1, params[i]);
            }
        }
        rs = ps.executeQuery();
        this.closeAll(conn, ps, null);
    } catch (Exception e) {
        e.printStackTrace();
    }
    return rs;
}

//关闭
public void closeAll(Connection conn, PreparedStatement ps, ResultSet rs) {
    try {
        if (rs != null) {
            rs.close();
        }
        if (ps != null) {
            ps.close();
        }
        if (conn != null) {
            conn.close();
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}