Sonny
jsp object retrieval
2 Answer(s)      8 years ago
Posted in : Spring

Ads

View Answers

May 28, 2008 at 9:29 PM


Hi friend,

<%@ page language="java" import="java.sql.*" %>

<html>
<head>
<title>Retrive value from database</title>
</head>
<body>
<table border="1" width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h2><font color="#FF0033">Retrive data from database</font></h2>
<form method="POST" >
<table border="1" width="100%" cellspacing="0" cellpadding="0" bgcolor="#CCFFCC">
<tr>
<td width="50%"><b>User id:</b></td>
<td width="50%"><b>Course Name</b></td>
<td width="50%"><b>Courese Fee</b></td>
<td width="50%"><b>Faculty Name</b></td></tr>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"amar","amar123");
try{
Statement st = con.createStatement();
String query = "SELECT id,coursename,couresefee,facultyname FROM student where id=id";
ResultSet rs = st.executeQuery(query);

while (rs.next()) {
String coun=rs.getString(1);
String coun1=rs.getString(2);
%>
<tr>
<td width="50%"><%=coun%></td>
<td width="50%"><%=coun1%></td>
<td width="50%"><%=rs.getString("couresefee")%></td>

<td width="50%"><%=rs.getString("facultyname")%></td></tr>

<%}

out.println("<br/><a href=RetriveForm.jsp><b>Insert Data page</b></a>");
rs.close();
con.close();

}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>


----------------------------------

Read for more information.

http://www.roseindia.net/jsp/


May 28, 2008 at 9:43 PM


Thanks for the reply but I want to keep the java code out of the jsp.









Related Tutorials/Questions & Answers:
jsp object retrieval - Spring
jsp object retrieval  I have a controller which calls a Service to build a List of data from the database. I want to pass the List to the jsp to use.... However, I am concerned this object could be huge in some instances. Any
Image retrieval in Servlet and JSP
Image retrieval in Servlet and JSP  Sir, How should i give dynamic paths to image in JSP. EX : `<img src="C:\Users\Public\Pictures\Sample Pictures\-------.jpg" alt="" name="image5" width="980" height="320" id="" />
Advertisements
Image retrieval from mysql - JSP-Servlet
Image retrieval from mysql  Hai friends, I used the following code to insert image into mysql db. Db data type is blob. Database connection codings are in different file which is to be included
Dynamic retrieval od data from database and display it in the table at jsp
Dynamic retrieval od data from database and display it in the table at jsp ... the details of 20 members in a table format at jsp page by dynamically retrieving...; Here is a jsp code that retrieves the data from the database and display
How to store data entered in JSP page by a user in XML file & later retrieval of data using id at other page
How to store data entered in JSP page by a user in XML file & later retrieval of data using id at other page  I have made a form in JSP having emp id... in another jsp page using retrieve submit button.Please tell step by step instructions
JSP Out Object
JSP Out Object  JSP Out Object?   out object denotes... of the object out is jsp.JspWriter. The out object "Javax.servlet.jsp.JspWriter". Methods of out Object: clear() clearBuffer() flush() isAutoFlush() getBufferSize
JSP Application Object
JSP Application Object  JSP Application Object?   Application Object is used to share the data with all application pages. Thus, all users.... The Application object is accessed by any JSP present in the application. The class
JSP Response Object
JSP Response Object  JSP response Object ?   The response object denotes the HTTP Response data. The result or the information of a request is denoted with this object. The response object handles the output
JSP Session Object
JSP Session Object  JSP Session Object?   Session Object... or the interface name of the object session is http.HttpSession. The object session is written as: Javax.servlet.http.httpsession. The Session Object provides
Page object - JSP-Servlet
of PAGE object of implicit JSP object. If this is possible explain me about it's methods. I did not find any methods or explanation of this object. Pls help me....  Hi friend, Implicit Objects in JSP are objects
JSP Request Object
JSP Request Object  JSP Request Object ?   request object in JSP is used to get the values that the client passes to the web server during an HTTP request. The request object is used to take the value from the client?s
Retrieval of Dropdown list
Retrieval of Dropdown list  Hi frnds... Am having problem with the below code... I have retrieved data from the mysql database into dropdownlist ... for eg, let A1,A2,A3,A4 be the values in dropdown.. if i click A1
Retrieval data from database against timer
Retrieval data from database against timer  Please send me a sample timer code which retrieve data from the database against timer in JSP
Request Object In JSP
Request Object In JSP       This section illustrates more about the JSP implicit object called... to the server, is received by the HTTP request object of the JSP. To access
JSP implicit object "application"
JSP IMPLICIT OBJECT application In this section, we will discuss about JSP... in an application. It means the "application" object is accessed by any JSP...) : The method log of Application object is used to write a text string to the JSP
get a session object - JSP-Servlet
get a session object  how to do in a table when i click on a radio button i should get the id value which is in the same row and store it in the session this is in jsp when in the servlet if i call a get session i have to get
Bussiness Object API - JSP-Servlet
Bussiness Object API  I m feteching the reports from CMS server and displaying the report on web page . the problem is that displaying a report takes... = (IReportSourceFactory)enterpriseSession.getService("PSReportFactory"); Object
JSP Implicit object "session"
JSP IMPLICIT  OBJECT "SESSION"In this Section , we will discuss about JSP implicit object "session" with an example. Session Object... of object as string's value and you can get this value in other JSP page
JSON array objects retrieval in javascript
JSON array objects retrieval in javascript   I am fetching some data from database and want to show these values in a combo in javascript but combo box is not populating any value, perhaps i am doing something wrong in json
Retrieval column details into respective JComboboxs
Retrieval column details into respective JComboboxs   Hello sir, As of now i created program in the Eclipse the GUI window .I had creaated the GUI window & also i had created the table in MSSQL the differet columns
Pass a dom object from jsp to servlet
Pass a dom object from jsp to servlet  I am creating a dom object in my jsp page. now i want to pass that object in a servlet through calling servlet in jsp. can anyone help me
How to use an object properties in jsp page
How to use an object properties in jsp page  I have a arraylist of objects 'User' populated using struts 2 action class while loading that jsp page. In that JSP I have included another jsp using following tag: Here instead
Read MultipartRequest object twice. - JSP-Servlet
Read MultipartRequest object twice.  Hi, Thanks for your reply for "How to revert back ServletInputStream object after reading once." Q. Now I am facing problem for ServletInputStream object. Can we read stream twice
How to get jSon object in servlet from jsp - JSP-Servlet
How to get jSon object in servlet from jsp  How to get jSon object in servlet from jsp? In jsp page i have written: var sel... object in servlet???  Hi Friend, Please visit the following link
object
object  is it possible to create object in the same class..?.   Yes, you can. class CreateObject { CreateObject(){ System.out.println("I have an object."); } public static void main(String[] args
JSP implicit object out
JSP implicit object out In this Section, we will discuss about implicit object out & it's methods. Out object denotes the Output stream...;jsp.JspWriter". This object is instantiated implicitly from JSP Writer class
Java Xml -Node retrieval - Java Beginners
= xpath.compile("/or:AddOrder/Order/BuyersID"); Object result = expr.evaluate(doc
JSP implicit object "response"
JSP implicit object "response" In this section, we will discuss about JSP implicit object "response" with an example. Using 'response' object , reply is sent back to the browser. It is an implicit object
JSP implicit object "request"
JSP implicit object "request" In this section, we will discuss about... object is used for returning the URL of the current JSP page.Example : ... is  /Jsp/test.jsp. setAttribute(String,Object): This method assigns
JSP implicit object "pagecontext"
JSP IMPLICIT OBJECT  pagecontext A PageContext instance provides access to all the namespaces associated with a JSP page, provides access to several... and pageContext are implicit JSP Objects. The page object represents
Track user's session using 'session' object in JSP
Track user's session using 'session' object in JSP This section is about tracking user identity across different JSP pages using 'session' object. Session Tracking : Session tracking is a mechanism that is used

Ads

Advertisement