NETBEANS OJDBC CONNECTION

HTML FILE

Sign up






Fill your details
 
UName

Password


                                 

JSP FILE

NOTE : CHANGE CRYPTO PC TO YOUR BELOVED HOSTNAME (MINE WAS CRYPTO-PC ) CHANGE TO YOURS THIS LINE [“jdbc:oracle:thin:@HOSTNAME:1521:XE”,”USERNAME”,”PASSWORD” ]

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

try
{
    ResultSet rs =null;
            Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection con=    DriverManager.getConnection("jdbc:oracle:thin:@Crypto-PC:1521:XE","panda","piggy");
        Statement stmt=con.createStatement();
    String uname=request.getParameter("uname");
    String pswd=request.getParameter("pswd");
    stmt.executeUpdate("insert into signin values('"+uname+"','"+pswd+"')");
        response.sendRedirect("newhtml.html");
        
    con.close();
    stmt.close(); 
}
 
catch(ClassNotFoundException e)
{
    out.println(e.getMessage());
} %>