day 26 connection to table only

package day26;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

public class Day26BCRUD {
    private String address = "jdbc:mysql://127.0.0.1:3306/db_mng_batch5";
    private String userName = "root";
    private String passWord = "";

    public String addToDateSample(String dtIn, String noteIn, double numIn, boolean isTrue) {
        String outputMessage = "";
        int rowsAffected = 0;

        String sqlQuery = "INSERT INTO tbl_date_sample(date_rec, dt_note, dt_number, dt_boolean)"
                + " VALUES (?,?,?,?);";

        try {
            java.sql.Date sqlDtIn = java.sql.Date.valueOf(dtIn);

            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setDate(1, sqlDtIn);
            stmt.setString(2, noteIn);
            stmt.setDouble(3, numIn);
            stmt.setBoolean(4, isTrue);

            rowsAffected = stmt.executeUpdate();

            switch (rowsAffected) {
                case 1:
                    outputMessage = "Row added";
                    break;
                default:
                    outputMessage = "There is a problem. Please try again";
            }

            conn.close();
        } catch (Exception e) {
            outputMessage = e.toString();
        }
        return outputMessage;
    }

    public String updateDateSample(String dtIn, String noteIn, double numIn, boolean isTrue, int id) {
        String outputMessage = "";
        int rowsAffected = 0;

        String sqlQuery = "UPDATE tbl_date_sample"
                + " SET date_rec=?"
                + ", dt_note=?"
                + ", dt_number=?"
                + ", dt_boolean=?"
                + " WHERE dt_id=?;";

        try {
            java.sql.Date sqlDtIn = java.sql.Date.valueOf(dtIn);

            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setDate(1, sqlDtIn);
            stmt.setString(2, noteIn);
            stmt.setDouble(3, numIn);
            stmt.setBoolean(4, isTrue);
            stmt.setInt(5, id);

            rowsAffected = stmt.executeUpdate();

            switch (rowsAffected) {
                case 1:
                    outputMessage = "Row added";
                    break;
                default:
                    outputMessage = "There is a problem. Please try again";
            }

            conn.close();
        } catch (Exception e) {
            outputMessage = e.toString();
        }
        return outputMessage;
    }

    public String deleteDateSample(int id) {
        String outputMessage = "";
        int rowsAffected = 0;

        String sqlQuery = "DELETE FROM tbl_date_sample"
                + " WHERE dt_id=?;";

        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setInt(1, id);

            rowsAffected = stmt.executeUpdate();

            switch (rowsAffected) {
                case 1:
                    outputMessage = "Row added";
                    break;
                default:
                    outputMessage = "There is a problem. Please try again";
            }

            conn.close();
        } catch (Exception e) {
            outputMessage = e.toString();
        }
        return outputMessage;
    }

    private void getAllRows(JTable tableUsed){
        DefaultTableModel tableModel = (DefaultTableModel)tableUsed.getModel();
        tableModel.setRowCount(0); // pang delete ng laman ng table
        String sqlQuery = "SELECT * FROM tbl_date_sample;";

        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            ResultSet rs = stmt.executeQuery();

            while (rs.next()) {
                tableModel.addRow(new Object[]{
                    rs.getInt(1)
                    ,rs.getString(2)
                    ,rs.getString(3)
                    ,rs.getDouble(4)
                    ,rs.getBoolean(5)
                });
            }

            conn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    private void getAllRows(JTable tableUsed,String searchVal, String searchField){
        DefaultTableModel tableModel = (DefaultTableModel)tableUsed.getModel();
        tableModel.setRowCount(0);
        String fieldName;
        searchVal = "%"+searchVal+"%";
        // kung String, puro VARCHAR lang na column or field ang gagamitan
        switch (searchField) {
            case "Note":
            default:
                fieldName = "dt_note";
                break;
        }

        String sqlQuery = "SELECT * FROM tbl_date_sample WHERE " + fieldName + " LIKE ?;";

        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setString(1, searchVal);

            ResultSet rs = stmt.executeQuery();

            while (rs.next()) {
                tableModel.addRow(new Object[]{
                    rs.getInt(1)
                    ,rs.getString(2)
                    ,rs.getString(3)
                    ,rs.getDouble(4)
                    ,rs.getBoolean(5)
                });
            }

            conn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
}