Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%
- String co=request.getParameter("txtCodigo");
- int qt = Integer.parseInt(request.getParameter("txtQuantidade"));
- %>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>Prova JSP</title>
- </head>
- <body>
- <center><h1>Consulta de Produtos</h1></center>
- <%@ page import="java.sql.*" %>
- <%
- String pre;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost/prova","root","1q2w3e77");
- Statement st=con.createStatement();
- //st.execute("create table Produto(codigo int, nome varchar(40), preco double)");
- //st.execute("insert into Produto values(1,'queijo minas - kg',12.50)");
- ResultSet rs=st.executeQuery("select codigo,preco from Produto where codigo="+co);
- while (rs.next()) {
- //cod=rs.getString("codigo");
- pre=rs.getString("preco");
- %>
- <hr />
- Preço: <%=pre * qt%><br />
- <%
- }
- st.close();
- con.close();
- }
- catch (Exception e) {
- out.write("Erro: "+e.getMessage());
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement