JDBC数据库的链接

public class BaseDao {
    private static final String url = "jdbc:mysql://localhost:3306/news?useUnicode=true&characterEncoding=UTF-8&useSSL=false";
    private static final String driver = "com.mysql.jdbc.Driver";
    private static final String username = "admin";
    private static final String password = "123456";
    private Connection conn;
    private PreparedStatement ps;
    private ResultSet rs;



    public Connection getConnection(){
        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            e.printStackTrace();
        }


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

        if(ps != null){
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if(conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

    public int exceuteUpdate(String sql,Object...prams){
        int result=0;
        conn=this.getConnection();
        try {
            ps=conn.prepareStatement(sql);
            for(int i=0;i<prams.length;i++){
                ps.setObject(i+1, prams[i]);
            }
            result=ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            closeAll(conn, ps, rs);
        }
        return result;
    }
}