Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mysql;
- import java.sql.*;
- import javax.swing.JOptionPane;
- import javax.swing.table.DefaultTableModel;
- /**
- *
- * @author jlee
- */
- public class Window extends javax.swing.JFrame {
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://localhost/ITDB";
- String user = "root";
- String pass = "abc123";
- Connection conn;
- Statement stm;
- ResultSet result;
- DefaultTableModel model;
- public Window() {
- dbConn();
- initComponents();
- tableLoad();
- }
- void dbConn() {
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, pass);
- stm = conn.createStatement();
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "Warning: " + e.getMessage());
- }
- }
- void tableLoad() { //main table loading class
- String[] colTitle = {"Name", "Email"};
- String[] rowData = new String[2];
- String sSQL = "";
- model = new DefaultTableModel(null, colTitle);
- sSQL = "SELECT * FROM ITTB";
- try {
- //PreparedStatement stm = conn.prepareStatement(sSQL);
- stm = conn.createStatement();
- ResultSet rs = stm.executeQuery(sSQL);
- while (rs.next()) {
- rowData[0] = rs.getString("Name");
- rowData[1] = rs.getString("Email");
- model.addRow(rowData);
- }
- table.setModel(model);
- } catch (SQLException ex) {
- JOptionPane.showMessageDialog(null, ex);
- }
- }
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jButton1 = new javax.swing.JButton();
- outInfo = new javax.swing.JLabel();
- jScrollPane1 = new javax.swing.JScrollPane();
- table = new javax.swing.JTable();
- btSearch = new javax.swing.JButton();
- inName = new javax.swing.JTextField();
- btExit = new javax.swing.JButton();
- jButton1.setText("jButton1");
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- table.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {},
- {},
- {},
- {}
- },
- new String [] {
- }
- ));
- jScrollPane1.setViewportView(table);
- btSearch.setText("Search by Name");
- btSearch.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btSearchActionPerformed(evt);
- }
- });
- inName.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- inNameActionPerformed(evt);
- }
- });
- btExit.setText("Exit");
- btExit.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btExitActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(26, 26, 26)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(btExit, javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(outInfo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGroup(layout.createSequentialGroup()
- .addComponent(btSearch)
- .addGap(18, 18, 18)
- .addComponent(inName))
- .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 373, Short.MAX_VALUE))
- .addContainerGap(24, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(20, 20, 20)
- .addComponent(btExit)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 229, Short.MAX_VALUE)
- .addGap(18, 18, 18)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(btSearch)
- .addComponent(inName, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(outInfo, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap())
- );
- pack();
- }// </editor-fold>
- private void btSearchActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- try {
- String nameSearch = inName.getText();
- String sqlSearch = "select * from ITTB where name = '" + nameSearch + "'";
- result = stm.executeQuery(sqlSearch);
- while (result.next()) {
- String name = result.getString("name");
- String email = result.getString("email");
- outInfo.setText(name + " " + email);
- }
- // result.close();
- // stm.close();
- // conn.close();
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, e.getMessage());
- }
- }
- private void inNameActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- inName.transferFocus();
- }
- private void btExitActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- //JOptionPane.showMessageDialog(null, "HI");
- this.dispose();
- // try {
- // result.close();
- // stm.close();
- // conn.close();
- //
- //
- //
- // } catch (Exception e) {
- // JOptionPane.showConfirmDialog(null, "Error: "+e.getMessage());
- // }
- }
- // Variables declaration - do not modify
- private javax.swing.JButton btExit;
- private javax.swing.JButton btSearch;
- private javax.swing.JTextField inName;
- private javax.swing.JButton jButton1;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JLabel outInfo;
- private javax.swing.JTable table;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment