Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Page tree

Skip to end of banner Go to start of banner

Parameterized SQL Statements

Skip to end of metadata

Created by Sherif Koussa on 2015-01-09

Go to start of metadata

Example:

String selectStatement = “SELECT account_balance FROM user_data WHERE user_name = ? “;
PreparedStatement prepStmt = con.prepareStatement(selectStatement);
prepStmt.setString(1, request.getParameter(“customerName”));
ResultSet rs = prepStmt.executeQuery();

No labels

Feedback on this page? Questions?

Visit OpenMRS Talk, our community discussion hub.

Copyright © 2004-2016 OpenMRS Inc. By using this site, you agree to the OpenMRS Privacy Policy.
Text is available under the Creative Commons 4.0 International Attribution License (CC BY 4.0).
Software is available under the Mozilla Public License 2.0 with Healthcare Disclaimer (MPL 2.0 HD).
"OpenMRS" is a registered trademark and the OpenMRS graphic logo is a trademark of OpenMRS Inc.