JSP With JDBC

-

login.html

     <html>
<body>
    <form action="http://localhost/Hello/login.jsp" method="GET">
        <table border="1">
            <tr>
                <th colspan="2">
                    Login Page with JSP
                </th>
            </tr>
            <tr>
                <td>
                    Name :
                </td>
                <td>
                    <input type="text" name="nm" value="">
                </td>
            </tr>
            <tr>
            <tr>
                <td>
                    Password :
                </td>
                <td>
                    <input type="password" name="pw" value="">
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <input type="submit" name="sub" value="Login"">
                    <a href="Registration.html">Registration</a>
                </td>
            </tr>
        </table>
    </form>
</body>
</html>

 

Registration.html 

    <html>
<body>
    <form method="GET">
        <table border="1">
            <tr>
                <th colspan="2">
                    Registration Page with JSP
                </th>
            </tr>
            <tr>
                <td>
                    Id :
                </td>
                <td>
                    <input type="text" name="id" value="">
                </td>
            </tr>
            <tr>
                <td>
                    Name :
                </td>
                <td>
                    <input type="text" name="nm" value="">
                </td>
            </tr>
            <tr>
                <td>
                    Email :
                </td>
                <td>
                    <input type="text" name="em" value="">
                </td>
            </tr>
            <tr>
                <td>
                    Password :
                </td>
                <td>
                    <input type="password" name="pw" value="">
                </td>
            </tr>
            <tr>
                <td>
                    Phone :
                </td>
                <td>
                    <input type="text" name="ph" value="">
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <input type="submit" name="sub" value="Save" onclick="form.action='http://localhost/Hello/reg.jsp'">
                    <input type="submit" name="sub" value="Update" onclick="form.action='http://localhost/Hello/update.jsp'">
                    <input type="submit" name="sub" value="Delete" onclick="form.action='http://localhost/Hello/delete.jsp'">
                    <input type="submit" name="sub" value="View" onclick="form.action='http://localhost/Hello/view.jsp'">
                    <a href="Login.html">Login</a>
                </td>
            </tr>
        </table>
    </form>
</body>
</html> 

 insert.jsp

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

<%

response.setContentType("text/html");
int id=Integer.parseInt(request.getParameter("id"));
String nm=request.getParameter("nm");
String em=request.getParameter("em");
String pw=request.getParameter("pw");
String ph=request.getParameter("ph");

try
{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:DSN1");
    PreparedStatement ps=con.prepareStatement("insert into regs values(?,?,?,?,?)");
    ps.setInt(1, id);
    ps.setString(2, nm);
    ps.setString(3, em);
    ps.setString(4, pw);
    ps.setString(5, ph);

    int i=ps.executeUpdate();
%>
    <%@ include file="Registration.html" %>
<%
    out.println("Insert Data SuccessFully...");
}
catch(Exception e)
{
    out.println(e);
}

%>

 

Display.jsp

<%@ include file="Registration.html" %>
<%@ page import="java.sql.*,java.io.*" %>

<%

response.setContentType("text/html");

try
{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:DSN1");

    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from regs");
    out.println("<table border=1>");
    out.println("<tr><th>Id</th><th>Name</th><th>Email</th><th>Password</th><th>Phone</th></tr>");
    while(rs.next())
    {
        String id=rs.getString("Id");
        String nm=rs.getString("Name");
        String em=rs.getString("Email");
        String pw=rs.getString("Pass");
        String ph=rs.getString("Phone");

        out.println("<tr><td>"+id+"</td><td>"+nm+"</td><td>"+em+"</td><td>"+pw+"</td><td>"+ph+"</td></tr>");
    }
    out.println("</table>");
}
catch(Exception e)
{
    out.println(e);
}

%>

 

 

 

Comments

Post a Comment

Popular posts from this blog

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

-
Answer:   a. Identify the most likely reason why I could not enter the execute stage until the fourth cycle. One likely reason an instruction couldn't enter the execute stage until the fourth cycle is due to data hazards or resource conflicts: 1. Data Hazards: If the instruction depends on the result of a previous instruction that hasn't completed yet, it cannot proceed to the execute stage. This is often referred to as a Read After Write (RAW) hazard. 2. Resource Conflicts: If the required functional unit for execution (e.g., an ALU) is occupied by another instruction, the instruction will have to wait until the resource becomes available. b. Will "in-order issue/out-of-order completion" or "out-of-order issue/out-of-order completion" fix this? If so, which? Explain In-order issue/out-of-order completion  might help if the problem is related to instructions that can complete earlier being delayed by instructions that take longer to execute. This allows the...
Read more

20.factorial using for loop

-
 // factorial using for loop import java.util.*; class factorial { public static void main(String arg[]) { int f = 1, no, a; Scanner obj = new Scanner(System.in); System.out.print("Enter any number : "); no = obj.nextInt(); for(a = 1; a <= no; a++) { f = f * a; } System.out.println("Factorial : " +f); } }
Read more

JFrame find odd/even

-
Image
 //JFrame class import java.awt.*; import java.awt.event.*; import javax.swing.*; class MyJFrame extends JFrame implements ActionListener {     Container con;     JLabel lbl1;     JTextField txt1;     JButton btn1;     MyJFrame(String title)     {         super(title);         con = new Container();         con.setLayout(new FlowLayout());         lbl1 = new JLabel("Number");         con.add(lbl1);         txt1 = new JTextField(10);         con.add(txt1);         btn1 = new JButton("Odd/Even");         btn1.addActionListener(this);         con.add(btn1);         add(con...
Read more