import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class InsertTexto extends HttpServlet
{
Connection con=null;
String url= "jdbc:mysql://localhost:3306/DELBONI?user=root&password=";
public void init(ServletConfig s) throws ServletException {
super.init(s);
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection(url);
}
catch (SQLException e){
System.out.println(">>> Erro de SQL");
System.out.println(e);
}
catch (Exception e){
System.out.println(">>> Erro Gerais");
System.out.println(e);
}
}
public void destroy (){
try {
con.close();
}
catch (Exception e){}
}
public void service (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
String texto = request.getParameter("texto");
System.out.println(texto);
try {
Statement st = con.createStatement();
st.executeUpdate("INSERT INTO texto Values(\"" + texto + "\")");
PrintWriter out=null;
response.setContentType("text/html");
out = response.getWriter();
out.println("");
out.println("");
out.println(" DIGITAÇÃO DE TEXTO ");
out.println("");
out.println("");
out.println(" OK
");
out.println("Consulta");
out.println("");
out.println("");
out.close();
}catch(Exception e){
System.out.println(e);
}
}
}