Galera,
estou fazendo um cadastro com duas opçoes, na página JSP fica a parte html onde tem a opção para selecionar a opção e essa página chama um servlet, até aí tudo bem, tudo fundiona, mas no Servlet, como fazer para que a opção escolhida pelo o usuário seja onde vai fazer o cadastro, segue abaixo o código no Servlet:
import javax.servlet.*;
import javax.servlet.http.*;
import org.gjt.mm.mysql.Connection;
import java.io.*;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class CadastraLeilao extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
}
private void sendLoginForm(HttpServletResponse response)
throws ServletException, IOException {
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
String judicial = request.getParameter("judicial");
String extrajudicial = request.getParameter("extrajudicial");
String data = request.getParameter("data");
String horario = request.getParameter("horario");
String local = request.getParameter("local");
String descricao = request.getParameter("descricao");
if (cadastra(data, horario, local, descricao)) {
RequestDispatcher rd =
request.getRequestDispatcher("/cadastroLeilaoSucesso.jsp");
rd.forward(request, response);
}
else {
RequestDispatcher rd =
request.getRequestDispatcher("/cadastroLeilaoErro.jsp");
rd.forward(request, response);
}
}
boolean cadastra(String data, String horario, String local, String descricao) {
Connection con;
Statement st;
try {
String driverName = "org.gjt.mm.mysql.Driver";
Class.forName(driverName);
con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/leilao","root","");
st = con.createStatement();
if("judicial")
String sql1 = "INSERT INTO judicial (Data, Horario, Local, Descricao) values('"+data+"','"+horario+"','"+local+"','"+descricao+"')";
else
String sql = "INSERT INTO extrajudicial (Data, Horario, Local, Descricao) values('"+data+"','"+horario+"','"+local+"','"+descricao+"')";
int status1 = st.executeUpdate(sql1);
int status2 = st.executeUpdate(sql);
st.close();
con.close();
return true;
}
catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
catch (SQLException e) {
System.out.println(e.toString());
}
catch (Exception e) {
System.out.println(e.toString());
}
return false;
}
}
tambem segue o código do JSP para darem uma olhada:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="756" border="0">
<!--DWLayoutTable-->
<tr>
<td colspan="2" bgcolor="#CCCCCC"><p align="center"><img src="images/tela05_01.gif" width="750" height="71"></p></td>
</tr>
<tr bgcolor="#000099">
<td colspan="2"><div align="right"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>&nbsp;Logado
agora: Adriano</strong></font></div></td>
</tr>
<tr bgcolor="#000099">
<td colspan="2"><div align="right">
<p><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Sair
do Sistema</strong></font></p>
</div></td>
</tr>
<tr bgcolor="616263">
<td colspan="2"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>&Aacute;rea
Administrativa</strong></font></td>
</tr>
<tr>
<td width="156" rowspan="10" valign="top" bgcolor="A3A4A5"><img src="Imagens/menu_adm.jpg" width="157" height="310"></td>
<td width="590" height="18" align="left" valign="top" bgcolor="A3A4A5"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cadastro
de leil&otilde;es - (*) campos obrigat&oacute;rios</font></strong></td>
</tr>
<tr>
<td height="14" align="left" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Tipo:
<select name="select">
<option selected>Selecione</option>
<option value="Judicial" name="judicial">Judicial</option>
<option value="Extra" name="extrajudicial">Extrajudicial</option>
</select>
<em><font size="1">(*)</font></em> </font></td>
</tr>
<tr>
<td height="6" align="left" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Data:
<input type="text" name="data">
(dd/mm/aaaa) <em><font size="1">(*)</font></em></font></td>
</tr>
<tr>
<td height="22" align="left" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Hor&aacute;rio:
<input type="text" name="horario">
(1430) <em><font size="1">(*)</font></em></font></td>
</tr>
<tr>
<td height="22" align="left" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Local:
<input type="text" name="local">
<em><font size="1">(*)</font></em></font></td>
</tr>
<tr>
<td height="19" align="left" valign="top"><div align="left"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif">Descri&ccedil;&atilde;o:<br>
<textarea name="descricao"></textarea>
</font></font></div></td>
</tr>
<tr>
<td height="12"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Inserir
Edital:<em><font size="1">(* - Formato .PDF)</font></em><br>
<input type="text" name="textfield4">
<input type="submit" name="Submit" value="Submit">
</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Inserir Foto:<br>
<input type="text" name="textfield5">
<input type="submit" name="Submit2" value="Submit">
<br>
<input type="text" name="textfield6">
<input type="submit" name="Submit3" value="Submit">
<br>
<input type="text" name="textfield7">
<input type="submit" name="Submit4" value="Submit">
<br>
<input type="text" name="textfield8">
<input type="submit" name="Submit5" value="Submit">
</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td align="left" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="Submit6" value="Cadastrar">
<input type="submit" name="Submit7" value="Limpar">
</font></td>
</tr>
</table>
</body>
</html>
Quem puder me ajudar, agradeço.
[size=“9”][color=“green”]*Editado para adicionar o BBCode - Facilita a visualização do código postado;)[/color][/size]