Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void ambilDataPemenang() {
- data = new Object[lelangClass.getRowCount()][1];
- data = (Object[][]) lelangClass.cariWinner();
- for (int i = 0; i < data.length; i++) {
- System.out.println("Test ambil data : "+data[i][0]+" "+data[i][1]);
- }
- for (int i = 0; i < data.length; i++) {
- System.out.println("Test ambil data : "+data[i][0]+" "+data[i][1]);
- Object datad = data[i][1];
- String telpo = (String) data[i][0];
- if(datad == data[i][1]){
- lelangClass.deletebit(telpo);
- }
- }
- }
- iki nggo select e
- public Object cariWinner() {
- try {
- String SQL = "SELECT no_telp, bit FROM dblelang.bit ORDER BY bit ASC;";
- ResultSet resultSet = database.selectData(SQL);
- resultSet.last();
- p = 0;
- n = resultSet.getRow();
- data = new Object[n][2];
- resultSet.beforeFirst();
- while (resultSet.next()) {
- data[p][0] = resultSet.getString(1); // isi ke tabel kolom 0 dgn namalelang
- data[p][1] = resultSet.getString(2); // isi ke tabel kolom 1 dgn isilelang
- p++;
- }
- resultSet.close();
- } catch (Exception e) {
- return null;
- }
- return data;
- } //akhir method getDataFromTl
- public void deletebit(String value) {
- try {
- String SQLDelete = "DELETE FROM dblelang.bit WHERE no_telp ='" + value + "'";
- int stat = database.exeQuery(SQLDelete);
- if (stat == 0) {
- }
- } catch (Exception e) {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement