/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 vote100 views1 answer
Create object and call method in java
Java
1 vote115 views1 answer
Java discord bot get id of message it just sent
Java
-1 vote117 views1 answer
MapToString in java
Java
0 vote117 views1 answer
How to sum a 2d array in java
Java
0 vote136 views1 answer
Java page setup
Java
0 vote129 views1 answer
Thymeleaf spring boot dependency for mail
Java Spring
0 vote128 views1 answer
Clear jtable rows java
Java
6 votes122 views1 answer
How to clear stringbuilder in java
Java
0 vote102 views1 answer
Regex double quote java
Java
0 vote120 views1 answer
Nikita kaksharov
Java