Obrigado JonathanSSantos…
Mas não consegui fazer. nao sei onde colocar os trechos de código q vc falou… vou postar como eu fiz até aqui.
index.jsp
<%@page contentType="text/html" pageEncoding="windows-1250"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<title>Cadastro de Lugares Visitados...Teste</title>
</head>
<body>
<form name="cadastro" action="ServletLocal" method="POST">
<br><br>
Seu Nome:<input type="text" name="xiru" value="" size="60" />
Onde Está:<input type="text" name="onde" value="" size="60" />
<input type="submit" value="...Cadastra..." name="confirma" />
</form>
</body>
</html>
Local.java
package model;
import java.util.Date;
public class Local {
private Date data;
private String sujeito;
private String lugar;
public Local(String quem, String onde){
setSujeito(quem);
setLugar(onde);
}
public Date getData() {
return data;
}
public String getSujeito() {
return sujeito;
}
public String getLugar() {
return lugar;
}
public void setData(Date data) {
this.data = data;
}
public void setSujeito(String sujeito) {
this.sujeito = sujeito;
}
public void setLugar(String lugar) {
this.lugar = lugar;
}
}
DAO.java
package data;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author douglas
*/
public class DAO {
Connection c = null;
PreparedStatement ps;
ResultSet rs;
public Connection getConnexao(String uid, String pwd) {
try {
Class.forName("org.postgresql.Driver");
c = DriverManager.getConnection("jdbc:postgresql://localhost/localizador", uid, pwd);
return c;
} catch (SQLException ex) {
Logger.getLogger(DAO.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(DAO.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
private void conecta() {
if (c == null) {
this.c = getConnexao("postgres", "asus");
}
}
public boolean insRegistro(String sujeito, String lugar) {
try {
conecta();
ps = c.prepareStatement("insert into posicao (quem, lugar) values (?, ?)");
ps.setString(1, sujeito);
ps.setString(2, lugar);
ps.execute();
System.out.println("Teste");
return true;
} catch (SQLException ex) {
Logger.getLogger(DAO.class.getName()).log(Level.SEVERE, null, ex);
return false;
}
}
public List<Object> getRegistros(){
try {
conecta();
ps = c.prepareStatement("select * from posicao");
rs = ps.executeQuery();
return (List<Object>) rs;
} catch (SQLException ex) {
Logger.getLogger(DAO.class.getName()).log(Level.SEVERE, null, ex);
return null;
}
}
}
ServletLocal.java
package servlets;
import data.DAO;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import model.Local;
public class ServletLocal extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet ServletLocal</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet ServletLocal at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="Métodos HttpServlet. Clique no sinal de + ? esquerda para editar o código.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//PrintWriter writer = response.getWriter();
DAO dao = new DAO();
Local local = new Local(request.getParameter("xiru"), request.getParameter("onde"));
System.out.println("chamada do DAO");
dao.insRegistro(local.getSujeito(), local.getLugar());
//processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
A inserção do registro funciona certinho…
Obrigado