import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class DatabaseServlet extends HttpServlet implements SingleThreadModel {
private String URL = "jdbc:odbc:MagicShop";
private String username = "";
private String password = "";
private String choice;
private String item;
private int price;
private boolean flag;
private Statement stmt = null;
private Connection con=null;
private ResultSet result;
public void doPost (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
choice = request.getParameter("Plusses") + request.getParameter("Special") + request.getParameter("Type");
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
return;
}
stmt = null;
con=null;
try {
con = DriverManager.getConnection (URL,username,password);
stmt = con.createStatement();
}
catch (Exception e) {
System.err.println("problems connecting to "+URL);
}
try {
result = stmt.executeQuery("SELECT Item, Description, Price FROM Inventory;");
flag = true;
response.setContentType("text/html");
PrintWriter out = response.getWriter();
while(result.next()) {
item = result.getString("Item").trim();
price = result.getInt("Price");
if(choice.equals(item)) {
flag = false;
out.println("" +
"" + item + "" +
"" + item + "
Price: " + price +
" Gold Pieces
" +
"");
}
}
if(flag) {
out.println("Error" +
"Record Not Found!
" + choice + "
");
}
out.close();
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}