/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

12 votes306 views3 answers
Smart ways to print a matrix in java
Java
6 votes311 views6 answers
Binary Search Algorithm
Java
0 vote269 views2 answers
How to format numbers in java
Java
0 vote298 views1 answer
New date api in java 8
Java
1 vote270 views1 answer
Attempt to invoke virtual method 'int java.util.Random.nextInt(int)' on a null object reference
Java
3 votes351 views2 answers
Java ArrayList copy
Java
7 votes296 views2 answers
Print list array
Java
0 vote290 views1 answer
Read properties file outside jar java
Java
29 votes313 views6 answers
Remove first character from string
Java
0 vote265 views2 answers
Https://github.com/nuxt/nuxt.js/issues/8315#:~:text=%3Chtml%20lang%3D%22ru%22%20data%2Dn%2Dhead%3D%22%257B%2522lang%2522%3A%257B%2522ssr%2522%3A%2522ru%2522%257D%257D%22%3E
Java