mysql preparedstatement insert_Java MySQL prepareStatement

--

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);

}

}