Open chickenronz opened 8 years ago
/*
package uas;
import java.awt.HeadlessException; import javax.swing.JOptionPane; import net.proteanit.sql.DbUtils; import java.sql.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFrame; import javax.swing.WindowConstants;
public class frmmahasiswa extends javax.swing.JFrame {
private boolean databaru;
private void GetData(){ try{ //java.sql.Connection conn =(java.sql.Connection)uas.koneksi.koneksidb(); Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.Statement stm= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); java.sql.ResultSet sql; sql = stm.executeQuery("select * from tbl_mahasiswa"); //sql.last(); table1.setModel(DbUtils.resultSetToTableModel(sql));
}catch(Exception e){ JOptionPane.showMessageDialog(null, e.getMessage()); }
}
public frmmahasiswa() { initComponents(); this.setLocationRelativeTo(null); GetData(); databaru=true; } private void getClear(){ id.setText(""); jnim.setText(""); fname.setText(""); lname.setText(""); date.setText(""); cmb1.setSelectedItem("MALE"); } private void getupdate(){ try{ String sql = "update tbl_mahasiswa SET nim='"+jnim.getText()+"',firstname='"+fname.getText()+"',lastname='"+lname.getText()+"',gender='"+cmb1.getSelectedItem().toString()+"',birthdate='"+date.getText()+"' where id='"+id.getText()+"'"; Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.PreparedStatement pst= conn.prepareStatement(sql); pst.execute(); JOptionPane.showMessageDialog(null, "Success Update Databse"); }catch(SQLException e){ JOptionPane.showMessageDialog(null, e.getMessage()); } } private void getsave(){ if (databaru=true){ try{ String sql = "insert into tbl_mahasiswa values ('"+id.getText()+"','"+jnim.getText()+"','"+fname.getText()+"','"+lname.getText()+"','"+cmb1.getSelectedItem().toString()+"','"+date.getText()+"')"; Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.PreparedStatement pst= conn.prepareStatement(sql); pst.execute(); JOptionPane.showMessageDialog(null, "Success insert into Databse"); }catch(SQLException e){ JOptionPane.showMessageDialog(null, e.getMessage()); } } } private void getdelete(){ try{ String sql ="DELETE from tbl_mahasiswa where id='"+id.getText()+"'"; Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.PreparedStatement pst= conn.prepareStatement(sql); pst.execute(); databaru=true; }catch(Exception e){ JOptionPane.showMessageDialog(null, e.getMessage()); }GetData(); getClear(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jPanel2 = new javax.swing.JPanel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); id = new javax.swing.JTextField(); jnim = new javax.swing.JTextField(); fname = new javax.swing.JTextField(); lname = new javax.swing.JTextField(); date = new javax.swing.JTextField(); save = new javax.swing.JButton(); delete = new javax.swing.JButton(); exit = new javax.swing.JButton(); cmb1 = new javax.swing.JComboBox<>(); Clear = new javax.swing.JButton(); update = new javax.swing.JButton(); jPanel3 = new javax.swing.JPanel(); jScrollPane1 = new javax.swing.JScrollPane(); table1 = new javax.swing.JTable(); jPanel4 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setBackground(javax.swing.UIManager.getDefaults().getColor("JXMonthView.selectedBackground")); setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR)); setLocation(new java.awt.Point(6, 24)); setUndecorated(true); setResizable(false); addWindowListener(new java.awt.event.WindowAdapter() { public void windowActivated(java.awt.event.WindowEvent evt) { formWindowActivated(evt); } }); jPanel2.setBackground(new java.awt.Color(139, 201, 254)); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "RECORD DATA", javax.swing.border.TitledBorder.LEFT, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Dialog", 1, 12))); // NOI18N jLabel2.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel2.setText("id"); jLabel3.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel3.setText("Nim"); jLabel4.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel4.setText("FirstName"); jLabel5.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel5.setText("LastName"); jLabel6.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel6.setText("Gender"); jLabel7.setFont(new java.awt.Font("Arial", 1, 15)); // NOI18N jLabel7.setText("BirthDate"); save.setFont(new java.awt.Font("Ubuntu", 1, 15)); // NOI18N save.setIcon(new javax.swing.ImageIcon(getClass().getResource("/uas/image/1467503114_Save.png"))); // NOI18N save.setText("Save"); save.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { saveActionPerformed(evt); } }); delete.setFont(new java.awt.Font("Ubuntu", 1, 15)); // NOI18N delete.setIcon(new javax.swing.ImageIcon(getClass().getResource("/uas/image/1467503207_Remove.png"))); // NOI18N delete.setText("Delete"); delete.setToolTipText(""); delete.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { deleteActionPerformed(evt); } }); exit.setFont(new java.awt.Font("Ubuntu", 1, 15)); // NOI18N exit.setIcon(new javax.swing.ImageIcon(getClass().getResource("/uas/image/1467503146_Log Out.png"))); // NOI18N exit.setText("Exit"); exit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { exitActionPerformed(evt); } }); cmb1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "MALE", "FEMALE" })); Clear.setFont(new java.awt.Font("Ubuntu", 1, 15)); // NOI18N Clear.setIcon(new javax.swing.ImageIcon(getClass().getResource("/uas/image/1467503260_Edit.png"))); // NOI18N Clear.setText("Clear"); Clear.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ClearActionPerformed(evt); } }); update.setFont(new java.awt.Font("Ubuntu", 1, 15)); // NOI18N update.setIcon(new javax.swing.ImageIcon(getClass().getResource("/uas/image/1467503159_Synchronize.png"))); // NOI18N update.setText("Update"); update.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { updateActionPerformed(evt); } }); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(10, 10, 10) .addComponent(jLabel7)) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel6)) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel5)) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel4)) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel3)) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel2))) .addGap(13, 13, 13) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(fname) .addComponent(lname) .addComponent(date) .addComponent(jnim) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(cmb1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(id, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(0, 0, Short.MAX_VALUE)))) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(4, 4, 4) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(update) .addComponent(Clear, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 35, Short.MAX_VALUE) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(save, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(delete, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))) .addGap(18, 18, 18)) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(75, 75, 75) .addComponent(exit, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(id, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel2)) .addGap(12, 12, 12) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(jnim, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(fname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel5) .addComponent(lname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel6) .addComponent(cmb1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(36, 36, 36)) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(date, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel7))) .addGap(34, 34, 34) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(save) .addComponent(Clear)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(update) .addComponent(delete)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 27, Short.MAX_VALUE) .addComponent(exit) .addGap(18, 18, 18)) ); jPanel3.setBackground(new java.awt.Color(224, 245, 244)); jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Data Data", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Dialog", 1, 12))); // NOI18N table1.setBackground(new java.awt.Color(254, 254, 254)); table1.setBorder(null); table1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null, null, null}, {null, null, null, null, null, null}, {null, null, null, null, null, null}, {null, null, null, null, null, null} }, new String [] { "id", "nim", "firstname", "lastname", "gender", "birthdate" } )); table1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { table1MouseClicked(evt); } }); jScrollPane1.setViewportView(table1); javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3); jPanel3.setLayout(jPanel3Layout); jPanel3Layout.setHorizontalGroup( jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 468, Short.MAX_VALUE) ); jPanel3Layout.setVerticalGroup( jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE) ); jPanel4.setBackground(new java.awt.Color(97, 167, 239)); jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.TOP)); jLabel1.setFont(new java.awt.Font("Ubuntu", 1, 18)); // NOI18N jLabel1.setText("FORM MAHASISWA"); javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4); jPanel4.setLayout(jPanel4Layout); jPanel4Layout.setHorizontalGroup( jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel4Layout.createSequentialGroup() .addGap(21, 21, 21) .addComponent(jLabel1) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); jPanel4Layout.setVerticalGroup( jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel4Layout.createSequentialGroup() .addGap(20, 20, 20) .addComponent(jLabel1) .addContainerGap(20, Short.MAX_VALUE)) ); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); pack(); }// </editor-fold> private void saveActionPerformed(java.awt.event.ActionEvent evt) { getsave(); GetData(); getClear(); } private void deleteActionPerformed(java.awt.event.ActionEvent evt) { JOptionPane.showMessageDialog(null, "Data akan dihapus?"); getdelete(); } private void exitActionPerformed(java.awt.event.ActionEvent evt) { System.exit(0); } private void ClearActionPerformed(java.awt.event.ActionEvent evt) { getClear(); } private void updateActionPerformed(java.awt.event.ActionEvent evt) { int dialog=JOptionPane.showConfirmDialog(null, " ingin merubah data?","Yakin?",JOptionPane.YES_NO_OPTION); if (dialog== JOptionPane.YES_OPTION){ try{ if(databaru==true){ getsave(); }else{ getupdate(); } databaru=false; GetData(); }catch(Exception e){ JOptionPane.showMessageDialog(null, e.getMessage()); } }getClear(); } private void table1MouseClicked(java.awt.event.MouseEvent evt) { databaru=false; try{ int row = table1.getSelectedRow(); String click = (table1.getModel().getValueAt(row, 0).toString()); Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.Statement stm = conn.createStatement(); java.sql.ResultSet sql = stm.executeQuery("select * from tbl_mahasiswa where id='"+click+"'"); if(sql.next()){ String no = sql.getString("id"); id.setText(no); String nm = sql.getString("nim"); jnim.setText(nm); String nma = sql.getString("firstname"); fname.setText(nma); String lnm = sql.getString("lastname"); lname.setText(lnm); String gn = sql.getString("gender"); cmb1.setSelectedItem(gn); String tahun = sql.getString("birthdate"); date.setText(tahun); } }catch(Exception e){ JOptionPane.showMessageDialog(null, e.getMessage()); } } private void formWindowActivated(java.awt.event.WindowEvent evt) { } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(frmmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(frmmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(frmmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(frmmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(() -> { new frmmahasiswa().setVisible(true); }); } // Variables declaration - do not modify private javax.swing.JButton Clear; private javax.swing.JComboBox<String> cmb1; private javax.swing.JTextField date; private javax.swing.JButton delete; private javax.swing.JButton exit; private javax.swing.JTextField fname; private javax.swing.JTextField id; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTextField jnim; private javax.swing.JTextField lname; private javax.swing.JButton save; private javax.swing.JTable table1; private javax.swing.JButton update; // End of variables declaration
/*
package uas;
import java.awt.HeadlessException; import javax.swing.JOptionPane; import net.proteanit.sql.DbUtils; import java.sql.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFrame; import javax.swing.WindowConstants;
public class frmmahasiswa extends javax.swing.JFrame {
private boolean databaru;
private void GetData(){ try{ //java.sql.Connection conn =(java.sql.Connection)uas.koneksi.koneksidb(); Connection conn = (Connection)uas.koneksi.koneksidb(); java.sql.Statement stm= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); java.sql.ResultSet sql; sql = stm.executeQuery("select * from tbl_mahasiswa"); //sql.last(); table1.setModel(DbUtils.resultSetToTableModel(sql));
}
}