/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 vote265 views1 answer
Sort array<entry> float android studio
Java
1 vote258 views1 answer
Java isolate the numbers from string
Java
0 vote293 views1 answer
Java timeout
Java
0 vote294 views1 answer
Execute a multi line shell comand in java
Java
0 vote288 views3 answers
How to make a java main menu loop after using a case
Java
0 vote272 views1 answer
ArrayList<HashMap<String, String>> arrayList = new ArrayList<>()
Java
90 votes369 views6 answers
Java split string
Java
0 vote257 views1 answer
Processing - Save n number of frames
Java
0 vote250 views1 answer
Sprint jpa properties for application.yml
Java
14 votes327 views2 answers
Java string next line
Java