updatecar.java

JDBC Book Code Examples

import java.sql.*;

public class UpdateCar {

	public static void UpdateCarNum(int carNo, int empNo) throws SQLException {
		Connection con = null;
		PreparedStatement pstmt = null;

		try {
			con = DriverManager.getConnection("jdbc:default:connection");

			pstmt = con.prepareStatement(
			  "UPDATE EMPLOYEES SET CAR_NUMBER = ? WHERE EMPLOYEE_NUMBER = ?");
			pstmt.setInt(1, carNo);
			pstmt.setInt(2, empNo);
			pstmt.executeUpdate();
		}
		finally {
			if (pstmt != null) pstmt.close();
		}
	}
}