/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 vote303 views1 answer
Java coalesce
Java
0 vote336 views1 answer
Java iterate map and remove
Java
0 vote330 views1 answer
Near "@gmail": syntax error
Java
2 votes317 views1 answer
What is an error in Java
Java
1 vote346 views4 answers
Finding min and max from given number in java
Java
0 vote325 views1 answer
How to set opacity of background android
Java
58 votes265 views8 answers
Array with java
Java
0 vote451 views1 answer
Spring data sql not utf8
Java Spring
1 vote375 views1 answer
Bigdecimal to string
Java
0 vote307 views1 answer
Java program to find the sum of first 100 numbers
Java