/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 vote256 views4 answers
Get last day of month java
Java
0 vote223 views1 answer
Jax-RS path annotation
Java
0 vote185 views1 answer
Java for increment by 2
Java
29 votes224 views5 answers
String reverse in java
Java
0 vote193 views1 answer
Foreign keys in json
Java
4 votes198 views2 answers
Java read each lines in file
Java
2 votes194 views2 answers
How to navigate to last back stack in android studio
Java
0 vote191 views1 answer
How to validate email java
Java
5 votes208 views1 answer
How to configure alternative openjdk
Java
0 vote187 views1 answer
Java show error dialog
Java