Core Java| JSP| Servlets| XML| EJB| JEE5| Web Services| J2ME| Glossary| Questions?

Software Solutions and Services

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet

Questions

convert to java plss
hi i am using microsoft VB6.0 and my friend ask me to make java program to convert number to words but i only use visual
java program
if c = 2 find d = ++c++++4 answer shows 3+2+4+1 9+1 10 I think d = operator mistake, pls clarify what operator
java program
if int a = 48 find a = a+++++a answer shows 48+49+1 97+1 98 pls clarify find a equation, as I think there some
java
program concept behind inheritance in java
Java File
Hi Friend, Thank you for the support I got previously... Anyone please send me the Java Code for scanning a direct
password protected zip file creation exmpale coded neaded
am able to create a zip file and able to read the file but password protection need please help
java
any programs on combination generation pls...
deteminant
wap to find the determinant of any order matrix
java
i want to know the program for transversal sort. thanks
java
pl. let me know few progrograms on encapsulation. thanks
All Questions...

Comments

Submit comments in database when user clicks on submit button
This is detailed java code to show how to submit comments from a jsp page and insert it to the MySql database when user clicks the submit button of the page.

Submit comments in database when user clicks on submit button

This is detailed java code to show how to submit comments from a jsp page and insert it to the MySql database when user clicks the submit button of the page.

Create a database: First create a database named "usermaster" in MySql and table named "user_master" in same database by SQL query given below:

create table user_master (
         user_id int not null auto_increment,
         name varchar(20),
         comment text(200),
         primary key(user_id)
);

Now create the JSP page for the user to place the comment and submit the comment. For this we have created first_page.jsp as below.

first_page.jsp

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>

<html> 
    <head> 
        <title>Create table in mysql database using jsp</title>
    </head> 
    <body bgcolor="#ffffcc">
     <form action="ConnectJspToMysql.jsp" method="get">
      <TABLE style="background-color: #ECE5B6;" WIDTH="40%">
         <tr>
           <td >Student Id</td>
             <td ><input type="text" name="id" SIZE="35"></td>
              </tr>
              <tr>
                <td >Student Name</td>
                <td ><input type="text" name="name" SIZE="35"></td>
              </tr>
                <tr width="100%">
                  <td >Comments<br><font color="blue">
                  (max 200 chars)</font></td>
                  <td ><TEXTAREA NAME="comment" ROWS="5" COLS="26">
                  </TEXTAREA></td>
              </tr>
                <tr><td></td>
                 <td><input type="reset" name="reset"
                  value="reset">&nbsp;&nbsp;
                <input type="submit" value="submit"></td></tr>
            </TABLE>
        </form>
    </body> 
</html>

Save this code as a .jsp file named "first_page.jsp" in your application directory in tomcat server and run this jsp page with url "http://localhost:8080/user/first_page.jsp" in address bar of the browser.

Now create another JSP "ConnectJspToMysql.jsp" which retrieves the comment written by the user in the previous page and insert it to the database. To connect with the database you need database driver jar file in the lib directory of your application directory in Tomcat.

ConnectJspToMysql.jsp

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>

<html> 
<head> 
    <title>data successfully saved</title>
</head> 
<body>
<% // get parameters from the request
   String id = request.getParameter("id");
   String name = request.getParameter("name");
   String comment = request.getParameter("comment");
   Statement statement = null;

   // declare a connection by using Connection interface 
   Connection connection = null;
   try {
   /* Create string of connection url within specified format 
   with machine name, 
   port number and database name. Here machine name id 
   localhost and database name is usermaster. */
   String connectionURL = "jdbc:mysql://localhost:3306/usermaster";

   // Load JBBC driver "com.mysql.jdbc.Driver" by newInstance() method. 
   Class.forName("com.mysql.jdbc.Driver").newInstance();

   /* Create a connection by using getConnection() 
   method that takes parameters of string type connection url, user 
   name and password to connect to database. */
   connection = DriverManager.getConnection(connectionURL, "root", "root");
   statement = connection.createStatement();
   String QueryString = "INSERT INTO user_master
   (user_id,name,comment) VALUES ('" + 
   id + "','" + name + "','" + comment + "')";
   int UQ = statement.executeUpdate(QueryString);
   if (UQ > 0) {
%><font color="green" size="5" >Congratulations !</font>
<h2><p>Your comment is submitted successfully.<br></p></h2>

<TABLE style="background-color: #ECE5B6;" WIDTH="30%">
    <tr>

    <tr>
        <td>User Id</td>
        <td><%= id%></td>
    </tr>
    <tr>
        <td>Name</td>
        <td><%=name%></td>
    </tr>
    <tr><td></td><td align="right">
            <A HREF="first_page.jsp">
            <font size="4" color="blue">go to home page</font></A>
        </td>
    </tr>
</TABLE>

<%	}

} catch (Exception ex) {
%>
<FONT size="+3" color="red"></b>
    <%
                out.println("Unable to connect to database.");
            } finally {

                statement.close();
                connection.close();
            }
    %>
</FONT>
</body> 
</html>

Save this code as a .jsp file named "ConnectJspToMysql.jsp" in your application directory in Tomcat.

To start Tomcat server run startup.bat file from directory Tomcat-6.0.16/bin/startup.bat. To run this application open browser and type http://localhost:8080/user/first_page.jsp in address bar and open this jsp page.

Fill all the fields in the form, student id must be integer number then click submit button. If all the values are submitted successfully in database, this page will call another jsp page that shows following message on the page..

If found any error to submit data in database shows following error message....

Download source code

� View all related tutorials

Related Tags: c client request display page name cli ie ref e li spl m nt play isp cl es age me

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.