Hi,
I am dummie with java programming, and I'm trying to compile my first
servlet but i got some errores, would anybody give me some help?
I'm trying to compile this servlet, but the compiler is reporting that there
is a missing therm in line 10 ("public void doPost....) and ';' expected in
the same line. What must I do?
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class InsContactenos extends HttpServlet
{
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException,IOException{
protected String dbURL = "jdbc:odbc:orclx07";
protected String dbuserID = "xxx";
protected String dbpasswd = "xxx";
protected Connection dbConnection;
String Fecha_Recibo = req.getParameter("Fecha_Recibo");
String Email_Origen = req.getParameter("Email_Origen");
String Destinatario = req.getParameter("Destinatario");
String Asunto = req.getParameter("Asunto");
String Cc = req.getParameter("Cc");
String Texto = req.getParameter("Texto");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//dbConnection = DriverManager.getConnection(dbURL, dbuserID
,dbpasswd );
dbConnection =
DriverManager.getConnection("jdbc:oracle:oci:solutech/solutech@orclx07");
Statement stmt = dbConnection.createStatement();
String sql= "INSERT INTO bdct_conepros (FECHRECI, EMAILORIG,
EMAILDEST, ASUNCONE, COPICONE, DATAMENS, FECHRESP, DATARESP) VALUES ('" +
Fecha_Recibo + "', '" + Email_Origen +"', '" + Destinatario + "', '" +
Asunto + "', '" + Cc + "','" + Texto + "', ' ', ' ', ' '";
ResultSet rs = stmt.executeQuery(sql);
stmt.close();
dbConnection.close();
}
}
___________________________________________________________________________
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
