Total members 11889 |It is currently Thu Mar 28, 2024 6:42 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





I am trying to develope a Application using Java Swing,JDBC & My Sql. Now I am unable to do recordset paging. i.e I want to show 10 records at a time . Then I will press next for next 10 Records. I also want to give some page number in a Jbutton Dynamicaly to go directly to that set of 10 records. Please give me solution.

Happy Coding
Karumanchi




Author:
Newbie
User avatar Posts: 4
Have thanks: 0 time

hi my friend,
i made the paging before in a web application i wrote before ,here is the function that do this :
java code
public String DoFilmSearch(String page) throws IOException
{

String returnTable = "";

if(page==null)page="1";
int mypage=Integer.parseInt(page);
int myBase=(limit*mypage)-limit;
int myLimit=(limit);
boolean flag=false;
try{
try {
Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost/subarabia?user=root&password=11991199");

Statement statement = connection.createStatement();

String sql="Select Films.FILM_ID,FILM_NAME As 'Film name' ,COUNT(TRGMA_ID)As 'Subtitles' ,FILM_YEAR" +
" from Films Left join Trgma on(Films.FILM_ID=Trgma.FILM_ID) where FILM_NAME like('%"+Filmname+"%')" +
" group by FILM_NAME,FILM_YEAR order by 'Film name' ,Subtitles limit "+myBase+","+myLimit+ ";";
ResultSet myresult= (ResultSet) statement.executeQuery(sql);

ResultSetMetaData myMetaData =(ResultSetMetaData) myresult.getMetaData();
int size=myMetaData.getColumnCount();


returnTable= "<table >";
returnTable+="<tr >";
for(int i=2;i<=size-1;i++)
{
returnTable+="<th>"+myMetaData.getColumnName(i)+"</th>";
}
returnTable+="</tr>";

while(myresult.next())
{
returnTable+="<tr>";

flag=true;
returnTable+="<td><a href=FilmTrgma.jsp?FILM_ID="+myresult.getString(1)+">"+myresult.getString(2)+"</a> ("+myresult.getString(4)+")"+"</td>";
returnTable+="<td>"+myresult.getString(3)+"</td>";


returnTable+="</tr>";
}
if(!flag)
returnTable+="<tr><td colspan=2> No results found </td></tr>";

sql="Select COUNT(FILM_ID) from Films where FILM_NAME like('%"+Filmname+"%')";
myresult= (ResultSet) statement.executeQuery(sql);
myresult.next();
returnTable+="<tr><td colspan=2>Page: ";
int count=myresult.getInt(1);
int i=0;
while(count>0)
{
i++;
if(i!=Integer.parseInt(page))
returnTable+="<a href=FilmSearchResult.jsp?page="+i+"&&Filmname="+Filmname+">"+i+"</a>|";
else
returnTable+="<u>"+i+"</u>|";
count-=limit;
}
returnTable+="</table> ";
connection.close();
statement.close();

}

catch (SQLException ex) {
ex.printStackTrace();
}

return returnTable;


}


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 2 posts ] 

  Related Posts  to : Paging in Java
 XML Paging Code     -  
 Paging problem in php     -  
 paging JPA Query result     -  
 2d game in java-Monster-Java 2D Game Graphics and Animation     -  
 Using FTP in java     -  
 what is java     -  
 Java course     -  
 What is Java API?!!!     -  
 java or .net     -  
 need help in java     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com