%--
Document : busqueda
Created on : 31-may-2008, 12:45:30
Author : TiTo_VaSSi
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
JSP Page
<%@ page import="java.sql.*" %>
<%
int id=-1;
try{
Connection con=null;
Statement objSQL=null;
ResultSet res=null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/padel", "admin", "admin");
if(request.getParameter("idpro")!=""){
id= Integer.parseInt(""+request.getParameter("idpro"));
objSQL = con.createStatement();
res = objSQL.executeQuery("SELECT * FROM producto WHERE id='" +id+"'");
}
else{
objSQL = con.createStatement();
res = objSQL.executeQuery("SELECT * FROM producto");
}
String newPro=null;
String newPre=null;
String newMa=null;
String newDes=null;
String newSto=null;
%>
Id |
Nombre |
Marca |
Descripcion |
Stock |
Precio |
<%
int i=0;
while(res.next())
{
int id2;
id2=Integer.parseInt(""+res.getString("id"));
newPro = res.getString("nombre")+"";
newPre = res.getString("precio")+"";
newMa = res.getString("marca")+"";
newDes = res.getString("descripcion")+"";
newSto = res.getString("stock")+"";
%>
<%
i++;
}
%>
<%
con.close();
}catch(Exception e){
out.println("Error "+e);
}
%>