/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 vote182 views1 answer
Open bottomsheet from adapter java
Java
2 votes186 views3 answers
Java string to lower case
Java
3 votes179 views1 answer
How to learn java in one day
Java
1 vote181 views1 answer
Private properties in JavaScript ES6 classes
Java
0 vote213 views1 answer
Spring security default username
Java Spring
1 vote205 views1 answer
Sorting hashmap by key in java 8
Java
4 votes149 views1 answer
Disable button java
Java
-1 vote180 views1 answer
Devotional meaning
Java
0 vote180 views1 answer
In dom parser how to find processing instruction in java
Java
0 vote236 views2 answers
RecyclerView: No layout manager attached; skipping layout
Java