this html code "register-1.jsp"
enter code here <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <title> register </title> </head> <body> <div style="height:70%;width:100%"> <img src="back.png"> <br><br><br><br> <form action="insert.jsp" method="post"> <div style="height:200px;width:200px;float:left;clear:none;position:relative;margin-top:-500px;margin-left:200px"> <ul style="list-style:none;font-size:30px;font-family:berlin sans fb"> <li> first name: </li> <li> last name: </li> <li> email: </li> <li> phone no:</li> <li> username: </li> <li> dob: </li> <li> gender: </li> <li> password: </li> <li> confirm password: </li> </ul> </div> <div style="height:200px;width:400px;float:right;margin-right:500px;clear:none;position:relative;margin-top:-500px"> <ul style="list-style:none;font-size:28px"> <li> <input type="text" name="fname"> </li> <li> <input type="text" name="lname"> </li> <li> <input type="text" name="email"> </li> <li> <input type="text" name="phone"> </li> <li> <input type="text" name="username"> </li> <li> <select name="day"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> <select name="month"> <option value="jan">jan</option> <option value="feb">feb</option> <option value="mar">mar</option> <option value="apr">apr</option> <option value="may">may</option> <option value="june">june</option> <option value="july">july</option> <option value="aug">aug</option> <option value="sept">sept</option> <option value="oct">oct</option> <option value="nov">nov</option> <option value="dec">dec</option> </select> <select name="year"> <option value="1990">1990</option> <option value="1991">1991</option> <option value="1992">1993</option> <option value="1994">1994</option> <option value="1995">1995</option> <option value="1996">1996</option> <option value="1997">1997</option> <option value="1998">1998</option> <option value="1999">1999</option> <option value="2000">2000</option> </select> </li> <li style="font-size:20px;padding:5px 5px 3px 5px"> <input type="radio" value="male" name="gender">male <input type="radio" value="female">female </li> <li> <input type="password" name="temp"> </li> <li> <input type="password" name="password"></li> </ul> </div> <br> <p style="clear:both;margin-left:350px;margin-top:-150px"> <input type="submit" value="submit" style="font-size:23px;background-color:#aaaaaa"></p> </form> </div> </body> </html> this "insert.jsp" file
enter code here <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <%@page import="java.sql.*,java.io.*,java.lang.string,java.util.*" %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <% string site = "" ; connection conn; statement st; resultset rs; string fname=request.getparameter("fname"); string lname=request.getparameter("lname"); string email=request.getparameter("email"); string phone=request.getparameter("phone"); string username=request.getparameter("username"); string gender=request.getparameter("gender"); string password=request.getparameter("password"); string temp=request.getparameter("temp"); string day=request.getparameter("day"); string month=request.getparameter("month"); string year=request.getparameter("year"); int i=0; try{ class.forname("com.mysql.jdbc.driver"); conn=drivermanager.getconnection("jdbc:mysql://localhost:3306/dbms_project","root","kanishk"); st=conn.createstatement(); if(temp.compareto(password)==0) { i=st.executeupdate("insert signup(fname,lname,email,phone,username,gender,password,day,month,year) values('"+fname+"','"+lname+"','"+email+"','"+phone+",'"+username+"','"+gender+"','"+password+"','"+day+"','"+month+"','"+year+")"); } if(i>0){ site = "http://www.google.com" ; response.setstatus(response.sc_moved_temporarily); response.setheader("location", site); system.out.println(i); } else { system.out.println(i); } } catch(exception e) { e.printstacktrace(); } %> this log found:
mar 30, 2016 4:45:00 pm org.apache.catalina.core.aprlifecyclelistener init info: apr based apache tomcat native library allows optimal performance in production environments not found on java.library.path: c:\program files (x86)\java\jre7\bin;c:\windows\sun\java\bin;c:\windows\system32;c:\windows;c:/program files (x86)/java/jre1.8.0_73/bin/client;c:/program files (x86)/java/jre1.8.0_73/bin;c:/program files (x86)/java/jre1.8.0_73/lib/i386;c:\winavr-20100110\bin;c:\winavr-20100110\utils\bin;c:\programdata\oracle\java\javapath;c:\windows\system32;c:\windows;c:\windows\system32\wbem;c:\windows\system32\windowspowershell\v1.0\;c:\program files (x86)\common files\lenovo\easyplussdk\bin;c:\program files (x86)\gtk2-runtime\lib;c:\program files (x86)\java\jdk1.7.0_51\bin;e:\eclipse all\eclipse all\eclipse;;. mar 30, 2016 4:45:00 pm org.apache.tomcat.util.digester.setpropertiesrule begin warning: [setpropertiesrule]{server/service/engine/host/context} setting property 'source' 'org.eclipse.jst.jee.server:j2ee' did not find matching property. mar 30, 2016 4:45:00 pm org.apache.tomcat.util.digester.setpropertiesrule begin warning: [setpropertiesrule]{server/service/engine/host/context} setting property 'source' 'org.eclipse.jst.jee.server:web' did not find matching property. mar 30, 2016 4:45:00 pm org.apache.tomcat.util.digester.setpropertiesrule begin warning: [setpropertiesrule]{server/service/engine/host/context} setting property 'source' 'org.eclipse.jst.jee.server:aptech' did not find matching property. mar 30, 2016 4:45:00 pm org.apache.tomcat.util.digester.setpropertiesrule begin warning: [setpropertiesrule]{server/service/engine/host/context} setting property 'source' 'org.eclipse.jst.jee.server:dbms_project' did not find matching property. mar 30, 2016 4:45:00 pm org.apache.coyote.abstractprotocol init info: initializing protocolhandler ["http-bio-8080"] mar 30, 2016 4:45:00 pm org.apache.coyote.abstractprotocol init info: initializing protocolhandler ["ajp-bio-8009"] mar 30, 2016 4:45:00 pm org.apache.catalina.startup.catalina load info: initialization processed in 607 ms mar 30, 2016 4:45:00 pm org.apache.catalina.core.standardservice startinternal info: starting service catalina mar 30, 2016 4:45:00 pm org.apache.catalina.core.standardengine startinternal info: starting servlet engine: apache tomcat/7.0.40 mar 30, 2016 4:45:01 pm org.apache.coyote.abstractprotocol start info: starting protocolhandler ["http-bio-8080"] mar 30, 2016 4:45:01 pm org.apache.coyote.abstractprotocol start info: starting protocolhandler ["ajp-bio-8009"] mar 30, 2016 4:45:01 pm org.apache.catalina.startup.catalina start info: server startup in 500 ms java.lang.classnotfoundexception: com.mysql.jdbc.driver @ org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1714) @ org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1559) @ org.apache.jasper.servlet.jasperloader.loadclass(jasperloader.java:126) @ org.apache.jasper.servlet.jasperloader.loadclass(jasperloader.java:63) @ java.lang.class.forname0(native method) @ java.lang.class.forname(unknown source) @ org.apache.jsp.insert_jsp._jspservice(insert_jsp.java:98) @ org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70) @ javax.servlet.http.httpservlet.service(httpservlet.java:728) @ org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:432) @ org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:390) @ org.apache.jasper.servlet.jspservlet.service(jspservlet.java:334) @ javax.servlet.http.httpservlet.service(httpservlet.java:728) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:953) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:408) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1008) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589) @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:310) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) there no compilation error, , html code runs fine. hit "submit", in html form, table "signup" doesn't update, , not able redirect page. kindly me out.
Comments
Post a Comment