hello friend...
i hv a code for storin data in the database...
u can try this...
this code is fr JDBC ....
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.net.*;
public class Test2db extends HttpServlet
{
Connection theConnection;
private ServletConfig config;
public void init(ServletConfig config)
throws ServletException
{
this.config=config;
}
public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
PrintWriter out = response.getWriter ();
String first, email,site;
first = (String)request.getParameter ("first");
email = (String)request.getParameter ("email");
site = (String)request.getParameter ("site");
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
theConnection = DriverManager.getConnection("jdbc:odbc:SUSCET");
Statement theStatement=theConnection.createStatement();
ResultSet theResult=theStatement.executeQuery("insert into emaillists values("+"'"+first +"'," +"'"+ email +"'," +"'" +site+"'" +")");
out.println ("");
theResult.close();//Close the result set
theStatement.close();//Close statement
theConnection.close(); //Close database Connection
}
catch(Exception e)
{
out.println(e.getMessage());
}
out.println("<html>");
out.println("<head>");
out.println("<title>Input Servlet Test</title>");
out.println("</head>");
out.println("<body bgColor=blanchedalmond text=#008000 topMargin=0>");
out.println("<form method='POST' action='../servlet/email1db'>");
out.println("<div align='Center'>");
out.println("<br>");
out.println("<big>");
out.println("Your Data has been stored in database successfully");
out.println("<br>");
out.println("<br>");
out.println("<br>");
out.println("<pre>");
out.println("Click here to see the database");
out.println("</pre>");
out.println("<big>");
out.println("</div>");
out.println("<br>");
out.println("<div align='Center'>");
out.println("<INPUT TYPE='submit' name='Submit' value='Click Here'>");
out.println("</div>");
out.println("</form>");
out.println("</body>");
out.println("</html>");
}
}
u can try this code ...
attach a file and save it in the databas
