Olá pessoal!
Estou desenvolvendo um sistemas para controle de estoque em jsp, estou utilizando a IDE Dreamweaver. Gostaria de saber como faço para quando digitar o código do produto no TexField o nome deste produto saia em outro TextField. Quero fazer com uma função javascript mas não estou sabendo desenvolver na hora de fazer a conexão com o banco.
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
font-size: 24px;
color: #0000FF;
}
.style2 {
font-size: 14px;
color: #333333;
}
body {
background-color: #CCCCCC;
}
.style3 {color: #999999}
-->
</style>
<script type="text/javascript">
<!--
//-->
</script>
</head>
<body>
<form action="" method="post" name="form_vendas" class="style1" id="form_vendas">
<div align="center">
<p>Vendas </p>
<% if(request.getParameter("acao")==null)
{%>
<p align="left" class="style2">Movimento:
<label>
<input name="tf_nfvenda" type="text" id="tf_nfvenda" size="10" maxlength="10" Disabled="Disabled"/>
</label>
Data:
<label>
<input name="tf_datavenda" type="text" id="tf_datavenda" size="10" maxlength="10" />
</label>
Cliente:
<label>
<select name="cb_clivenda" id="cb_clivenda">
<%
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql://localhost/comercio","postgres","");
Statement st = con.createStatement();
ResultSet rs;
String sql = "select cli_nome from clientes order by cli_nome";
rs = st.executeQuery(sql);
while (rs.next()){
%>
<option selected="selected"><%=rs.getString("cli_nome")%></option>
<%}
%>
</select>
</label>
</p>
<p align="left" class="style2">Total da Venda:
<label>
<input name="tf_totvenda" type="text" id="tf_totvenda" size="15" maxlength="15" />
</label>
Saldo:
<label>
<input type="text" name="tf_sdclivenda" id="tf_sdclivenda" />
</label>
<label>
<input type="radio" name="rb_tpvenda" id="rb_tpvenda" value="rb_tpvenda" />
</label>
A Prazo</p>
<table width="200" border="1">
<tr bgcolor="#CCCCCC">
<td><div align="center" class="style2">Sequencia</div></td>
<td><div align="center"><span class="style2">Codigo Produto</span></div></td>
<td><div align="center"><span class="style2">Nome Produto</span></div></td>
<td><div align="center"><span class="style2">Quantidade</span></div></td>
<td><div align="center" class="style2">Valor Unitario</div></td>
<td><div align="center"><span class="style2">Valor Total</span></div></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<label>
<input name="tf_movvenda" type="text" id="tf_movvenda" size="2" maxlength="2" Disabled = "Disabled"/>
</label>
</span></td>
<td><span class="style3">
<label>
<input name="tf_codprodvenda" type="text" id="tf_codprodvenda" size="30" maxlength="30" />
</label>
</span></td>
<td><span class="style3">
<label>
<input name="tf_nomprodvenda" type="text" id="tf_nomprodvenda" size="40" maxlength="40" />
</label>
</span></td>
<td><span class="style3">
<label>
<input name="tf_qtprodvenda" type="text" id="tf_qtprodvenda" size="3" maxlength="3" />
</label>
</span></td>
<td><span class="style3">
<label>
<input name="tf_vlunitvenda" type="text" id="tf_vlunitvenda" size="13" maxlength="13" Disabled = "Disabled"/>
</label>
</span></td>
<td><span class="style3">
<label>
<input name="tf_vltotvenda" type="text" id="tf_vltotvenda" size="13" maxlength="13" />
</label>
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda2" type="text" id="tf_movvenda2" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda2" type="text" id="tf_codprodvenda2" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda2" type="text" id="tf_nomprodvenda2" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda2" type="text" id="tf_qtprodvenda2" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda2" type="text" id="tf_vlunitvenda2" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda2" type="text" id="tf_vltotvenda2" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda3" type="text" id="tf_movvenda3" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda3" type="text" id="tf_codprodvenda3" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda3" type="text" id="tf_nomprodvenda3" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda3" type="text" id="tf_qtprodvenda3" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda3" type="text" id="tf_vlunitvenda3" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda3" type="text" id="tf_vltotvenda3" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda4" type="text" id="tf_movvenda4" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda4" type="text" id="tf_codprodvenda4" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda4" type="text" id="tf_nomprodvenda4" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda4" type="text" id="tf_qtprodvenda4" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda4" type="text" id="tf_vlunitvenda4" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda4" type="text" id="tf_vltotvenda4" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda5" type="text" id="tf_movvenda5" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda5" type="text" id="tf_codprodvenda5" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda5" type="text" id="tf_nomprodvenda5" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda5" type="text" id="tf_qtprodvenda5" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda5" type="text" id="tf_vlunitvenda5" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda5" type="text" id="tf_vltotvenda5" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda6" type="text" id="tf_movvenda6" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda6" type="text" id="tf_codprodvenda6" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda6" type="text" id="tf_nomprodvenda6" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda6" type="text" id="tf_qtprodvenda6" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda6" type="text" id="tf_vlunitvenda6" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda6" type="text" id="tf_vltotvenda6" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda7" type="text" id="tf_movvenda7" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda7" type="text" id="tf_codprodvenda7" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda7" type="text" id="tf_nomprodvenda7" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda7" type="text" id="tf_qtprodvenda7" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda7" type="text" id="tf_vlunitvenda7" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda7" type="text" id="tf_vltotvenda7" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda8" type="text" id="tf_movvenda8" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda8" type="text" id="tf_codprodvenda8" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda8" type="text" id="tf_nomprodvenda8" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda8" type="text" id="tf_qtprodvenda8" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda8" type="text" id="tf_vlunitvenda8" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda8" type="text" id="tf_vltotvenda8" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda9" type="text" id="tf_movvenda9" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda9" type="text" id="tf_codprodvenda9" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda9" type="text" id="tf_nomprodvenda9" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda9" type="text" id="tf_qtprodvenda9" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda9" type="text" id="tf_vlunitvenda9" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda9" type="text" id="tf_vltotvenda9" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda10" type="text" id="tf_movvenda10" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda10" type="text" id="tf_codprodvenda10" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda10" type="text" id="tf_nomprodvenda10" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda10" type="text" id="tf_qtprodvenda10" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda10" type="text" id="tf_vlunitvenda10" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda10" type="text" id="tf_vltotvenda10" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda11" type="text" id="tf_movvenda11" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda11" type="text" id="tf_codprodvenda11" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda11" type="text" id="tf_nomprodvenda11" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda11" type="text" id="tf_qtprodvenda11" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda11" type="text" id="tf_vlunitvenda11" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda11" type="text" id="tf_vltotvenda11" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda12" type="text" id="tf_movvenda12" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda12" type="text" id="tf_codprodvenda12" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda12" type="text" id="tf_nomprodvenda12" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda12" type="text" id="tf_qtprodvenda12" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda12" type="text" id="tf_vlunitvenda12" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda12" type="text" id="tf_vltotvenda12" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda13" type="text" id="tf_movvenda13" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda13" type="text" id="tf_codprodvenda13" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda13" type="text" id="tf_nomprodvenda13" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda13" type="text" id="tf_qtprodvenda13" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda13" type="text" id="tf_vlunitvenda13" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda13" type="text" id="tf_vltotvenda13" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda14" type="text" id="tf_movvenda14" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda14" type="text" id="tf_codprodvenda14" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda14" type="text" id="tf_nomprodvenda14" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda14" type="text" id="tf_qtprodvenda14" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda14" type="text" id="tf_vlunitvenda14" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda14" type="text" id="tf_vltotvenda14" size="13" maxlength="13" />
</span></td>
</tr>
<tr bgcolor="#999999">
<td><span class="style3">
<input name="tf_movvenda15" type="text" id="tf_movvenda15" size="2" maxlength="2" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_codprodvenda15" type="text" id="tf_codprodvenda15" size="30" maxlength="30" />
</span></td>
<td><span class="style3">
<input name="tf_nomprodvenda15" type="text" id="tf_nomprodvenda15" size="40" maxlength="40" />
</span></td>
<td><span class="style3">
<input name="tf_qtprodvenda15" type="text" id="tf_qtprodvenda15" size="3" maxlength="3" />
</span></td>
<td><span class="style3">
<input name="tf_vlunitvenda15" type="text" id="tf_vlunitvenda15" size="13" maxlength="13" Disabled = "Disabled"/>
</span></td>
<td><span class="style3">
<input name="tf_vltotvenda15" type="text" id="tf_vltotvenda15" size="13" maxlength="13" />
</span></td>
</tr>
</table>
<p>
<label>
<input type="submit" name="salvar" id="salvar" value="Salvar" />
</label>
<label>
<input type="reset" name="cancelar" id="cancelar" value="Cancelar" />
</label>
</p>
<p align="center" class="style2"> </p>
</div>
</form>
<%}
else{
try{
Class.forName ("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql://localhost/comercio","postgres","");
Statement st = con.createStatement();
st.executeUpdate("insert into vendas(ven_data,ven_nomecli,ven_tppagto,ven_vltotal) values ('"+request.getParameter("tf_datavenda")+"','"+request.getParameter("tf_endcliente")+"','"+request.getParameter("cb_clivenda")+"','"+request.getParameter("rb_tpvenda")+"','"+request.getParameter("tf_totvenda")+"')");
}
catch(ClassNotFoundException erroClass){
out.println("A classe Drive JDBC não foi localizada-> "+erroClass);
}
catch(SQLException erroSQL){
out.println("Erro de conexão com o Banco de Dados-> "+erroSQL);
}
response.sendRedirect("cad_clientes.jsp");
}%>
</body>
</html>