jsp object retrieval

Ads
 

jsp object retrieval

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.

Ads









Related Tutorials/Questions & Answers:
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="" />
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
Advertisements
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
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
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
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
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
Request Object In JSP.
ModuleNotFoundError: No module named 'weather-forecast-retrieval'
ModuleNotFoundError: No module named 'weather-forecast-retrieval'  Hi...: No module named 'weather-forecast-retrieval' How to remove the ModuleNotFoundError: No module named 'weather-forecast-retrieval' error? Thanks
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
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
jsp
jsp  In any jsp all implicit objects are available directly, in such a case why we need PageContext object again
how to generate a bar chart on a JSP PAGE using the arraylist object passed form the servlet.(using jfreechart)
how to generate a bar chart on a JSP PAGE using the arraylist object passed... contains only one object(rollno,name,marks1,marks2,marks3,marks4) from the database.now i have to pass this arraylist object to a jsp page and on that jsp page
JSP
JSP  what are the different scopes an object can have in a jsp page   JSP Scope Variables: Page scope-It makes the data available... the following links: http://www.roseindia.net/jsp/simple-jsp-example
ArrayList object
ArrayList object  i have am ArrayList object it containg data base records in it, now i want to display this ArrayList object data in my jsp programe, plz help me
JSP
on that page 2>>>Please know me about document object and how use document object? how i can get document & elements of registration page?   Hi Friend, Please visit the following links: http://www.roseindia.net/jsp
jsp 18/04/2013
jsp 18/04/2013  how to retrieve collection object in jsp page
JSP Request URI
the request object that will return the URI of the current JSP page. Understand...; request.getRequestURI ( ) method, which return the URI of the request object in the current JSP... JSP Request URI   
JSP
JSP  how did you implement caching in jsp   OSCache... organization. OSCache has a set of JSP tags that make it easy to implement page caching in your JSP application. Following are some Cache techniques
JSP
what is JSP forward tag for  what is JSP forward tag for   It forwards the current request to another JSP page. Below is the syntax for the same:- <jsp:forward page="...url..." /> We can also forward parameter
jsp
jsp  how jsp translated into servlets
JSP
JSP  How to run jsp program in eclipse
jsp
jsp  how to create jsp page
Jsp
Jsp  Can I implement interface in jsp
jsp
jsp  how to include two jsp page
jsp
jsp  how to create a table in oracle using jsp and the table name is entered in text feild of jsp page
jsp
jsp  write a code for jsp file generator to generate a jsp page automatically taking html page as input
JSP
JSP  Hi, What is JSP? What is the use of JSP? Thanks   Hi, JSP Stands for Java Server Pages. It is Java technology for developing web applications. JSP is very easy to learn and it allows the developers to use Java
jsp
jsp  how to connect the database with jsp using mysql   Hi Friend, Please visit the following links: http://www.roseindia.net/jsp/connectjspwith_mysql.shtml http://www.roseindia.net/jsp/Accessingdatabase-fromJSP.shtml
jsp
jsp   what is the basic necessities reguired for running jsp using JDBC bridge?? and how to write a jsp code to access the detail present in microsoft access pls send link regarding above

Ads