Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Object cariWinnerk() {
- try {
- cariidbid();
- if (data.length > 1) {
- for (int i = 0; i < data.length; i++) {
- updatebid((String)data[p][0]);
- cariidbid();
- }
- }else{
- System.out.println("cilik dewe : "+data);
- }
- } catch (Exception e) {
- e.printStackTrace();
- return null;
- }
- return data;
- } //akhir method getDataFromTl
- 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);
- i++;
- }
- resultSet.close();
- return id;
- } catch (Exception e) {
- return null;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement