jdbc - ExecuteUpdate() hangs and not able to run my program -
jdbc - ExecuteUpdate() hangs and not able to run my program -
i trying jdbc run code servlet .jsp file in netbeans derby database. problem doesn't run beyond "stmt.addbatch(query);" doens't print "hello". have used derby.jar,derbyclient.jar , derbynet.jar in library.
looking forwards hear others.
import java.io.ioexception; import java.io.printwriter; import javax.servlet.servletexception; import javax.servlet.annotation.webservlet; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse; import java.sql.*; import java.io.*; import javax.sql.*; protected void processrequest(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { response.setcontenttype("text/html;charset=utf-8"); printwriter out = response.getwriter(); seek { /* todo output page here. may utilize next sample code. */ out.println("<!doctype html>"); out.println("<html>"); out.println("<head>"); out.println("<title>servlet reg</title>"); out.println("</head>"); out.println("<body>"); string name=request.getparameter("name"); string rate=request.getparameter("rate"); out.println(name); out.println(rate); class.forname("org.apache.derby.jdbc.clientdriver"); connection con=drivermanager.getconnection("jdbc:derby://localhost:1527/sample","app",""); statement stmt=con.createstatement(); string query="insert film values('"+rate+"','" +name+ "')"; stmt.addbatch(query); out.println("hello"); stmt.close(); con.close(); out.println("</body>"); out.println("</html>"); } catch(exception e){ e.printstacktrace(); } { out.close(); } } jdbc netbeans-8
Comments
Post a Comment