>
[import java.io.IOException;
import java.io.PrintWriter;
//import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/NovoChamado")
public class NovoChamado extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
try {
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Novo Chamado </title>");
out.println("</head>");
out.println("<Body");
out.println("<h1>Preencha suas Informações do Chamado </h1>");
out.println("<hr>");
out.println("<form method='POST'>");
out.println("Titulo:<br> <input type='text' name='txttitulo'>");
out.println("<br>");
out.println("Conteudo:<br> <textarea name='txtConteudo' rows='10' cols='40'></textarea>");
out.println("<br>");
out.println("<input type='submit' value='Abrir Chamado'>");
out.println("</form>");
out.println("<br>");
out.println("<a href=/'ListarChamado'>Listar Chamado</a>");
out.println("<br>");
out.println("<a href=/'Logoff'>Sair</a>");
out.println("</Body>");
out.println("</html>");
} catch (IOException e) {
}
}
protected void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
PrintWriter out = res.getWriter();
String titulo = req.getParameter("txttitulo");
String conteudo = req.getParameter("txtConteudo");
if (titulo.trim().equals("")) {
out.println("Prencha o campo titulo");
} else if(conteudo.trim().equals("")) {
out.println("Prencha o campo conteudo");
}else {
try {
Class.forName("com.mysql.jdbc.Driver");
String sql= "insert into chamados(titulo, conteudo) values (?,?)";
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/chamados_rlsystem","root", "");
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setString(1, titulo);
psmt.setString(2, conteudo);
psmt.execute(sql);
psmt.close();
conn.close();
} catch (SQLException e) {
out.print("Problema com banco de dados");
} catch (ClassNotFoundException e) {
out.print("Problema ao Carregar o Drive de Conexão!");
}
}
}