Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ++++++++++++ my function +++++++++++++
- /**
- *
- * @param listcolumn
- * @param table
- * @param data
- * @param condition
- * @return
- * @throws java.sql.SQLException
- */
- public ArrayList<Map<String, Object>> loadData(String[] listcolumn, String table, String condition, String[] data) throws SQLException{
- ArrayList result = new ArrayList();
- try (Connection con = koneksi.getcon(true)) {
- String column = "";
- for(int i = 0; i < listcolumn.length; i++){
- if(listcolumn.length < 2){
- column += listcolumn[i];
- }else if(i == (listcolumn.length-1)){
- column += listcolumn[i];
- }else{
- column += listcolumn[i]+", ";
- }
- }
- String sql = "SELECT "+ column +" FROM "+ table + " " + condition;
- PreparedStatement prep = con.prepareStatement(sql);
- if(data.length >= 1){
- int i = 1;
- for(String dt : data){
- prep.setString(i, dt);
- i++;
- }
- }
- ResultSet reset = prep.executeQuery();
- while(reset.next()){
- Map<String, Object> map = new HashMap<>();
- for( String clmn : listcolumn){
- if(clmn.contains(".")){
- String[] clm = clmn.split("[.]");
- map.put(clm[1], reset.getObject(clm[1]));
- }else{
- map.put(clmn, reset.getObject(clmn));
- }
- }
- result.add(map);
- }
- con.close();
- }
- return result;
- }
- public void insertData(String table, Map<String, Object> data){
- try{
- // get key from data Map
- try (// call connectino from class koneksi
- Connection con = koneksi.getcon()) {
- // get key from data Map
- Set<String> keys = data.keySet();
- String keyQuery = "", valueQuery = "", sql;
- // set query from key for build query.
- if (keys != null){
- keyQuery += "( ";
- int x = 0;
- for (String key : keys) {
- if(x > 0){
- keyQuery += ","+key+" ";
- }else{
- keyQuery += key+" ";
- }
- x++;
- }
- keyQuery += ")";
- // count how many value from data
- valueQuery += "( ";
- for (int i = 0; i < data.size(); i++) {
- if(i > 0){
- valueQuery += ",? ";
- }else{
- valueQuery += "? ";
- }
- }
- valueQuery += ")";
- }
- // generate and execute query
- if(!"".equals(keyQuery) && !"".equals(valueQuery)){
- sql = "INSERT INTO "+ table+ " " + keyQuery + " VALUES " + valueQuery;
- PreparedStatement prep;
- prep = con.prepareStatement(sql);
- int index = 1;
- for (String key : keys) {
- prep.setObject(index, data.get(key));
- index++;
- }
- prep.executeUpdate();
- prep.close();
- con.close();
- }
- }
- }catch(Exception e){
- }
- }
- ++++++++++ use function +++++++++++
- for(Map<String, Object> dataDetail : dataDiagnosa){
- dataDetail.remove("no");
- final Query queryDetail = new Query();
- queryDetail.insertData("tb_detail_history_diagnosa", dataDetail);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement