java servlet query with parameters from html form

Question

I am trying to create a servlet which can obtain the parameter of the drop down box in html and use this parameter to query a database.

my html:

<form action="servlet/currencyservlet">
<select>
<option name="usd">United States Dollar</option>
<option name="pounds">United Kingdom Sterling Pound</option>
</select>
<select>
<option name="cad">Canadian Dollars</option>
<option name="cny">Chinese Yuan</option>
</select>
<input type="submit" value="Check Rate"/>
</form>

my java:

...
...
...
conn = DriverManager.getConnect("jdbc:mysql://localhost:3306/currencydb", "root", "");
...
try{
string qstr = "SELECT source_currency, target_currency FROM currencytable WHERE????
}

"source_currency" can be "usd" or "pounds" where "target_currency" can be "cny" or "cad". My query wishes to extract the exchange rate from the "currencytable" and display result in the servlet. How do I parse the parameters of the drop down boxes?

JB Nizet · Accepted Answer · 2011-11-27 10:28:23Z

3

Your select boxes should have a name. This name is also the name of the HTTP parameter sent when submitting the form:

<select name="sourceCurrency">
...
</select>
<select name="targetCurrency">
...
</select>

In your servlet, you'll get the source and target currencies with getParameter:

String sourceCurrency = request.getParameter("sourceCurrency");
String targetCurrency = request.getParameter("targetCurrency");

And you may then pass those values to your query, using a prepared statement:

String sql = "SELECT exchange_rate FROM currencytable WHERE source_currency = ? and target_currency = ?";
PreparedStatement stmt = connection.prepareStatement(sql);
stmt.setString(1, sourceCurrency);
stmt.setString(2, targetCurrency);
ResultSet rs = stmt.executeQuery();

answered Nov 27, 2011 at 10:28

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

exxcellent Over a year ago

hi, what should be the parameters for "?"?

JB Nizet Over a year ago

Read the code: the first parameter is set with stmt.setString(1, sourceCurrency), and the second is set with stmt.setString(2, targetCurrency). Read docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html

Collectives™ on Stack Overflow

java servlet query with parameters from html form

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related