<%@page contentType="text/html"%>
<html>
<head><title>JSP Page</title></head>
<body>
<%-- <jsp:useBean id="beanInstanceName" scope="session"
class="package.class" /> --%>
<%-- <jsp:getProperty name="beanInstanceName" property="propertyName"
/> --%>
<FORM ACTION="inspage.jsp" METHOD="GET">
<TABLE>
<TR>
<TD>
<STRONG> COD </STRONG>
</TD>
<TD>
<%@page language="java" import="java.sql.*" %>
<% Connection dbconn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbconn=DriverManager.getConnection("jdbc:odbc:dbtry");
int codice=0;
int max=100;
String query=" SELECT MAX(COD) FROM Caffè ";
Statement select=dbconn.createStatement();
ResultSet rs = select.executeQuery(query);
while (rs.next())
{max=rs.getInt(1);
}
codice=max+1;
String Cod=new Integer(codice).toString();
%>
<INPUT TYPE="TEXT" name="COD" size="32" VALUE="<%=Cod%>"readonly>
</TD>
</TR>
<TR>
<TD>
<STRONG> NOME </STRONG>
</TD>
<TD>
<INPUT TYPE="TEXT" name="NOME" size="32" >
</TD>
</TR>
<TR>
<TD>
<STRONG> DESCRIZIONE </STRONG>
</TD>
<TD>
<INPUT TYPE="TEXT" name="DESCRIZIONE" size="32">
</TD>
</TR>
<TR>
<TD>
<STRONG> PREZZO </STRONG>
</TD>
<TD>
<INPUT TYPE="TEXT" name="PREZZO" size="32">
</TD>
</TR>
<TR>
<TD>
<STRONG> TOTALE VENDITE </STRONG>
</TD>
<TD>
<INPUT TYPE="TEXT" name="TOTALEVENDITE" size="32">
</TD>
</TR>
<TR>
<TD>
<INPUT TYPE="BUTTON" value="TORNA INDIETRO" >
</TD>
<TD>
<INPUT TYPE="SUBMIT" value="INSERISCI" size="400" width="400"
height="400" >
</TD>
<TD>
<INPUT TYPE="RESET" value="ANNULLA INSERIMENTO" >
</TD>
</TR>
</TABLE>
</FORM>
<% String richiesta=request.getQueryString();
java.util.Enumeration enum = request.getParameterNames();
while (enum.hasMoreElements()){
String name = (String) enum.nextElement();
String values[] = request.getParameterValues(name);
if (values != null) {
for (int i = 0; i < values.length; i++) {
if (values[i].equals("INSERISCI"))
{
int price=0;
int sales=0;
if (!request.getParameter("COD").equals(""))
try {
codice=Integer.parseInt(request.getParameter("COD"));}
catch (NumberFormatException e) {
codice = 0;
}
else codice=0;
if (request.getParameter("NOME").equals(""))
{%>
<jsp:forward page="/nomeerr.html"/>
<%}
else if (request.getParameter("DESCRIZIONE").equals(""))
{%>
<jsp:forward page="/descrerr.html"/>
<%}
else {if (!request.getParameter("PREZZO").equals(""))
try {
price=Integer.parseInt(request.getParameter("PREZZO"));}
catch (NumberFormatException e) {
price = 0;
}
else price=0;
if (!request.getParameter("TOTALEVENDITE").equals(""))
try {
sales=Integer.parseInt(request.getParameter("TOTALEVENDITE"));}
catch (NumberFormatException e) {
sales = 0;
}
else sales=0;
/* PreparedStatement instable= dbconn.prepareStatement("INSERT INTO
Caffè " + "VALUES(?,?,?,?,?)");
instable.setInt(1,new Integer(codice).intValue());
instable.setString(2,request.getParameter("NOME"));
instable.setString(3,request.getParameter("DESCRIZIONE"));
instable.setInt(4,new Integer(price).intValue());
instable.setInt(5,new Integer(sales).intValue());
instable.executeUpdate();*/
int esito;
String insert="INSERT INTO Caffè (COD, NOME, DESCRIZIONE, PREZZO,
TOTVENDITE) VALUES ("+new Integer(codice).intValue()+",
"+request.getParameter("NOME")+",
"+request.getParameter("DESCRIZIONE")+", "+new
Integer(price).intValue()+", "+new Integer(sales).intValue()+")";
esito=select.executeUpdate(insert);
//se esito è uguale a 1 tutto è andato bene
if (esito == 1)
{out.println("inserimento eseguito correttamente");
codice++;}
else
out.println("inserimento non eseguito");
}
}}}}%>
</body>
</html>
I use JSP with Tomcat 3.2. I have no error message, but insert is not
executed.
Hello from Francesco.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
