/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

2 votes372 views2 answers
Clear an array list in java
Java
0 vote335 views1 answer
Java string split from input string
Java
0 vote359 views1 answer
Difference between maven plugin and dependency
Java
0 vote368 views1 answer
How to check number of messages in kafka topic
Java
0 vote359 views1 answer
Type mismatch cannot convert from string to string in java cucumber
Java
0 vote352 views2 answers
Quick way to get charAt
Java
0 vote361 views1 answer
For loop in java as long as array
Java
1 vote343 views1 answer
Spring security enable global cors
Java
0 vote613 views1 answer
Java.lang.NoSuchMethodError: org.apache.logging.log4j.spi.LoggerContextFactory.isClassLoaderDependent()Z after log4j update
Java
0 vote342 views1 answer
Labelled break statement in Java
Java