/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 vote303 views1 answer
Java jackson cast to list
Java
1 vote291 views1 answer
Context error in android studio
Java
0 vote301 views1 answer
App not showing in share menu android
Java
11 votes256 views3 answers
Iterate enum java
Java
-2 votes305 views1 answer
Style jbuttons
Java
0 vote310 views1 answer
What went wrong: Execution failed for task ':app:processDebugMainManifest'. > Unable to make field private final java.lang.String java.io.File.path accessible: module java.base does not "opens java.io" to unnamed module @1ce90e66
Java
3 votes268 views1 answer
Collections reverse on java
Java
0 vote305 views1 answer
For each loop java string array
Java
0 vote321 views1 answer
Force_dark_auto android webview
Java
0 vote307 views1 answer
Terminate function calling in java
Java