jsp and java

how to write a jsp and related java code to enter student marks into database

View Answers

February 4, 2011 at 12:15 PM

Hi Friend,

Try the following code:

1)insert.jsp:

<%@page import="java.sql.*"%>
<html>
<form method="post" action="../InsertServlet">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Marks:</td><td><input type="text" name="marks"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)InsertServlet.java:

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

public class InsertServlet extends HttpServlet { 
    public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
        res.setContentType("text/html");
        PrintWriter out = res.getWriter();
        String name=req.getParameter("name");
        String marks=req.getParameter("marks");
        int mm=Integer.parseInt(marks);
try{
Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into student(name,marks) values('"+name+"',"+mm+")");
         out.println("Data is inserted successfully");
         con.close();
        }
catch(Exception e){
    System.out.println(e);
}
            }
        }

Thanks

Ads

Advertisements

java/jsp
java/jsp In a JSP program called books.jsp, the Java code out.print(request.getParameter(�??number�??)); displays "1111111�??. What are the possible ways for the parameter number to have got its value

JAVA,JSP,SERVELTS
JAVA,JSP,SERVELTS plz Send me Login Page by using core java ,Jsp,Servelts

java - JSP-Servlet
java why is required to write both jsp and servlet in a application of java

java jsp
java jsp it is : javax.servlet.jsp only but getting error wt is reason? Use javax.servlet.jsp.* in your code

Java JSP - JDBC
Java JSP JDBC connectivity in JSP? Hi Friend, Please visit the following link: http://www.roseindia.net/jsp/Accessingdatabase-fromJSP.shtml Hope that it will be helpful for you. Thanks

A Java Program by using JSP
A Java Program by using JSP how to draw lines by using JSP plz show me the solution by using program

JSP
JSP Hi, What is JSP? What is the use of JSP? Thanks Hi, JSP Stands for Java Server Pages. It is Java technology for developing web applications. JSP is very easy to learn and it allows the developers to use Java

java bar charts and jsp
java bar charts and jsp Hi, Can any one help me out in how to create java bar charts using jsp with the help of data base table values? thanks.../jsp/draw-statistical-chart-jsp.shtml

java servet +jsp+mysqldatabase
java servet +jsp+mysqldatabase I created three servlets(based on title, bookname, author) and one jsp page. in jsp page i put one dropdown list box(that is title, author, bookname) and created mysql database column values

how to include a java class in jsp - JSP-Servlet
how to include a java class in jsp hello sir, this is my first question, i want know that how to use a java class function's variables and methods of a java class in jsp.if possible plz tr to explain with a simple example

JSP - Java Server Pages
JSP JSP stands for Java Server Pages. JSP is Java technologies for creating dynamic web applications. JSP allows the developer to embed Java code inside HTML. It makes the development of dynamic web application very easy in Java

java/jsp code to download a video
java/jsp code to download a video how can i download a video using jsp/servlet

Display Java in JSP
Display Java in JSP please i need urgent help. How can i display Java Applet created in netbeans in JSP?. the Application involves MYSQL Database connection. Thanks

JSP - Java Beginners
JSP Hai friends, I want to use the flash image on jsp or java script, if i click the image then it goes to the next page...... If any one... the following link: http://www.roseindia.net/jsp/add-flash-jsp.shtml Hope

jsp
jsp how to assign javascript varible to java method in jsp without using servlet

Converting jsp variable to java variable
Converting jsp variable to java variable Hi how to convert java script variable to java variable on same jsp page

java servlets - JSP-Servlet
java servlets how to get the parameter value of input type file using java servlets Hi, You can use request.getParameter(). In Jsp, --- --- IN servlet, String fileName=request.getParameter('fl'); If you

Creating dynamic jsp file in java file to include another jsp file
Creating dynamic jsp file in java file to include another jsp file I am able to create jsp file in java that includes ; table tr td and img tags..... Need to include jsp file in the same content. The below code doesn't help me

Need help on JAVA JSP
Need help on JAVA JSP Hi, I have never worked on java and I have been given an assignment where I have to fix existing issues in the tool(created using JAVA JSP). e.g. Tool does not adjust with the resolution of the screen

JSP
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.... For more information, visit the following link: http://www.roseindia.net/help/java

java beans - JSP-Servlet
java beans how to get the values from this page to java page bcoz i want to insert these values into table... the problem visit to : http://www.roseindia.net/jsp/usingbeansinjsp.shtml Thanks

java - JSP-Servlet
java what is the difference between jsp and servlet? Hi firend, Main difference between Jsp and Servlet Jsp is better for view web pages, while servlet is good for request processing. Jsp has also all

JSP
how can we use beans in jsp how can we use beans in jsp JSP provides three tags to work with beans:- <jsp:useBean id="bean name... = the name that refers to the bean.Bean class = name of the java class

JSP
the following link: http://www.roseindia.net/help/java/o/jsp-implicit-objects.shtml ..., visit the following link: http://www.roseindia.net/help/java/o/jsp-implicit...JSP what are different implicit objects of jsp mplicit

jsp and java script
jsp and java script <%@taglib prefix="logic" uri="http://struts.apache.org/tags-logic"%> <%@taglib prefix="bean" uri="http...; this is my jsp code am retriveing a value from action class and assigning

Java to create table in jsp file that include other jsp file
Java to create table in jsp file that include other jsp file String jspContent = "table" += "tr" += "td" += "jsp:include page='fileSource... this http://www.roseindia.net/tutorial/java/core/files/javacreatetableinHTML.html

jsp
jsp how jsp translated into servlets

JSP
JSP How to run jsp program in eclipse

Ads