--
Example of insert
- Get db connection to MySQL database
- Create a sql statement, using the Java PreparedStatement syntax.
- set the parameters values for the Java PreparedStatement object.
- execute sql insert
- close Java MySQL database connection.
- Catch any SQL exceptions that may come up during the process.
public void addStudent(Student theStudent) throws Exception {
Connection myConn = null;
PreparedStatement myStmt = null;
try {
// get db connection
myConn = dataSource.getConnection();
// create sql for insert
String sql = "insert into student "
+ "(first_name, last_name, email) "
+ "values (?, ?, ?)";
myStmt = myConn.prepareStatement(sql);
// set the param values for the student
myStmt.setString(1, theStudent.getFirstName());
myStmt.setString(2, theStudent.getLastName());
myStmt.setString(3, theStudent.getEmail());
// execute sql insert
myStmt.execute();
}
finally {
// clean up JDBC objects
close(myConn, myStmt, null);
}
}
Example of update
public void updateStudent(Student theStudent) throws Exception {
Connection myConn = null;
PreparedStatement myStmt = null;
try {
// get db connection
myConn = dataSource.getConnection();
// create SQL update statement
String sql = "update student "
+ "set first_name=?, last_name=?, email=? "
+ "where id=?";
// prepare statement
myStmt = myConn.prepareStatement(sql);
// set params
myStmt.setString(1, theStudent.getFirstName());
myStmt.setString(2, theStudent.getLastName());
myStmt.setString(3, theStudent.getEmail());
myStmt.setInt(4, theStudent.getId());
// execute SQL statement
myStmt.execute();
}
finally {
// clean up JDBC objects
close(myConn, myStmt, null);
}
}
--
Reference:
https://alvinalexander.com/java/java-mysql-insert-example-preparedstatement
http://www.codejava.net/java-se/jdbc/jdbc-tutorial-sql-insert-select-update-and-delete-examples
https://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html
