/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 votes186 views1 answer
Extend vs implement in java
Java
9 votes270 views2 answers
Arraylist vs vector in java
Java
0 vote215 views2 answers
Android listen to network change
Java
0 vote199 views1 answer
Grepper editor
Java
11 votes189 views9 answers
Android Studio
Java
119 votes344 views4 answers
How to use scanner class in java
Java
1 vote193 views1 answer
RemoveAll hard code
Java
1 vote271 views1 answer
How to change the icon of a jframe
Java
3 votes213 views1 answer
How to check if a char is a letter java
Java
0 vote200 views1 answer
Create embeds jda discord
Java