/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 vote271 views1 answer
Java create list integer range
Java
0 vote273 views1 answer
Missing artifact com.sun.jersey:jersey-servlet:jar:1.20-SNAPSHOT
Java
0 vote269 views1 answer
Tomcat allow remote access to manager
Java
0 vote283 views1 answer
Error: Could not find or load main class -Djava.library.path=.home.hdoop.hadoop-3.3.0.lib.native
Java
2 votes287 views1 answer
Intellij run java file
Java
0 vote291 views1 answer
Getindexrequest elasticsearch
Java
0 vote305 views1 answer
ChangeElementsOfHashMap
Java
2 votes279 views1 answer
Java folder of jar
Java
0 vote304 views1 answer
Java regex of eauations
Java
-1 vote265 views1 answer
Java 8 stream add to list
Java