/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 vote235 views1 answer
Cannot find symbol iterator in java
Java
0 vote239 views1 answer
Java regex of eauations
Java
2 votes203 views1 answer
Get the first Monday of a month in Java
Java
6 votes205 views3 answers
Minecraft mod
Java
0 vote223 views1 answer
No such file or directory: 'h1.txt'
Java
0 vote213 views1 answer
Develop the Java application called Shapes. For this program, use only for loops and the following print statements below to generate the shapes below:
Java
0 vote214 views1 answer
Spring aop xml definition
Java
3 votes246 views2 answers
Int to byte calculator
Java
1 vote214 views3 answers
Java take and save screenshot
Java
0 vote264 views1 answer
Itext new page
Java