hi im getting an error wen i give this syntax in order to retrieve info from my db into a txt box
<input type="text" name="tname" <%out.println(rs.getString(1));%>/>
pls help
nazd28 0 Newbie Poster
Recommended Answers
Jump to Post@nazd28 please full sentence English. It part of the rules of this forum, take this as unofficial warning.
Jump to PostDifficult to say what is problem as we do not know what the first page look like
PS: Database connectivity should be handled by servlet not by page it self.
All 8 Replies
Thirusha 20 Posting Whiz
try this:
<input type="text" name="tname" value='<%out.println(rs.getString(1));%>'/> nazd28 0 Newbie Poster
Hello i tried the code but now the problem is that when i click the delete button the record isnt getting delete please can u help thanks alot
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
@nazd28 please full sentence English. It part of the rules of this forum, take this as unofficial warning.
nazd28 0 Newbie Poster
<%@ page language="java" import="java.sql.*" %>
<%
String c[]=request.getParameterValues("chbox");
Connection con = null;
Statement stmt = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:datasrc");
stmt = con.createStatement();
for(String s:c)
{
String qy = "delete * from Table1 where id='"+s+"' ";
stmt.executeUpdate(qy);
out.println("Successfully Deleted");
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
%> nazd28 0 Newbie Poster
After selecting the items i want to delete (using check boxes) i click the delete button. the control is transfered to another jsp page called delete.jsp(the code for that page is attached below). After clicking the button i get a page sayin null basically my control is passed to the catch. Can u pls help solve this prob
<%@ page language="java" import="java.sql.*" %> <% String c[]=request.getParameterValues("chbox"); Connection con = null; Statement stmt = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:datasrc"); stmt = con.createStatement(); for(String s:c) { String qy = "delete * from Table1 where id='"+s+"' "; stmt.executeUpdate(qy); out.println("Successfully Deleted"); } } catch(Exception e) { out.println(e.getMessage()); } %>
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
Difficult to say what is problem as we do not know what the first page look like
PS: Database connectivity should be handled by servlet not by page it self.
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
Difficult to say what is problem as we do not know what the first page look like
PS: Database connectivity should be handled by servlet not by page it self.
nazd28 0 Newbie Poster
Hi i am enclosing all the codes used by me
HTML code first page
<html>
<head runat="server">
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<title> Delete an anniversary </title>
<script>
function chk ()
{
if(document.frm.fn.value=="")
{
element = document.getElementById("fn");
element.style.color = "red";
element.focus();
alert("in");
}
}
//to check last name
function chkln ()
{
if(document.frm.ln.value=="")
{
element = document.getElementById("ln");
element.style.color = "red";
element.focus();
alert("in");
}
}
function validate()
{
if ((document.frm.fn.value=="")&& (document.frm.ln.value==""))
{
alert("Both boxes are blank");
}
else if ((document.frm.fn.value=="")||(document.frm.ln.value==""))
{
alert("One of the boxes is blank");
}
}
</script>
</head>
<body>
<div id="wrapper">
<div id="header">
<div id="menu">
<ul>
<li><a href="birthdayandanniversarymainpage.html">Anniversary and Birthday</a></li>
<li><a href="#">Reminder</a></li>
<li><a href="#">Address book</a></li>
</ul>
</div>
<!-- end #menu -->
</div> <!-- end #header -->
<div id="logo">
<h1><a href="#">Date reminder</a></h1>
</div>
<hr />
<!-- end #logo -->
<!-- end #header-wrapper -->
<div id="page">
<div id="content">
<div class="post">
<br>
<h2 class=title> <ahref > Delete an anniversary </a> </h2>
<form name="frm" id="frm" onsubmit="validate()" action="deleteanniversary.jsp">
<h2 > <a> First name </a> </h2><input type="text" name="fn" id="fn" onblur= "chk()" ONKEYPRESS="if ((event.keyCode < 64) || (event.keyCode > 92) && (event.keyCode < 96) ||
(event.keyCode > 122) ) event.returnValue = false;"" />
<br><br>
<h2 > <a > Last name </a> </h2> <input type="text" name="ln" id="ln" onblur= "chkln()" ONKEYPRESS="if ((event.keyCode < 64) || (event.keyCode > 92) && (event.keyCode < 96) ||
(event.keyCode > 122) ) event.returnValue = false;"" />
<br />
<br>
<input type="reset" name="btreset" />
<input type="submit" name="submit" value="Submit" onclick="checkform();" />
</div>
</div>
<!-- end #content -->
<div id="sidebar">
<ul>
<li>
<h2>Birthday Facts</h2>
<br>
<a href="mainpage.html">More >> </a>
</li>
<li>
<h2>Anniversary Facts</h2>
<br>
<a href="Birthstone\starsignstonepage.html">More >> </a>
</li>
<li>
<li>
</div>
<!-- end #sidebar -->
<div style="clear: both;"> </div>
</div>
<!-- end #page -->
</div>
</form>
</body>
</html>Deleteanniversary.jsp Code
<html>
<head runat="server">
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<title> Delete an anniversary </title>
<script>
</script>
</head>
<body>
<form name=frm >
<div id="wrapper">
<div id="header">
<div id="menu">
<ul>
<li><a href="birthdayandanniversarymainpage.html">Anniversary and Birthday</a></li>
<li><a href="#">Reminder</a></li>
<li><a href="#">Address book</a></li>
</ul>
</div>
<!-- end #menu -->
</div> <!-- end #header -->
<div id="logo">
<h1><a href="#">Date reminder</a></h1>
</div>
<hr />
<!-- end #logo -->
<!-- end #header-wrapper -->
<div id="page">
<div id="content">
<div class="post">
<br>
<h2 class=title> <ahref > Delete an anniversary </a> </h2>
<table width="100%"border="1" >
<tr>
<th> Name</th>
<th>Anniversay date</th>
<th>Email</th>
<th>Mobileno</th>
<th> Delete </th>
</tr>
</form>
<%@ page language="java" import="java.sql.*" %>
<%int j=0;
String fname;
String lname;
lname=request.getParameter("ln");
fname=request.getParameter("fn");
Connection con =null;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con=DriverManager.getConnection("jdbc:odbc:datasrc");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from Table1 where fn LIKE '"+fname+"%'");
while (rs.next())
{
%>
<tr><td align="center">
<%=rs.getString(1)%> <%=rs.getString(2)%>
</td>
<td align="center">
<%=rs.getString(3)%> / <%=rs.getString(4)%> / <%=rs.getString(5)%>
</td>
<td align="center">
<%=rs.getString(6)%>
</td>
<td align="center">
<%=rs.getString(7)%>
</td>
<%String id=rs.getString(8);%>
<td ><input type="checkbox" name="chbox" value="<%=id%>"/></td>
</tr>
<%} %>
<br>
<br>
</table>
<form action="delete2.jsp">
<input type="submit" name="b1" value="Delete" >
</form>
<br>
<br>
</div>
</div>
</div>
</body>
</html>
delete.jsp Code
<%@ page language="java" import="java.sql.*" %>
<%
String c[]=request.getParameterValues("chbox");
Connection con = null;
Statement stmt = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:datasrc");
stmt = con.createStatement();
for(String s:c)
{
String qy = "delete * from Table1 where id='"+s+"' ";
stmt.executeUpdate(qy);
out.println("Successfully Deleted");
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>The problem arrives in delete.jsp as the values of the checkbox arent accessible here. it goes to the catch block & displays null and even if i print String c[] it doesnt give me anything. Please can you help
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.