Servlet Databse Insert Operation

//HTML FILE

<form action="http://localhost/servlet/Servlet3_insert_db" method="get">
        ID : <input type="Text" name="id"><br><br>
        Username : <input type="Text" name="unm"><br><br>
        Password : <input type="Text" name="pass"><br><br>

                    <input type="submit" name="sb" value="submit">        
    </form>

 //Servlet Databse Insert Operation

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


public class Servlet3_insert_db extends HttpServlet
{
    public void doGet(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException
    {
        res.setContentType("text/html");
        PrintWriter out = res.getWriter();
        try
        {
            
            String dbDriver = "com.mysql.jdbc.Driver";
            String dbURL = "jdbc:mysql://localhost:3306/";
            String dbname = "test_mydb";
            String unm = "root";
            String pass ="5044";

            Class.forName(dbDriver);
            Connection con = DriverManager.getConnection(dbURL + dbname, unm, pass);
            
            PreparedStatement st = con.prepareStatement("insert into login values(?, ?, ?)");

            st.setInt(1, Integer.parseInt(req.getParameter("id")));
            st.setString(2, req.getParameter("unm"));
            st.setString(3, req.getParameter("pass"));

            st.executeUpdate();

            st.close();
            con.close();

            out.println("<h3>Data Successfully Inserted</h3>" );
        }
        catch(Exception ex)
        {
            out.println("<b>" + ex + "</b>");
        }
    }
}

Comments

Popular posts from this blog

Questions 2 : Assume there are three small caches, each consisting of four one-word blocks. On cache is direct-mapped, a second is two-way set-associative, and the third is fully associative. Find the number of hits for each cache organization given the following sequence of block addresses: 0, 8, 6, 5, 10, 15 and 8 are accessed twice in the same sequence. Make a tabular column as given below to show the cache content on each of columns as required. Show all the pass independently pass. Draw as many numbers Assume the writing policy is LRU. Memory location Hit/Mis Add as many columns as required

Quetion 6 : Consider the "in-order-issue/in-order-completion" execution sequence shown in f In Figure Decode OWE Execute 12 12 12 14 16 13 16 13 15 15 16 Write 024/06/02 11 3 4 11 12 13 13 N 15 16 a. Identify the most likely reason why I could not enter the execute fourth cycle. stage until the [2] b. Will "in-order issue/out-of-order completion" or "out-of-order issue/out-of-order completion" fix this? If so, which? Explain

7.Write a program to read a list containing item name, item code and cost interactively and produce a three-column output as shown below. NAME CODE COST Turbo C++ 1001 250.95 C Primer 905 95.70 ------------- ------- ---------- ------------- ------- ---------- Note that the name and code are left-justified and the cost is right-justified with a precision of two digits. Trailing zeros are shown.