netbeans建项目和mysql连接_Netbeans连接数据库

umgsai：select|@|   account.accountid,|@|   m.partnerid,|@|   p.shopid,|@|   shop.shop_name,|@|   shop.branch_name,|@|   plan.amount,|@|   plan.actualdeductamount,|@|   plan.actualpayamount,|@|   bankaccount.BankName,|@|   concat(bankaccount.BankAccountName),|@|   bankaccount.BankBranch,|@|   bankaccount.province,|@|   bankaccount.city,|@|   concat("银行卡号：",|@|   bankaccount.BankAccountNumber),|@|   plan.payabledate,|@|   plan.settlebegintime,|@|   plan.settleendtime,|@|   (CASE                                   |@|     WHEN plan.status=5 THEN '已打款'                             |@|     ELSE '未打款'                 |@|   END)     |@|from|@|   dpods_ts_accountmapping m     |@|join|@|   dpods_ts_account account                             |@|     on(|@|         account.accountid = m.accountid                             |@|     )     |@|join|@|   dpods_ts_partner p                             |@|     on(|@|         p.partnerid = m.partnerid                             |@|     )     |@|join|@|   dpods_ts_payplan plan                             |@|     on(|@|         plan.accountid = account.accountid                             |@|     )     |@|join|@|   dpdim_dp_shop shop                         |@|     on(|@|         shop.shop_id = p.shopid                         |@|     )     |@|join|@|   dpods_ts_deductandwithdrawmapping deductandwithdrawmapping       |@|     on(|@|         plan.ID = deductandwithdrawmapping.PayPlanID                 |@|     ) |@|join|@|   dpods_ts_withdraw withdraw                     |@|     on(|@|         withdraw.WithdrawID= deductandwithdrawmapping.WithdrawID               |@|     )   |@|join|@|   dpods_mr_customerbankaccount customerbankaccount             |@|     on(|@|         withdraw.BankAccountID = customerbankaccount.accountid             |@|     )   |@|join|@|   dpods_mr_bankaccount bankaccount                     |@|     on(|@|         bankaccount.id = customerbankaccount.MBAId                     |@|     )   |@|where|@|   account.accountid in(|@|     '210001162313'     |@|   )                 |@|   and plan.actualpayamount > 0.0                 |@|   and plan.payabledate >= '2016-05-01 00:00:00'                 |@|   and account.hp_statdate = "2016-07-11"                 |@|   and m.hp_statdate = "2016-07-11"                 |@|   and p.hp_statdate = "2016-07-11"                 |@|   and plan.hp_statdate = "2016-07-11"             |@|   and shop.hp_valid_end_dt = '3000-12-31'         |@|   and withdraw.hp_statdate = "2016-07-11"   |@|   and deductandwithdrawmapping.hp_statdate = "2016-07-11"   |@|   and deductandwithdrawmapping.Deleted=0;