/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 vote257 views1 answer
Java print 2d char array
Java
7 votes174 views1 answer
Java.lang.IndexOutOfBoundsException: Index: 1, Size: 0 at java.util.ArrayList.add(ArrayList.java:483)
Java
0 vote204 views1 answer
How to draw Bezier Curve in Android
Java
5 votes171 views3 answers
Java find duplicates in array
Java
0 vote223 views1 answer
Kkih
Java
0 vote186 views2 answers
Java completablefuture chain 2 operations
Java
4 votes176 views2 answers
Android copy text to clipboard programmatically
Java
1 vote154 views1 answer
System.out.write in java example
Java
0 vote169 views1 answer
Unparseable date android
Java
0 vote164 views1 answer
Android studio space
Java