how to display data from database on jsp using struts2

priyanka jaiswal

Greenhorn

Posts: 2

posted 12 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

This is My class where database connection and other databasequery gets executed....

import java.sql.SQLException;
import java.util.*;

import javax.naming.NamingException;

public class Student{
	
	 public List<Student1> selectdbt()
	 {
		 List<Student1> result =new ArrayList<Student1>();
		
		  try {
			      Connection conn=DBConn.connect(); 
			      System.out.println("DATABASE CONNECTED");
				try
				{
					
					String str= "select * from student";
					PreparedStatement ps = conn.prepareStatement(str);
					ResultSet rs =null;
					rs=ps.executeQuery();
					Student1  st=null;  
					   while (rs.next()) {		
						  st=new Student1();
						           st.setId(rs.getString(1));  
						           st.setName(rs.getString(2));  
						           st.setCourse(rs.getString(3));  
						  	      result.add(st);
						  	      
						  	}
					 }
					
					finally
					{
		                conn.close();
		            }
		        } 
				catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (NamingException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				for(int i=0;i<result.size();i++)
				{
					System.out.println("RESULTS:"+result);
				}
				
				 System.out.println("I M INSIDE STUDENT JAVA");
		return result;
	   }
}

this is my action class............for student

next is ma jsp page where i want to display d data .....

i m not getting any error but nuthing is getting displayed on my jsp page.....

hey can anybody please help me out with this problem.

Thanks in advance

priyanka jaiswal.

Joe Ess

Bartender

Posts: 9626

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I added code tags to your post to make it easier to read. Please UseCodeTags in the future.
I see your JSP references an action property named "list" but you don't have a method to get the list from your action class.
Your action class is confusing as it appears to be both a data object (containing attributes for each student instance) and an action method (execute).

[How To Ask Questions On JavaRanch]

priyanka jaiswal

Greenhorn

Posts: 2

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks for respose...
yes i have written action method in same class....bt when i created a diffrent actionclass there wasnt ny diffrence..the result was same....

actully i am very new to the technology not even worked on sturts1 ..so didnt have any idea....
and about the list ...i am not getting..where shuld i create a method nw.i reffered many examples.it was same as it is....jst can you help me out where i am getting wrong.
Really stucked with particular part of code

...

Thanks
priyanka jaiswal

Joe Ess

Bartender

Posts: 9626

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Are you new to Java as well (it looks like it)? You should start off with the Java Tutorial. It will be very difficult to write a web application in Java without understanding the basics of the language.
If you are new to web programming, you should read over the Struts Key Technologies. Again, without a basic understanding what is going underneath the covers, you will very easily lose your way.
After getting a good foundation, try reading through the pointers on our Struts 2 FAQ. There are many good tutorials and references available for Struts 2. We would love to help you, but if you haven't completed Step 1 and want to jump to Step 10, you will be setting yourself up for a lot of frustration and failure.
NOTE: Struts 2 has little to do with Struts 1, so it is not necessary to know one before learning the other.

[How To Ask Questions On JavaRanch]

Consider Paul's rocket mass heater.