HarrJ

Day 16 only create

Feb 18th, 2024
1,122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.27 KB | None | 0 0
  1. package week3;
  2.  
  3. import java.util.Scanner;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.PreparedStatement;
  7.  
  8. // using tbl_trainee_list from Day 12E, 13A file
  9. public class Day16D {
  10.     private String address = "jdbc:mysql://localhost:3306/db_jtvi_b8_23";
  11.     private String userName = "root";
  12.     private String passWord = "";
  13.    
  14.     public static void main(String[] args) {
  15.         Day16D callMe = new Day16D();
  16.         Scanner sc = new Scanner(System.in);
  17.         String fName, lName, email, phone;
  18.         int rowResult = 0;
  19.         // enter user info part
  20.         System.out.print("Enter first name : ");
  21.         fName = sc.nextLine();
  22.          
  23.         System.out.print("Enter last name : ");
  24.         lName = sc.nextLine();
  25.        
  26.         System.out.print("Enter email : ");
  27.         email = sc.nextLine();
  28.        
  29.         System.out.print("Enter phone : ");
  30.         phone = sc.nextLine();
  31.        
  32.         // execute sql query part
  33.         rowResult = callMe.addNewRow(fName, lName, email, phone);
  34.        
  35.         if (rowResult == 1) {
  36.             System.out.println("New Row Added");
  37.         } else {
  38.             System.out.println(rowResult + "row(s) affected");
  39.         }
  40.     }
  41.    
  42.     int addNewRow(String fName, String lName, String email, String phone) {
  43.         int rowsAffected = 0;
  44.         try {
  45.             Connection conn = DriverManager.getConnection(address, userName, passWord);
  46.             String sqlQuery = "INSERT INTO tbl_trainee_list"
  47.                 + " (fld_fname, fld_lname, fld_email, fld_phone)"
  48.                 + " VALUES (?, ?, ?, ?)";
  49.            
  50.             PreparedStatement stmt = conn.prepareStatement(sqlQuery);
  51.             stmt.setString(1, fName);
  52.             stmt.setString(2, lName);
  53.             stmt.setString(3, email);
  54.             stmt.setString(4, phone);
  55.            
  56.             rowsAffected = stmt.executeUpdate();
  57.            
  58.             conn.close();
  59.         } catch (Exception e) {
  60.             rowsAffected = -1;
  61.         }
  62.         return rowsAffected;
  63.     }
  64. }
  65.  
  66. //CREATE TABLE tbl_trainee_list ( fld_traineeid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, fld_fname VARCHAR(25), fld_lname VARCHAR(15), fld_email VARCHAR(40), fld_phone VARCHAR(16) NOT NULL DEFAULT 'to-follow');
Advertisement
Add Comment
Please, Sign In to add comment