solve this problem

solve this problem

I typed this program and compiled.The program is compiled but when i eneterd url in tomcat server. Its not giving error but only blank page is coming the text is not displaying and row is also inserted in table please tell me the solution for thid problem

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DataInsertion extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)throws 
                               ServletException, IOException{ <br />
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    String url = "jdbc:mysql://localhost/zulfiqar?user=root&amp;password=admin";
    Connection conn;
    ResultSet rs;
    try{
      Class.forName("org.gjt.mm.mysql.Driver");
      conn = DriverManager.getConnection(url);
      Statement statement = conn.createStatement();
      String query = "insert into emp_sal values('zulfiqar', 15000)";
      int i = statement.executeUpdate(query);
      if(i!=0){
        out.println("The record has been inserted");
      }
      else{
        out.println("Sorry! Failure");
      }
      rs = statement.executeQuery("select * from emp_sal");
      while(rs.next()){
        out.println("<p><table>" + rs.getString(1) + " " + rs.getInt(2) + "</p></table>");
      }
      rs.close();
      statement.close();
    }
    catch (Exception e){
      System.out.println(e);
    }
  }
}

XML File for this program
<?xml version="1.0" encoding="ISO-8859-1"?>
<!--<!DOCTYPE web-app
 PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd"> -->

<web-app>
 <servlet>
  <servlet-name>Hello</servlet-name>
  <servlet-class>DataInsertion</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>Hello</servlet-name>
 <url-pattern>/DataInsertion</url-pattern>
 </servlet-mapping>
</web-app>
View Answers

January 21, 2011 at 12:33 PM

Hello Friend,

Here is our code. Check it.

import java.io.*;
import java.sql.*;
import javax.servlet.*; 
import javax.servlet.http.*;

public class DataInsertion extends HttpServlet{
    public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{

response.setContentType("text/html"); 
PrintWriter out = response.getWriter();
String url = "jdbc:mysql://localhost/test?user=root&password=root";
Connection conn; 
ResultSet rs; 
try{ 
    Class.forName("com.mysql.jdbc.Driver"); 
    conn = DriverManager.getConnection(url);
    Statement statement = conn.createStatement();
    String query = "insert into emp(EMP_NAME,SALARY) values('roseindia', 10000)";
    int i = statement.executeUpdate(query);
    if(i!=0){
        out.println("The record has been inserted<br>"); 
        } 
        else{
            out.println("Sorry! Failure");
            } 
            rs = statement.executeQuery("select * from emp"); 
            while(rs.next()){
                out.println(""+rs.getString("EMP_NAME") + " " + rs.getInt("SALARY") + "<br>"); 
                } 
                rs.close();
                statement.close();
                }
                catch (Exception e){
                    System.out.println(e); 
                    }
                    }
                    }

In web.xml:

     <servlet>
        <servlet-name>DataInsertion</servlet-name>
        <servlet-class>DataInsertion</servlet-class>
    </servlet>

     <servlet-mapping>
        <servlet-name>DataInsertion</servlet-name>
        <url-pattern>/DataInsertion</url-pattern>
    </servlet-mapping>









Related Tutorials/Questions & Answers:
solve this problem
solve this problem  I typed this program and compiled.The program is compiled but when i eneterd url in tomcat server. Its not giving error but only... in table please tell me the solution for thid problem import java.io.*; import
help me to solve this problem..
help me to solve this problem..  Given below is a class definition for Book. Type and compile the class, and answer the following questions: class Book { String title; //bookâ??s title double price; //bookâ??s price
Advertisements
Solve this problem plzzz
Solve this problem plzzz  Prashant.jsp (this is my JSP file) <HTML> <HEAD> <TITLE>Login using jsp <BODY>... kindly help me and check all those files and solve my problem as soon as possible
how to solve an internet connection problem
how to solve an internet connection problem  when i run my application it give me this error: Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not yet implemented the problem is that i don`t know
can interface solve this problem in java
can interface solve this problem in java  I have a JDialog which displays the calendar [from 2010-2020], i created this in a different class... this calander class. can interface solve this problem. If yes then how. pls
how to solve this problem for oracle connectivity
how to solve this problem for oracle connectivity  Exception in thread "main" java.sql.SQLException: Io exception: The Network Adap ter could not establish the connection
Please Help To Solve My Problem
Please Help To Solve My Problem  PHP I Have 6 Textbox and 1 ok... With B Team when A Team Play With B Team Again Then Generate Error. I Am Solve This Problem With If...Else If...Else Statement But When the More Team
how do i solve this problem?
how do i solve this problem?  Define a class named Circle with the following properties: List item An integer data field named radius with protected access modifier, and a String data field named colour with private access
i need help to solve this problem
i need help to solve this problem  Write a stack class ArrayStack.java implements PureStack interface that reads in strings from standard input and prints them in reverse order. and Show step by step what queue will look like
Simple problem to solve - JSP-Servlet
Simple problem to solve  Respected Sir/Madam, I am R.Ragavendran.. Thanks for your kind and timely help for the program I have asked.... But in that I am facing a very very minute problem. The alert boxes are displayed
Simple problem to solve - JSP-Servlet
Simple problem to solve  Respected Sir/Madam, I am.... But in that I am facing a very very minute problem. The alert boxes are displayed.../Regards, R.Ragavendran..   Hi Raghavendran, The problem is not so
How to solve button problem - Java Beginners
to solve this problem. Thank you Sir, Yours truly, T.Ramesh Puttaparthy...How to solve button problem  I have created button (Open File Dialog... Open Dialog Box and from that displaying image files. But problem is Iâ??ve used
Solve it
Solve it  How to calculate the value which contains oparator and operand both using command line argument
solve this
solve this   Create a student class. The student object should have studentid, studentname, subject and marks as properties. Also generate the getter and setter methods. Create 5 objects of this class and populate values
please help me solve this problem when i am create database connection using servlecontext
please help me solve this problem when i am create database connection using servlecontext  hi... I have create a database connection using... understand what is the problem .... the code are as follows. the servlet context
solve this pbm
solve this pbm  its not working the code for databae access using servlets
how to solve
how to solve   log4j:WARN No appenders could be found for logger (org.apache.struts.util.PropertyMessageResources). log4j:WARN Please initialize the log4j system properly
solve this pbm
solve this pbm  sir rows are also inserting i have checked in the database also the rows are not affected in the table . The first pbm wich i have sent to you is not yet solved.......... pls give me detail explaination how we
Solve
how to solve this..
how to solve this..  Given a list of students and their marks Name | Science | Math | English | Computer Ahmad | 28 | 100 | 66 | 34 Samad | 56 | 89 | 55
how to solve this..
how to solve this..  Given a list of students and their marks Name | Science | Math | English | Computer Ahmad | 28 | 100 | 66 | 34 Samad | 56 | 89 | 55
in php installation problem ?
in php installation problem ?   php installation in 7th step did not display y/n dialog box how to solve the problem
ModuleNotFoundError: No module named 'solve'
ModuleNotFoundError: No module named 'solve'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'solve' How to remove the ModuleNotFoundError: No module named 'solve'
A Program To Solve In Java
A Program To Solve In Java  x!/x+(x+2)!/x+(x+4)!/x ... (x+n)!/x
help me to solve this question
help me to solve this question  Write a program that inputs a series of integers into an array. The numbers are in the range 0 to 100. Calculate and display : a) The Largest number b) The Smallest Number c)The sum of the numbers
Skyline Problem
. Your method should solve the problem three different ways; each solution... is the line tracing the largest y value from any rectangle in S The Problem: Write
How to solve the Hibernate Common Exceptions?
How to solve the Hibernate Common Exceptions?  How to solve the Hibernate Common Exceptions
please solve this program
please solve this program  Build a package EMPPACK that contains one stored function Validatesal() and two stored procedures Insertemp() and Getempdetails().The Insert_emp() procedure inserts a particular employee
Small Bug How to solve in my code
Small Bug How to solve in my code  String season=""; pst...") + ","; it shows bug in findbugs tool.. but it executes successfully how to solve the problem
please solve the programme
please solve the programme  Develop a java program to find the roots of a quadratic equation ax2+bx+c=0, with the following specification :- Class name :- Quad Data members float a,b,c,d, with a,b,c are the co-efficient
Solve Program - Java Beginners
Solve Program  Write a progaram in java to display all odd number from 1 to 100   hi use this code package rajanikant.code.sep_2008; public class EvenOdd { public static void main(String s
help me to solve this question...
help me to solve this question...  Given below is a class definition for Book. Type and compile the class, and answer the following questions: class Book { String title; //bookâ??s title double price; //bookâ??s
plz solve my query?
plz solve my query?  how to remove all the options from select control in html using java script?   JavaScript remove all items <html> <script language="javascript" > function removeAllItems(selectbox
Solve it - Java Beginners
Solve it  Hi Friends, Thanks for continue reply.. I have some query please solved...its urgent.. I have two table,emp,exam.both have e... is write here. no information display in the jsp file please solve it and let me
ModuleNotFoundError: No module named 'flood-solve'
ModuleNotFoundError: No module named 'flood-solve'  Hi, My Python... 'flood-solve' How to remove the ModuleNotFoundError: No module named 'flood-solve' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'magiceye_solve'
ModuleNotFoundError: No module named 'magiceye_solve'  Hi, My... named 'magiceye_solve' How to remove the ModuleNotFoundError: No module named 'magiceye_solve' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'solve-instrument'
ModuleNotFoundError: No module named 'solve-instrument'  Hi, My... named 'solve-instrument' How to remove the ModuleNotFoundError: No module named 'solve-instrument' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'sudoku-solve'
ModuleNotFoundError: No module named 'sudoku-solve'  Hi, My Python... 'sudoku-solve' How to remove the ModuleNotFoundError: No module named 'sudoku-solve' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'sudoku-solve'
ModuleNotFoundError: No module named 'sudoku-solve'  Hi, My Python... 'sudoku-solve' How to remove the ModuleNotFoundError: No module named 'sudoku-solve' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'flood-solve'
ModuleNotFoundError: No module named 'flood-solve'  Hi, My Python... 'flood-solve' How to remove the ModuleNotFoundError: No module named 'flood-solve' error? Thanks   Hi, In your python environment
solve it - Java Beginners
solve it  Hi friend, I want to use switch case in jsp please let me know how to call page in jsp using include tag i want call this file using include tag please help me use switch statement in jsp
ArrayList question plz solve it
ArrayList question plz solve it  An arraylist object stores an Emp Object, where there is name,age,address of the employee is stored, And i want to access the data in the basis of age based? Provide answer to the question
Solve my code
Solve my code  import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.io.*; public class ChangeDetails extends HttpServlet{ public void doPost(HttpServletRequest request,HttpServletResponse
to solve the error - Java Beginners
to solve the error  class bubbleSort1{ public static void bubbleSort(int[] x) { int n = x.length; for (int pass=1; pass < n; pass++) { // count how many times // This next loop becomes shorter and shorter for (int i=0
help me to solve this question
help me to solve this question   A user needs to key in data into system in order to save data into array. The data are: a. Lecturer ID, Lecturer name, School, course code, course name, session, semester A user can edit the data
solve my question shortly
solve my question shortly  <html> <head> <script> function checkphoneNumber(number){ if(/[^\d ]/.test(number)){ alert('It should contain numbers [0-9] only!'); document.getElementById
I couldn't solve it
I couldn't solve it  *A customer who wants to apply for getting a car license should provide information about the brand of the car. *Then the customer receives a request ID from the office. *The customer's request (represented
plz help meto solve this question
plz help meto solve this question  for a file that exist what will be the length() method in the file class return
scrolling problem - Framework
. can anybody tell me how can solve this problem
problem in onlinetest...
problem in onlinetest...  hi, my code getting the problem is ,when user leave a question then the server puts error... pls help me

Ads