/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 vote226 views1 answer
Selet all elemnts
Java
2 votes238 views2 answers
How to split string in java android
Java
0 vote245 views1 answer
Youtube converter to mp3
Java
9 votes237 views3 answers
From date to string
Java
21 votes239 views2 answers
System.out.print
Java
0 vote238 views1 answer
Array srting line by line in textview android
Java
2 votes195 views1 answer
Android studio start another activity
Java
2 votes270 views2 answers
Array ausgeben java
Java
1 vote244 views1 answer
Java the local variable may not have been initialized
Java
5 votes234 views1 answer
Kotlin string contains integer
Java