Advertisement
pendekar_langit

crud on java

Mar 29th, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.05 KB | None | 0 0
  1. ++++++++++++ my function +++++++++++++
  2. /**
  3.      *
  4.      * @param listcolumn
  5.      * @param table
  6.      * @param data
  7.      * @param condition
  8.      * @return
  9.      * @throws java.sql.SQLException
  10.      */
  11.     public ArrayList<Map<String, Object>> loadData(String[] listcolumn, String table, String condition, String[] data) throws SQLException{
  12.         ArrayList result = new ArrayList();
  13.         try (Connection con = koneksi.getcon(true)) {
  14.             String column = "";
  15.             for(int i = 0; i < listcolumn.length; i++){
  16.                 if(listcolumn.length < 2){
  17.                     column += listcolumn[i];
  18.                 }else if(i == (listcolumn.length-1)){
  19.                     column += listcolumn[i];
  20.                 }else{
  21.                     column += listcolumn[i]+", ";
  22.                 }
  23.             }
  24.             String sql = "SELECT "+ column +" FROM "+ table + " " + condition;
  25.             PreparedStatement prep = con.prepareStatement(sql);
  26.             if(data.length >= 1){
  27.                 int i = 1;
  28.                 for(String dt : data){
  29.                     prep.setString(i, dt);
  30.                     i++;
  31.                 }
  32.             }
  33.             ResultSet reset =  prep.executeQuery();
  34.             while(reset.next()){
  35.                 Map<String, Object> map = new HashMap<>();
  36.                 for( String clmn : listcolumn){
  37.                     if(clmn.contains(".")){
  38.                         String[] clm = clmn.split("[.]");
  39.                         map.put(clm[1], reset.getObject(clm[1]));
  40.                     }else{
  41.                         map.put(clmn, reset.getObject(clmn));
  42.                     }
  43.                 }
  44.                 result.add(map);
  45.             }
  46.             con.close();
  47.         }
  48.         return result;
  49.     }
  50. public void insertData(String table, Map<String, Object> data){
  51. try{
  52. // get key from data Map
  53. try (// call connectino from class koneksi
  54. Connection con = koneksi.getcon()) {
  55. // get key from data Map
  56. Set<String> keys = data.keySet();
  57. String keyQuery = "", valueQuery = "", sql;
  58. // set query from key for build query.
  59. if (keys != null){
  60. keyQuery += "( ";
  61. int x = 0;
  62. for (String key : keys) {
  63. if(x > 0){
  64. keyQuery += ","+key+" ";
  65. }else{
  66. keyQuery += key+" ";
  67. }
  68. x++;
  69. }
  70. keyQuery += ")";
  71. // count how many value from data
  72. valueQuery += "( ";
  73. for (int i = 0; i < data.size(); i++) {
  74. if(i > 0){
  75. valueQuery += ",? ";
  76. }else{
  77. valueQuery += "? ";
  78. }
  79. }
  80. valueQuery += ")";
  81. }
  82. // generate and execute query
  83. if(!"".equals(keyQuery) && !"".equals(valueQuery)){
  84. sql = "INSERT INTO "+ table+ " " + keyQuery + " VALUES " + valueQuery;
  85. PreparedStatement prep;
  86. prep = con.prepareStatement(sql);
  87. int index = 1;
  88. for (String key : keys) {
  89. prep.setObject(index, data.get(key));
  90. index++;
  91. }
  92. prep.executeUpdate();
  93. prep.close();
  94. con.close();
  95. }
  96. }
  97. }catch(Exception e){
  98. }
  99. }
  100. ++++++++++ use function +++++++++++
  101. for(Map<String, Object> dataDetail : dataDiagnosa){
  102. dataDetail.remove("no");
  103. final Query queryDetail = new Query();
  104. queryDetail.insertData("tb_detail_history_diagnosa", dataDetail);
  105. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement