Add-JNDI
package com.emprogria;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.annotation.Resource;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class Add extends HttpServlet {
@Resource(name = "CDRInfo")
private DataSource cDRInfo;
/**
* 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.setCharacterEncoding("Big5");
response.setContentType("text/plain;charset=Big5");
PrintWriter out = response.getWriter();
try {
if (Core.isEmpty(request.getParameter("file_name"))
|| Core.isEmpty(request.getParameter("record_number"))) {
out.println("0");
} else {
String fine_name = new String(request.getParameter("file_name").getBytes("ISO-8859-1"), "Big5");
String record_data = new String(request.getParameter("record_data").getBytes("ISO-8859-1"), "Big5");
int record_number = Integer.parseInt(request.getParameter("record_number"));
try {
Connection myConnection = cDRInfo.getConnection();
String mySQL = String.format("INSERT INTO CDR_Info(File_Name, Record_Number, Record_Data) VALUES('%s', %d, '%s')",
new Object[]{fine_name, record_number, record_data});
Statement myStatement = myConnection.createStatement();
boolean OK = false;
try {
myStatement.execute(mySQL);
OK = true;
} catch (SQLException ex) {
Logger.getLogger(ListAll.class.getName()).log(Level.SEVERE, null, ex);
}
if (OK) {
out.println("1");
} else {
out.println("0");
}
myConnection.close();
} catch (SQLException ex) {
Logger.getLogger(ListAll.class.getName()).log(Level.SEVERE, null, ex);
}
}
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* 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 {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Add";
}// </editor-fold>
}