Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package week3;
- import java.util.Scanner;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- // using tbl_trainee_list from Day 12E, 13A file
- public class Day16D {
- private String address = "jdbc:mysql://localhost:3306/db_jtvi_b8_23";
- private String userName = "root";
- private String passWord = "";
- public static void main(String[] args) {
- Day16D callMe = new Day16D();
- Scanner sc = new Scanner(System.in);
- String fName, lName, email, phone;
- int rowResult = 0;
- // enter user info part
- System.out.print("Enter first name : ");
- fName = sc.nextLine();
- System.out.print("Enter last name : ");
- lName = sc.nextLine();
- System.out.print("Enter email : ");
- email = sc.nextLine();
- System.out.print("Enter phone : ");
- phone = sc.nextLine();
- // execute sql query part
- rowResult = callMe.addNewRow(fName, lName, email, phone);
- if (rowResult == 1) {
- System.out.println("New Row Added");
- } else {
- System.out.println(rowResult + "row(s) affected");
- }
- }
- int addNewRow(String fName, String lName, String email, String phone) {
- int rowsAffected = 0;
- try {
- Connection conn = DriverManager.getConnection(address, userName, passWord);
- String sqlQuery = "INSERT INTO tbl_trainee_list"
- + " (fld_fname, fld_lname, fld_email, fld_phone)"
- + " VALUES (?, ?, ?, ?)";
- PreparedStatement stmt = conn.prepareStatement(sqlQuery);
- stmt.setString(1, fName);
- stmt.setString(2, lName);
- stmt.setString(3, email);
- stmt.setString(4, phone);
- rowsAffected = stmt.executeUpdate();
- conn.close();
- } catch (Exception e) {
- rowsAffected = -1;
- }
- return rowsAffected;
- }
- }
- //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