java - Client side data not displaying on webpage? -


when viewing ,view page source shows data.on webpage it's not rendering full data. this actually has thiswhile viewing view page source , 1 more when click delete shows meit throws exception new learning java servlet , new programming language also.i didn't get-tin on did mistake? don't know how prevent query string getting unnecessary value. please me on this?

<pre><code> package com.jspiders.studentsapp.servlets; import java.io.ioexception; import java.io.printwriter; import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.sqlexception; import java.sql.statement;  import javax.servlet.servletexception; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse;    import com.mysql.jdbc.driver;      public class viewallstudentdelete extends httpservlet {     protected void doget(httpservletrequest req, httpservletresponse resp) throws servletexception, ioexception      {             resp.setcontenttype("text/html");             printwriter out=resp.getwriter();      system.out.println("mime type set");          connection con = null;         resultset rs = null;         statement stmt = null;          try {             driver driverref = new driver();             drivermanager.registerdriver(driverref);             string dburl = "jdbc:mysql://localhost:3306/becm145_db?user=root&password=root";             con = drivermanager.getconnection(dburl);              string query = "select * students_info si,students_otherinfo so,guardian_info gi"                     + " si.regno=so.regno , so.regno=gi.regno";              stmt = con.createstatement();             rs = stmt.executequery(query);               out.println("<html>"                          + "<body>"                   + "<table border=\"1\"width=\"100%\" >"                  +"<tr ><th>regno</th><th>first name</th><th>middle name</th><th>last name</th><th>is admin</th><th>password</th><th>gfirst name</th><th>gmiddle name</th><th>glast name</th><th>delete</th> </tr>");              while(rs.next())              {                  int regno=rs.getint("regno");//integer.parseint(req.getparameter("regno"));                 string fnm=rs.getstring("firstname");                    string mnm=rs.getstring("middlename");                    string lnm=rs.getstring("lastname");                    string admin=rs.getstring("isadmin");                    string passw=rs.getstring("password");                    string gfnm=rs.getstring("gfirstname");                    string gmnm=rs.getstring("gmiddlename");                    string glnm=rs.getstring("glastname");                     out.println("<tr><td>"                                + regno                              +"</td><td>"                              + fnm                              +"</td><td> "                              +mnm                              +"</td><td>"                              +lnm                              +"</td><td>"                              +admin                              +"</td><td>"                              +passw                              +"</td><td>"                              +gfnm                              +"</td><td>"                              +gmnm                              +"</td><td>"                              +glnm                              +"</td><td>"                              +"<a href=\"./deleteservlet?regno="                              +regno                              +" >delete</a></td></tr>");                           }             out.print("</table>"                  +"</body>"                       +"</html>");         } catch (exception e) {             e.printstacktrace();          } {             system.out.println("close jdbc objects");         }          try {             if (con != null) {                 con.close();             }             if (stmt != null) {                 stmt.close();              }             if (rs != null) {                 rs.close();              }         }          catch (sqlexception e) {             e.printstacktrace();         }      }      }  </pre></code> 

  
package com.jspiders.studentsapp.servlets;  import java.io.ioexception; import java.io.printwriter; import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.sqlexception; import java.sql.preparedstatement;  import javax.servlet.servletexception; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse;  import com.mysql.jdbc.driver; public class deleteservlet extends httpservlet {         protected void doget(httpservletrequest req, httpservletresponse resp) throws servletexception, ioexception     {                 resp.setcontenttype("text/html");                 printwriter out=resp.getwriter();                 int regno=integer.parseint(req.getparameter("regno"));          system.out.println("mime type set");              connection con = null;             resultset rs = null;             preparedstatement pstmt = null;             preparedstatement pstmt1 = null;             preparedstatement pstmt2 = null;             int count,count1,count2 =0;             try {                 driver driverref = new driver();                 drivermanager.registerdriver(driverref);                 string dburl = "jdbc:mysql://localhost:3306/becm145_db?user=root&password=root";                 con = drivermanager.getconnection(dburl);                  string query = "delete students_info  regno=?";                  string query1 =   "delete students_otherinfo  regno=? ";               string query2=" delete guardian_info  regno=? ";//garbage collector call finalize before garbage collected when space full or reach level @ time garbage call finalize , collected                  pstmt = con.preparestatement(query);                 pstmt.setint(1,regno);                  count = pstmt.executeupdate();                 pstmt1 = con.preparestatement(query1);                 pstmt1.setint(1,regno);                 count1 = pstmt1.executeupdate();                 pstmt2 = con.preparestatement(query2);                 pstmt2.setint(1,regno);                 count2 = pstmt2.executeupdate();                 if(count == 1 && count1 == 1 && count2 == 1)                 {                     out.println("<h1>profile ,is deleted</h1>");                 }                 else                 {                     out.println("<h1>failed in deleting profile</h1>");                    }              } catch (exception e) {                 e.printstacktrace();              } {                 system.out.println("close jdbc objects");             }              try {                 if (con != null) {                     con.close();                 }                 if (pstmt != null) {                     pstmt.close();                  }                 if (rs != null) {                     rs.close();                  }             }              catch (sqlexception e) {                 e.printstacktrace();             }          }          }


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more