import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class NovoChamadoServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public NovoChamadoServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
PrintWriter out = response.getWriter();//Pocibilita que seja exibido na tela as informacoes
out.println("");
out.println("
");
out.println("
Novo chamdo");
out.println("");
out.println("");
out.println("
Preencha as informações do novo chamado
");
out.println("
");
out.println("
");
out.println("
");
out.println("
Listar Chamado");
out.println("
");
out.println("
Sair");
out.println("");
out.println("");
} catch (IOException e) {
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
String titulo = request.getParameter("txtTitulo");
String conteudo = request.getParameter("txtConteudo");
if(titulo.trim().length() < 4){
out.println("Preencha o campo titulo ");
}else if (conteudo.trim().length() < 4 ){
out.println("Preencha o campo conteudo ");
}else {
try{
Class.forName("conn.mysql.jdbc.Driver");
String SQL = "INSERT INTO chamdos (titulo,conteudo) VALUES(";
SQL += "'"+ titulo +"','"+ conteudo +"')";
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/chamados_rlsystem", "root", "senha***");
Statement stm = conn.createStatement();
stm.execute(SQL);
stm.close();
conn.close();
//10:40 aula 6
} catch (SQLException e) {
out.println("Problema no banco de dados!");
}
} catch (ClassNotFoundException ex){
out.println("Problema ao carregar driver de conexão!" + ex.getMessage());
}
}
}
}