15
hi,
i hav "java.lang.NullPointerException" error while Deleting table records using checkbox in jsp here i enclosed files help quickly plzzz..
Regards
Ramprakash
/*Adminpage.jsp*/
<%@ page language="java" import="java.sql.*"%>
<html>
<head>
<title>Admin Page</title>
<script language="javascript">
function validation()
{
var count=0;
for(vari=0;i<admin.chbox.length;i++)
{
if(admin.chbox[i].checked)
{
count++;
}
}
if(count==0)
{
alert("check the messages to delete & u had limited msg");
//document.msgchbox.checkbox.focus();
return false;
}
else
{
return true;
}
}
</script>
</head>
<body>
<form name="admin" method="post" action="deletepage.jsp" onClick="return validation()">
<h2 align="center">Freshers Table Records</h2>
<div align="right"><input type="submit" value=" DELETE "/> & nbsp;
</div>
<div>
<table border="3" width="95%">
<tr>
<td width="14%"> Date</td>
<td width="32%">Name</td>
<td width="40%">Email Id</td>
<td width="14%">Contact No</td>
</tr></table>
</div>
</form>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ram","root","sun");
stmt = con.createStatement();
String qy = "select * from userinfofresher";
rs = stmt.executeQuery(qy);
while(rs.next())
{
%>
<table width="95%">
<tr><td width="3%"><input type="checkbox" name="chbox" value="<%=rs.getString(3)%>"/></td>
<td width="12%"><%=rs.getString(33)%></td>
<td width="33%"><%=rs.getString(1)%></td>
<td width="41%"><%=rs.getString(2)%></td>
<td width="15%"><%=rs.getString(3)%></td>
</tr></table>
<%
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
/*deletepage.jsp*/
<%@ page language="java" import="java.sql.*"%>
<html>
<head>
<title>Delete page</title>
</head>
<body>
<%
String c[]= request.getParameterValues("chbox");
out.println(c[0]);
Connection con = null;
Statement stmt = null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ram","root","sun");
stmt = con.createStatement();
for(String s:c)
{
String qy = "delete from userinfofresher where emailid='"+s+"' ";
stmt.executeUpdate(qy);
out.println("Successfully Deleted");
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
/*db file */
/*
MySQL Data Transfer
Source Host: localhost
Source Database: ram
Target Host: localhost
Target Database: ram
Date: 3/2/2009 4:03:02 PM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for userinfofresher
-- ----------------------------
DROP TABLE IF EXISTS `userinfofresher`;
CREATE TABLE `userinfofresher` (
`name` varchar(255) NOT NULL,
`emailid` varchar(255) NOT NULL,
`contno` varchar(255) NOT NULL,
`tds` varchar(255) NOT NULL,
`ta` varchar(255) NOT NULL,
`tc` varchar(255) NOT NULL,
`tz` varchar(255) NOT NULL,
`pds` varchar(255) NOT NULL,
`pa` varchar(255) NOT NULL,
`pc` varchar(255) NOT NULL,
`pz` varchar(255) NOT NULL,
`fathersname` varchar(255) NOT NULL,
`sex` varchar(255) NOT NULL,
`dob` varchar(255) NOT NULL,
`age` varchar(255) NOT NULL,
`bloodgroup` varchar(255) NOT NULL,
`nationality` varchar(255) NOT NULL,
`matrialstatus` varchar(255) NOT NULL,
`language` varchar(255) NOT NULL,
`sslc` varchar(255) NOT NULL,
`hsc` varchar(255) NOT NULL,
`degree1` varchar(255) NOT NULL,
`degree2` varchar(255) NOT NULL,
`degree3` varchar(255) NOT NULL,
`degree4` varchar(255) NOT NULL,
`software` varchar(255) NOT NULL,
`ipt` varchar(255) NOT NULL,
`aoi` varchar(255) NOT NULL,
`projtitle` varchar(255) NOT NULL,
`projdes` longtext NOT NULL,
`ach` varchar(255) NOT NULL,
`hobby` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `userinfofresher` VALUES ('RAMPRAKASH K A', 'ramprakash.java@gmail.com', ' 9787818096', 'No 8,First cross st', 'Annanagar West', 'Chennai', '600078', 'No 5/E, cross st', 'West pillaiyar koil st', 'Trichy', '638478', 'Arun K P', 'Male', '03nov1982', '21', 'O+ve ', 'Indian', 'Unmarried', 'Tamil,English', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', ' 2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '2002-2005 Bachelor of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -74%', '', '', 'C,java/j2ee', 'HCL technologies,Ambattur,Chennai.', 'web Developement', 'Vendor Information Management System.', 'The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.The VIMS deals with the Online Ship store management system.It is an bridge between the supplier and the ship.', 'Won the First Prize for Paper Presentation held on Sankara College-Coimbatore', 'Reading books,Playing cricket', '2009-2-13');
INSERT INTO `userinfofresher` VALUES ('ram', 'ramprakash_ka@yahoo.co.in', '5454418745', '5,dsghjkghdjkafjf', 'gkjdflgkdfj', 'mvn', '54655646', '6,ssjkfhjhdfjjl', 'lkbv', 'ijhgjkdfh', '624654', 'kdfjnbio', 'male', '03nov1992', '23', 'b+ve', 'indian', 'single', 'nmkgnkg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '', '', '', 'c,java', 'bknjknsghitjkn dfgkjhdfkghjk', 'mgmkjgl', 'automatic alaram', 'bvdbdnm n m\r\nsdnslfnksl\r\nvcslmklgmdklm\r\nvdfm,;dm\r\nvm vd', 'jnmnjkgj', 'video game', '2009-2-12');
INSERT INTO `userinfofresher` VALUES ('ram', 'ramprakash_kas@yahoo.co.in', '5454418745', '5,dsghjkghdjkafjf', 'gkjdflgkdfj', 'mvn', '54655646', '6,ssjkfhjhdfjjl', 'lkbv', 'ijhgjkdfh', '624654', 'kdfjnbio', 'male', '03nov1992', '23', 'b+ve', 'indian', 'single', 'nmkgnkg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '', '', '', 'c,java', 'bknjknsghitjkn dfgkjhdfkghjk', 'mgmkjgl', 'automatic alaram', 'bvdbdnm n m\r\nsdnslfnksl\r\nvcslmklgmdklm\r\nvdfm,;dm\r\nvm vd', 'jnmnjkgj', 'video game', '2009-2-11');
INSERT INTO `userinfofresher` VALUES ('ram', 'ramprakash_k@yahoo.co.in', '5454418745', '5,dsghjkghdjkafjf', 'gkjdflgkdfj', 'mvn', '54655646', '6,ssjkfhjhdfjjl', 'lkbv', 'ijhgjkdfh', '624654', 'kdfjnbio', 'male', '03nov1992', '23', 'b+ve', 'indian', 'single', 'nmkgnkg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '', '', '', 'c,java', 'bknjknsghitjkn dfgkjhdfkghjk', 'mgmkjgl', 'automatic alaram', 'bvdbdnm n m\r\nsdnslfnksl\r\nvcslmklgmdklm\r\nvdfm,;dm\r\nvm vd', 'jnmnjkgj', 'video game', '2009-2-09');
INSERT INTO `userinfofresher` VALUES ('ram', 'ramprakash_a@yahoo.co.in', '5454418745', '5,dsghjkghdjkafjf', 'gkjdflgkdfj', 'mvn', '54655646', '6,ssjkfhjhdfjjl', 'lkbv', 'ijhgjkdfh', '624654', 'kdfjnbio', 'male', '03nov1992', '23', 'b+ve', 'indian', 'single', 'nmkgnkg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '', '', '', 'c,java', 'bknjknsghitjkn dfgkjhdfkghjk', 'mgmkjgl', 'automatic alaram', 'bvdbdnm n m\r\nsdnslfnksl\r\nvcslmklgmdklm\r\nvdfm,;dm\r\nvm vd', 'jnmnjkgj', 'video game', '2009-2-09');
INSERT INTO `userinfofresher` VALUES ('ram', 'ramprakash@yahoo.co.in', '5454418745', '5,dsghjkghdjkafjf', 'gkjdflgkdfj', 'mvn', '54655646', '6,ssjkfhjhdfjjl', 'lkbv', 'ijhgjkdfh', '624654', 'kdfjnbio', 'male', '03nov1992', '23', 'b+ve', 'indian', 'single', 'nmkgnkg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '', '', '', 'c,java', 'bknjknsghitjkn dfgkjhdfkghjk', 'mgmkjgl', 'automatic alaram', 'bvdbdnm n m\r\nsdnslfnksl\r\nvcslmklgmdklm\r\nvdfm,;dm\r\nvm vd', 'jnmnjkgj', 'video game', '2009-2-08');
INSERT INTO `userinfofresher` VALUES ('fsdfa', 'vdvtgert', '4536767', 'bfgbhgfhf', 'bn fghf', 'fngfn fnj', '76766', 'njfjfh', 'fjgj', 'nmghmjg', '25678', 'vcgrsh', 'fnjgj', 'xcfgjgtj', 'cgmjgj', 'cgnmgh', 'n cvnn', 'jyjtyjy', 'njghnjg', '1997-2000 S.S.L.C (State Board )Govt High School,Karur -87%', '2000-2002 XII Standard (State Board)Govt Higher Secondary School,Karur -82%', '2002-2005 Dipoma in Computer Technology Govt Polytechnic College,Karur -90%', '2002-2005 Bachelor of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -74%', '2005-2007 Master of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -70%', '', 'b fhytyhj', 'nghjdtj', 'ghmj', 'bdfbhfhfhfrhrh', 'hfhdtyjtyhjtjtj2005-2007 Master of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -70%2005-2007 Master of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -70%2005-2007 Master of Computer Science Engineering in St.Joseph?s Engineering College, Anna University,Chennai -70%', 'cmjmkcfku', 'jghjg', '2009-2-05');
