/Java/Jdbc insert example from input values

Jdbc insert example from input values

// 2. Create a statement
	String sql = "insert into employees "
			+ " (last_name, first_name)" + " values (?, ?)";
	myStmt = myConn.prepareStatement(sql);
	// set param values
	myStmt.setString(1, lastName);
	myStmt.setString(2, firstName);
	// 3. Execute SQL query
	myStmt.executeUpdate();

Jdbc insert example from input values

// 0. read user input from command line: last name, first name and email
Scanner scanner = new Scanner(System.in);

System.out.print("Enter your last name: ");
String lastName = scanner.nextLine();
System.out.print("Enter your first name: ");
String firstName = scanner.nextLine();

Source: luv2code.com

Similar codes

1 vote127 views1 answer
Stringjoiner stream java
Java
0 vote150 views1 answer
Pattern exercises for java
Java
0 vote146 views1 answer
Arraylist string to character java
Java
1 vote129 views1 answer
Android java increment hashmap value
Java
1 vote123 views1 answer
Java if or
Java
0 vote129 views1 answer
Given an int variable n that has already been declared and initialized to a positive value, use a do...while loop to print a single line consisting of n asterisks. Use no variables other than n.
Java
0 vote254 views1 answer
Final private vs private final
Java
0 vote164 views1 answer
What does setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE) is used for
Java
0 vote122 views1 answer
Android java random fragment on create
Java
0 vote185 views1 answer
Hash tree in java
Java