/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 vote142 views1 answer
Javafx line chaart duplicate series added
Java
0 vote107 views1 answer
/= java
Java
0 vote108 views1 answer
Java Maven Using platform encoding (UTF-8 actually) to read mojo metadata, i.e. build is platform dependent!
Java
8 votes99 views1 answer
How to get float value in json java
Java
9 votes116 views1 answer
How to change a character in a string in java with ascii
Java
3 votes104 views1 answer
Konnichiwa in japanese
Java
0 vote105 views1 answer
Get string of radio button in android
Java
1 vote121 views1 answer
Javafx textarea new line with shift+enter
Java
8 votes102 views1 answer
Alertdialog show in android
Java
2 votes111 views1 answer
Decimal up to 6 places in java
Java