<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*,org.opencms.main.*, java.text.*"%>
<%@ taglib prefix="cms" uri="http://www.opencms.org/taglib/cms"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String value = pageContext.getAttribute("value").toString() != null ? pageContext.getAttribute("value").toString() : "";
String id = pageContext.getAttribute("id").toString() != null ? pageContext.getAttribute("id").toString() : "0";
int idINT = 0;
//x.jsp?value=x&id=y
%>
<%
Connection con = OpenCms.getSqlManager().getConnection("sic");
PreparedStatement stmt =null;
//Query
String query = "UPDATE tresposta_enquete_almg SET titulo=? WHERE id=?";
//out.print(query);
try{
idINT = Integer.parseInt(id);
if(!id.equals("0")){
try{
stmt = con.prepareStatement(query);
out.print("Valor '"+value+"' atualizado para o id "+id+"
");
stmt.setString(1, value);
stmt.setInt(2, idINT);
boolean r = stmt.execute();
out.print("r: "+r);
}catch (SQLException ex) {
ex.printStackTrace();
out.print(ex.getMessage());
}finally{
//rs.close();
stmt.close();
con.close();
}
}else{
out.print("id igual a 0");
}
}catch(NumberFormatException erro){
out.print("ID Não identificado");
}
//response.sendRedirect(gotoPage);
%>