TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
girijesh gupta
NA
1
1.4k
problem in record not inserted nor fire any exception
Feb 19 2013 5:20 AM
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
/**
*
* @author Esimo
*/
public class NewServlet extends HttpServlet{
/**
* 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.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
}
/*
int i=ps.executeUpdate();
if(i>0)
{
out.print("Success");
}
}
} catch (Exception e2)
{
System.out.println(e2);
}*/
// <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
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String pn=request.getParameter("name");
String pa=request.getParameter("age");
String pe=request.getParameter("email");
String pm=request.getParameter("mobile");
String pad=request.getParameter("address");
DataSource ds=null;
PreparedStatement ps =null;
try
{
Context mycontext = new InitialContext();
ds = (DataSource)mycontext.lookup("jdbc/mypo2");
if(ds==null)
{
out.println("JNDI context could not be found");
}
else
{
out.println("JNDI conext found...");
Connection con = ds.getConnection();
ps = con.prepareStatement("insert into telephone(pname,page,pemail,pmobile,paddress)values(?,?,?,?,?)");
ps.setString(1,pn);
ps.setString(2,pa);
ps.setString(3,pe);
ps.setString(4,pm);
ps.setString(5,pad);
// String query = "insert into telephone values() ";
//Statement stmt = con.createStatement();
int i=ps.executeUpdate();
if(i>0) {
out.println("Not Inserted");
} else {
out.println("Values Inserted");
}
} }catch (Exception e) {
System.out.println(e.getMessage());
}
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
Reply
Answers (
0
)
i want jsp code for online payment
How to upload a document (.doc,.pdf etc) to mysql database