Hall of Fame

1. Kuldeepc...181,287
2. objects145,195
3. MuraliKanth131,666
4. rrz@87...104,038
5. CEHJ87,637
6. mrcoffee...85,801
7. dravidnsr55,520
8. a_b47,010
9. gibu_geo...44,153
10. mwvisa125,028
11. basav_com20,314
12. logudotcom18,980
13. karanw18,545
14. TomasHelgi18,140
15. Christofer...16,425
16. ioanton16,220
17. mplungjan15,910
18. mahome14,570
19. Ravi_Kalla14,485
20. kadaba13,702
21. bluebelldis...13,374
22. mrjoltcola11,680
23. jim_cakalic9,780
24. boonleng9,200
25. ksivananth9,125

1. bloodredsun1,155,574
2. objects799,909
3. rrz@87...656,909
4. TimYates610,346
5. Kuldeepc...588,974
6. kennethxu357,436
7. mrcoffee...346,617
8. boonleng220,840
9. jaggernat197,407
10. CEHJ192,439
11. fargo190,519
12. actonwang189,622
13. MuraliKanth157,391
14. suprapto45155,308
15. cheekycj109,407
16. karanw98,012
17. shivaspk83,767
18. sompol_k...77,717
19. jarasa72,005
20. jimmack67,806
21. TomasHelgi67,320
22. mayankea...67,068
23. gibu_geo...64,853
24. ldbkutty64,200
25. radarsh63,756

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.8

writing to a database

Asked by pigmentarts in Java Server Pages (JSP)

can anyone help me put here?

need to get the product out of the bean tp write to me database. email and id are the only items not in the bean which come via the posting page..

full code, sorry its long any help please...

<%
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Software Foundation/Tomcat 5.5/webapps/ROOT/JWWW/78198uq/oatcakes.mdb");
Statement statement = conn.createStatement();

Enumeration parameters = request.getParameterNames();
if(parameters.hasMoreElements()) {

String memberidPram1 = request.getParameter("memberid")!= null ? request.getParameter("memberid") : "";
String emailPram1 = request.getParameter("email")!= null ? request.getParameter("email") : "";
String namePram1 = request.getParameter("name")!= null ? request.getParameter("name") : "";
String addressPram1 = request.getParameter("address")!= null ? request.getParameter("address") : "";

PreparedStatement stmt = con.prepareStatement("INSERT INTO orders (orderID, emailaddress, item, price, qty) VALUES (?, ?, ?, ?, ?)");

while(products.hasMoreElements())
{

stmt.setInt(1, product.getId());
stmt.setString(2, emailPram1);
stmt.setInt(3, product.getItem());
stmt.setInt(4,product.getPrice() );
stmt.setInt(5, product.getQty());
stmt.addBatch();

}

}



      %>

stuff
<%
if (statement != null)
statement.close();
if (conn != null)
conn.close();
}
catch (Exception e) {out.print(e);}
%>

Get your answer NOW

20091111-EE-VQP-89

writing to a database

Asked by pigmentarts in Java Server Pages (JSP)

About this solution