Alguem pode ma ajudar eu montei o código mas nao ta salvando no banco de dados... e nao sei mais oq pode ser...
WEB-XML
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name> Sistema de OS - Intranet</display-name>
<listener>
<listener-class>conexao.BD</listener-class>
</listener>
<listener>
<listener-class>Cadastroos</listener-class>
</listener>
<listener>
<listener-class>UpdateCadastroos</listener-class>
</listener>
<servlet>
<servlet-name>Cadastroos</servlet-name>
<servlet-class>Cadastroos</servlet-class>
</servlet>
<servlet>
<servlet-name>UpdateCadastroos</servlet-name>
<servlet-class>UpdateCadastroos</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Cadastroos</servlet-name>
<url-pattern>/servlet/Cadastroos</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>UpdateCadastroos</servlet-name>
<url-pattern>/servlet/UpdateCadastroos</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
<welcome-file>
index.html
</welcome-file>
<welcome-file>
index.htm
</welcome-file>
</welcome-file-list>
</web-app>
Cadastroos.JSP
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head>
<title>.: Cadastro de chamadas :.</title>
<meta http-equiv="Content-Type" content="text/html;">
<!--Fireworks MX 2004 Dreamweaver MX 2004 target. Created Wed Jul 27 12:19:51 GMT-0300 (Hora oficial do Brasil) 2005-->
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif}
.style2 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style3 {font-size: 12px}
-->
</style>
</head>
<body bgcolor="#ffffff">
<img src="logofinal.gif" width="250" height="83"><br>
<table border="0" cellpadding="0" cellspacing="0" width="716">
<!-- fwtable fwsrc="base.png" fwbase="base.gif" fwstyle="Dreamweaver" fwdocid = "[telefone removido]" fwnested="0" -->
<tr>
<td><img src="spacer.gif" width="27" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="661" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="28" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="1" border="0" alt=""></td>
</tr>
<tr>
<td colspan="3"><img name="base_r1_c1" src="base_r1_c1.gif" width="716" height="15" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="15" border="0" alt=""></td>
</tr>
<tr>
<td rowspan="2"><img name="base_r2_c1" src="base_r2_c1.gif" width="27" height="689" border="0" alt=""></td>
<td valign="top" bgcolor="#C9CBE7"><table width="631" height="626" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="626"><img src="areademembros.gif" width="184" height="22">
<FORM NAME="frm" method="POST">
<table width="630" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="75"><span class="style1">Numero</span></td>
<td width="144"><span class="style1">
<input name="Numero" type="text" id="Numero2">
</span></td>
<td colspan="2"><span class="style1">Tipo de serviço
<select name="Tipo serviço" id="select">
<option>Hardware</option>
<option>Software</option>
<option>Protheus</option>
</select>
</span></td>
</tr>
<tr>
<td><span class="style1">Solicitante</span></td>
<td><span class="style1">
<input name="Soilicitante" type="text" id="Solic">
</span></td>
<td width="405"><span class="style1">Depto:
<select name="Depto" id="select2">
<option>Acabamento</option>
<option selected>Almoxarifado</option>
<option>Bahia</option>
<option>Compras</option>
<option>contabilidade</option>
<option>Controladoria</option>
<option>Diretoria</option>
<option>Engenharia</option>
<option>Expedição</option>
<option>Extrusão</option>
<option>Faturamento</option>
<option>Ferramentaria</option>
<option>Financeiro</option>
<option>Indústrial</option>
<option>Laboratório</option>
<option>Manutenção</option>
<option>Mistura</option>
<option>PCP</option>
<option>Qualidade</option>
<option>Recebimento</option>
<option>RH</option>
<option>Sistemas</option>
<option>Vendas</option>
</select>
Data:
<input name="Data" type="text" id="Data2" size="10" maxlength="10">
Hora:
<input name="hora" type="text" id="hora5" size="5" maxlength="5">
</span></td>
<td width="6"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td><span class="style1">Atividade</span></td>
<td colspan="3"><span class="style1">
<input name="textfield" type="text" size="70" maxlength="70">
</span></td>
</tr>
</table>
<p class="style1">Observações:<br>
<textarea name="OBS" cols="50" rows="5" id="OBS"></textarea>
<br>
<br>
Descrição da Solução :<br>
<textarea name="descrição" cols="50" rows="3" id="descrição"></textarea>
</p>
<table width="630" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td><table width="629" height="141" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="style1">Hora de inicio: </span></td>
<td><input name="hora2" type="text" id="hora3" size="10" maxlength="6"></td>
<td width="71"><span class="style1">Hora fim: </span></td>
<td width="74"><input name="hora3" type="text" id="hora4" size="10" maxlength="6"></td>
<td width="199"><span class="style1">HGasta:
<input name="data" type="text" id="data7" size="10" maxlength="10">
</span></td>
<td width="112" rowspan="4" valign="top"><table width="112" height="105" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="middle">
<td width="56"><img src="setabaxo.gif" width="56" height="56"></td>
<td width="56"><img src="setacima.gif" width="56" height="56"></td>
</tr>
<tr align="center" valign="middle">
<td><img src="setaesq.gif" width="56" height="56"></td>
<td><img src="setadir.gif" width="56" height="56"></td>
</tr>
</table></td>
</tr>
<tr>
<td><span class="style1">Data de inicio : </span></td>
<td><input name="data2" type="text" id="data23" size="10" maxlength="10"></td>
<td><span class="style1">Data fim: </span></td>
<td><input name="data3" type="text" id="data32" size="10" maxlength="10"></td>
<td><span class="style1">Ramal:</span></td>
</tr>
<tr>
<td width="110"><span class="style1">Prazo: </span></td>
<td width="63"><input name="prazo" type="text" id="prazo2" size="10" maxlength="10"></td>
<td><span class="style1">Status %: </span></td>
<td><input name="porcento" type="text" id="porcento" size="10" maxlength="4"></td>
<td><p class="style1">
<label>
<span class="style3">
<input name="status" type="radio" value="concluido" checked>
Concluido</span></label>
<span class="style3">
<label>
<input type="radio" name="status" value="aberto">
Em aberto</label>
</span><br>
</p></td>
</tr>
<tr>
<td height="36"><input name="Button" type="button" value="Ordem"></td>
<td><input name="ordem" type="text" id="prazo3" size="10" maxlength="10"></td>
<td colspan="2"><span class="style1"></span></td>
<td><span class="style1"></span></td>
</tr>
</table></td>
</tr>
</table>
<table width="630" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="630" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="84"><div align="center" class="style1">Técnico</div></td>
<td width="56" rowspan="2"><div align="center" class="style2"><img src="exibir.gif" width="56" height="56"></div> </td>
<td width="102" rowspan="2"><div align="center"><img src="pesquisar.gif" width="93" height="56"></div></td>
<td width="56" rowspan="2"><div align="center" class="style2"></div>
<div align="center"> <a href="#" onclick="JavaScript:cad()"> <img src="gravar.gif" width="56" height="56"></a></div></td>
<td width="65" rowspan="2"><div align="center" class="style2"></div> <div align="center"><a href="Cadastroosalterado.jsp"><img src="ok.gif" width="56" height="56"></a></div></td>
<td width="56" rowspan="2"><div align="center" class="style2"></div> <div align="center"><img src="excluir.gif" width="56" height="56"></div></td>
<td width="66" rowspan="2"><div align="center" class="style2"></div> <div align="center"><img src="novoregistro.gif" width="56" height="56"></div></td>
<td width="78" rowspan="2"><div align="center"><img src="imprimir.gif" width="78" height="55"></div></td>
<td width="67" rowspan="2"><div align="center" class="style2"></div> <div align="center"><img src="sair.gif" width="56" height="56"></div></td>
</tr>
<tr>
<td height="39"><div align="center">
<select name="select">
<option>Bruno</option>
<option>Eduardo</option>
<option>Fábio</option>
<option>Felipe</option>
<option>Francisco</option>
<option>Rafael</option>
</select>
</div></td>
</tr>
</table>
</td></tr>
</table></td>
<td rowspan="2"><img name="base_r2_c3" src="base_r2_c3.gif" width="28" height="689" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="627" border="0" alt=""></td>
</tr>
<tr>
<td><img name="base_r3_c2" src="base_r3_c2.gif" width="661" height="62" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="62" border="0" alt=""></td>
</tr>
</table>
</form>
</body>
<script language='JavaScript'>
function cad(){
document.frm.onclick="/Cadastroos";
document.frm.submit();
}
</script>
</html>
Cadastroos.JAVA
/*
* Cadastroos.java
*
* Created on 29 de Julho de 2005, 08:59
*/
/**
*
* @author eduardo
*/
/*Servlet Responsável pela Inclusão*/
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import conexao.BD;
import conexao.*;
public class Cadastroos extends HttpServlet {
public void doPost(HttpServletRequest req,
HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/plain");
String solic = req.getParameter("solic");
String depto = req.getParameter("depto");
String dt_cham = req.getParameter("dt_cham");
String h_cham = req.getParameter("h_cham");
String desc1 = req.getParameter("desc1");
String desc2 = req.getParameter("desc2");
String h_inicio = req.getParameter("h_inicio");
String h_fim = req.getParameter("h_fim");
String dt_inicio = req.getParameter("dt_inicio");
String dt_fim = req.getParameter("dt_fim");
String prazo = req.getParameter("prazo");
String tecnico = req.getParameter("tecnico");
String concluido = req.getParameter("concluido");
String status = req.getParameter("status");
String sql="INSERT INTO chamado VALUES ('"+solic+"','"+depto+"','"+dt_cham+"','"+h_cham+"','"+desc1+"','"+desc2+"'," +
"'"+h_inicio+"','"+h_fim+"','"+dt_inicio+"','"+dt_fim+"','"+prazo+"','"+tecnico+"','"+concluido+"','"+status+"')";
BD con = null;
try {
con = new BD();
con.executeUpdate(sql);
//mensagem de sucesso
res.sendRedirect("/PI/Cadastradoos.jsp");
} catch (SQLException e){
//Não está conseguindo se conectar ao banco
res.sendRedirect("/PI/errobd.jsp");
return;
}
finally {
if (con!=null)
con.fecharConexao();
con=null;
}
}
}
BD.JAVA
/*
* BD.java
*
* Created on 29 de Julho de 2005, 08:43
*/
/**
*
* @author eduardo
*/
package conexao;
import java.sql.*;
public class BD {
private Connection connection;
private Statement statement;
public BD(){
try{
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driverName);
String serverName = "localhost";
String url = "jdbc:odbc:bd";
String username = "";
String password = "";
connection = DriverManager.getConnection(url, username, password);
}catch(ClassNotFoundException ex){
System.out.println("Não foi possível encontrar o driver");
}catch(SQLException ex){
System.out.println("Não foi possível conectar ao servidor");
}
try {
statement = connection.createStatement();
}catch(SQLException ex){
System.out.println("Não foi possível conectar ao servidor");
}
}
public synchronized void executeUpdate(String update)throws SQLException {
try{
statement.executeUpdate(update);
}catch(SQLException ex){
System.out.println("Não foi possível executar o update");
}
}
public synchronized ResultSet executeQuery(String query)throws SQLException {
try{
return statement.executeQuery(query);
}catch(SQLException ex){
System.out.println("Não foi possível executar a query");
throw ex;
}
}
public void fecharConexao(){
try{
statement.close();
}catch(SQLException ex){
ex.printStackTrace();
}
}
}
Bom ta ai o código... e meu prazo na empresa é de terminar até sexta senao vou me ferrar, alguem pode me ajudar? por favor...