/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

14 votes194 views2 answers
Java read next line
Java
0 vote225 views2 answers
Dialog getWindow().setBackgroundDrawable transparent
Java
1 vote179 views1 answer
Java stream collect to string
Java
2 votes217 views1 answer
Java if one sting on array match
Java
1 vote192 views1 answer
Jackson create object node from string
Java
1 vote233 views1 answer
Spring gradle don't build boot jar
Java Spring
0 vote233 views1 answer
POST method) in spring rest api
Java Spring
0 vote219 views1 answer
Java add constructor to enum
Java
-1 vote192 views1 answer
Devotional meaning
Java
0 vote190 views1 answer
Implementation 'com.facebook.fresco:animated-gif:2.0.0'
Java