/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

0 vote331 views1 answer
Get generic type of class at runtime
Java
22 votes347 views1 answer
Java how to stop code
Java
0 vote332 views1 answer
Jtable fill panel
Java
2 votes346 views1 answer
How can I put a parameter into a localized string in Android?
Java
0 vote395 views1 answer
Bukkit dev paid account
Java
1 vote323 views1 answer
Java calculate elapsedTime
Java
0 vote367 views1 answer
If you are using the git profile, you need to set a Git URI in your configuration. If you have set spring.cloud.config.server.bootstrap=true, you need to use a composite configuration.
Java
0 vote341 views1 answer
Java running sum
Java
3 votes358 views1 answer
Find first element of list java
Java
0 vote336 views1 answer
Java delete element from list
Java