import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Cadastro2 extends HttpServlet
{
Connection con=null;
String url= "jdbc:odbc:BANCO";
public void init(ServletConfig s) throws ServletException {
super.init(s);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url);
}
catch (Exception e){
System.out.println(e);
}
}
public void destroy (){
try {
con.close();
}
catch (Exception e){}
}
public void service (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
String sql = "";
String nome=request.getParameter("Nome");
String estado=request.getParameter("Estado");
String sexo=request.getParameter("Sexo");
String socio=request.getParameter("Socio");
String email=request.getParameter("recipient");
try {
Statement st = con.createStatement();
sql = "INSERT INTO cadastro Values(";
sql += "'"+nome+"',";
sql += "'"+estado+"',";
sql += "'"+sexo+"',";
sql += "'"+socio+"',";
sql += "'"+email+"')";
st.executeUpdate(sql);
PrintWriter out=null;
response.setContentType("text/html");
out = response.getWriter();
out.println("");
out.println("");
out.println(" Cadastro de Funcionários ");
out.println("");
out.println("");
out.println(" CADASTRO OK
");
out.println("Consulta");
out.println("");
out.println("");
out.close();
}catch(Exception e){
System.out.println(e);
}
}
}