Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Object cariWinnerk() {
- try {
- String[] datak = cariidbid();
- if (datak.length > 1) {
- for (int i = 0; i > datak.length; i++) {
- updatebid(datak[p]);
- }
- cariWinnerk();
- } else {
- System.out.println("cilik dewe : " + datak);
- }
- } catch (Exception e) {
- e.printStackTrace();
- return null;
- }
- return data;
- }
- public void updatebid(String data) {
- try {
- String SQLEdit = "UPDATE dblelang.bid SET flag = 1 WHERE lelang.idlelang = '" + data + "';";
- int stat = database.exeQuery(SQLEdit);
- if (stat == 0) {
- JOptionPane.showMessageDialog(null, "Data tidak dapat diubah");
- }
- } catch (Exception e) {
- }
- }
- //untuk mencari pemenang..
- public String[] cariidbid() {
- try {
- String SQL = "select idbid from dblelang.bid where bid = (select min(bid) from bid where flag = 0);";
- ResultSet resultSet = database.selectData(SQL);
- resultSet.last();
- n = resultSet.getRow();
- String[] id = new String[n];
- resultSet.beforeFirst();
- int i = 0;
- while (resultSet.next()) {
- id[i] = resultSet.getString(1);
- System.out.println(id[i]);
- i++;
- }
- resultSet.close();
- return id;
- } catch (Exception e) {
- return null;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement