Day 24

package day23;

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Scanner;

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

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        RentListCRUD callMe = new RentListCRUD();
        String fName;
        String address;
        String dateRented;
        String payStat;
        String approver;
        double dPay;
        int vid;

        try {
            System.out.println("New rent record:");
            System.out.print("Name: ");
            fName = sc.nextLine();
            System.out.print("Address: ");
            address = sc.nextLine();
            System.out.print("Date Rented(YYYY-MM-DD): ");
            dateRented = sc.nextLine();
            System.out.print("Payment Status: ");
            payStat = sc.nextLine();
            System.out.print("Approve by: ");
            approver = sc.nextLine();
            System.out.print("Downpayment: ");
            dPay = sc.nextDouble();
            sc.nextLine();
            System.out.print("Vehicle ID: ");
            vid = sc.nextInt();
            sc.nextLine();

            int rowsAffected = callMe.addNewTransaction(fName, address, dateRented, payStat, approver, dPay, vid);
            if (rowsAffected == 1) {
                System.out.println("Rental Recorded");
            }
        } catch (Exception e) {
            System.out.println("Error in command");
        }
    }

    public int addNewTransaction(String fName, String address, String dateRented
        , String payStat, String approver, double dPay, int vid) {
        int rowsAffected = 0;


        String sqlQuery = "INSERT INTO tbl_test_ (cx_fname, cx_address"
                + ", date_rented, payment_status"
                + ", approved_by, downpayment, vehicle_id)"
                + " VALUES (?,?,?,?,?,?,?)";

        try {
            Date convDate = new SimpleDateFormat("YYYY-MM-dd").parse(dateRented);
            java.sql.Date sqlDate1 = new java.sql.Date(convDate.getTime());
            System.out.println(sqlDate1.toString());
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setString(1, fName);
            stmt.setString(2, address);
            stmt.setDate(3, sqlDate1);
            stmt.setString(4, payStat);
            stmt.setString(5, approver);
            stmt.setDouble(6, dPay);
            stmt.setInt(7, vid);

            rowsAffected = stmt.executeUpdate();

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

        return rowsAffected;
    }



/*INSERT INTO tbl_test_ (cx_fname,cx_address,date_rented,payment_status,approved_by,downpayment,vehicle_id)*/
}