Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


debasis
auto resize
2 Answer(s)      3 years and 9 months ago
Posted in : JavaScript Questions


Dear Sir, I have a table with 60 coloumns and 90 rows.If i give the print option it s not comin in one page.Can you please tell me the javascript code for auto resizing it into one window or fit to the window while taking the print.

Regards Debasis


Advertisement
View Answers

December 7, 2010 at 4:43 PM


Hi Friend,

You can do paging using jsp.

Here is the code:

pagination.jsp:

<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
public int nullIntconvert(String str){
int num=0;
if(str==null) {
str="0";
}
else if((str.trim()).equals("null")) {
str="0";
}
else if(str.equals("")) {
str="0";
}
try{
num=Integer.parseInt(str);
}
catch(Exception e) { }
return num;
}
%>
<%
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
ResultSet rs1 = null;
ResultSet rs2 = null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;

int showRows=10;
int totalRecords=10;
int totalRows=nullIntconvert(request.getParameter("totalRows"));
int totalPages=nullIntconvert(request.getParameter("totalPages"));
int iPageNo=nullIntconvert(request.getParameter("iPageNo"));
int cPageNo=nullIntconvert(request.getParameter("cPageNo"));

int startResult=0;
int endResult=0;
if(iPageNo==0) {
iPageNo=0;
}
else{
iPageNo=Math.abs((iPageNo-1)*showRows);
}
String query1="SELECT SQL_CALC_FOUND_ROWS * FROM student limit "+iPageNo+","+showRows+"";
ps1=conn.prepareStatement(query1);
rs1=ps1.executeQuery();

String query2="SELECT FOUND_ROWS() as cnt";
ps2=conn.prepareStatement(query2);
rs2=ps2.executeQuery();
if(rs2.next()) {
totalRows=rs2.getInt("cnt");
}
%>
<html>
<h3>Pagination of JSP page</h3>
<body>
<form>
<input type="hidden" name="iPageNo" value="<%=iPageNo%>">
<input type="hidden" name="cPageNo" value="<%=cPageNo%>">
<input type="hidden" name="showRows" value="<%=showRows%>">
<table width="100%" cellpadding="0" cellspacing="0" border="1" >
<tr>
<td>Roll No</td>
<td>Name</td>
<td>Marks</td>
<td>Grade</td>
</tr>
<%
while(rs1.next()) {
%>
<tr>
<td><%=rs1.getInt("rollNo")%></td>
<td><%=rs1.getString("name")%></td>
<td><%=rs1.getInt("marks")%></td>
<td><%=rs1.getString("grade")%></td>
</tr>
<%
}
%>
<%
try{
if(totalRows<(iPageNo+showRows)) {
endResult=totalRows;
}
else{
endResult=(iPageNo+showRows);
}
startResult=(iPageNo+1);
totalPages=((int)(Math.ceil((double)totalRows/showRows)));
}
catch(Exception e){
e.printStackTrace();
}
%>
<tr>
<td colspan="3">
<div>


December 7, 2010 at 4:44 PM


continue....

<%
int i=0;
int cPage=0;
if(totalRows!=0) {
cPage=((int)(Math.ceil((double)endResult/(totalRecords*showRows))));

int prePageNo=(cPage*totalRecords)-((totalRecords-1)+totalRecords);
if((cPage*totalRecords)-(totalRecords)>0){
%>
<a href="pagination.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>"> << Previous</a>
<%
}
for(i=((cPage*totalRecords)-(totalRecords-1));i<=(cPage*totalRecords);i++){
if(i==((iPageNo/showRows)+1)){%>
<a href="pagination.jsp?iPageNo=<%=i%>" style="cursor:pointer;color: red"><b><%=i%></b></a>
<%
}
else if(i<=totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>"><%=i%></a>
<%
}
}
if(totalPages>totalRecords && i<totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>"> >> Next</a>
<%
}
}
%>
<b>Rows <%=startResult%> - <%=endResult%> Total Rows <%=totalRows%> </b>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
<%
try{
if(ps1!=null){
ps1.close();
}
if(rs1!=null){
rs1.close();
}

if(ps2!=null){
ps2.close();
}
if(rs2!=null){
rs2.close();
}

if(conn!=null){
conn.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>

In the above code,we have created the database table student(rollNo,name,marks,grade).

Thanks



Related Tutorials/Questions & Answers:
auto resize
auto resize  Dear Sir, I have a table with 60 coloumns and 90 rows.If i give the print option it s not comin in one page.Can you please tell me the javascript code for auto resizing it into one window or fit to the window while
auto
auto  write a java code design an auto with as many feature as possible
Advertisements
Objective C resize UIImage
Objective C resize UIImage  i just want to resize the image on the touch detection. That means if a user double clicks on the UIImage it must resize the image
Resize image stored in database
Resize image stored in database  hi, Can any one please send code for how to resize image stored in database in blob datatype in jsp, i want to resize it to 140(w)*160(h) please help me
resize the tiff file - WebSevices
resize the tiff file  please guide me how i resize the tiff file and i want to upload it?   You can resize the tiff image as well as other type image. I am sending code, i hope it will help to you... Thanks
resize a panel slowly - IDE Questions
resize a panel slowly  How to code to resize a panel slowly with netbeans
Image Resize in Flex
Image Resize in Flex  Hi....... I am going to add images into a tag. How will it resize itself? Please tell me about that.... Thanks  Ans: The image resize is the part of laying out of your application. you
Resize browser in flex
Resize browser in flex  Hi........ Please tell me about How can I Resize the Internet Explorer browser window from flex ? please give me the appropriate answer Thanks  Ans: UsegetURL() to communicate
Resize Header in CSS
Resize Header in CSS  Hi all, Please let me know if we can resize the Header tags in HTML for example H1,H2 and so on... Actually, it looks very...;We can resize header tags in CSS .. and further call that class into you HTML
Spark Resize effect in Flex4
Spark Resize effect in Flex4: The Resize effect changes the height, width... and shrink the size of component using Resize effect.  The tag of Resize effect is <s:Resize>. In this example you can see how we can use a Resize
MX Resize Effect in Flex4
MX Resize Effect in Flex4: The Resize effect changes the height, width or both... the size of component using Resize effect. The tag of Resize effect is <mx:Resize>. In this example you can see how we can use a Resize effect
resize the tiff file in php - WebSevices
resize the tiff file in php  please guide me how i resize the tiff file and i want to upload it? using php  Hi I am sending the code of file upload in php. please check it, i hope it will help you... FileUpload.php
resize dynamic image in jsp - JSP-Servlet
resize dynamic image in jsp  Sir, I am saving the images in mysql database with Blob. An I am retrieving the images with this code:- I am getting my image with this code but all I need that I want to resize
auto update codings
auto update codings  auto update coding in xml
What is Auto Wiring?
What is Auto Wiring?  Hi, What is Auto Wiring? Thanks
how to generate auto code ?
how to generate auto code ?  i wanna genrate auto code for id in core java. pls tell me code of auto genrate
i want to resize the tiff file also - WebSevices
i want to resize the tiff file also  if($objFiles['photo']['name...']); $FileName= time().$objFiles['photo']['name']; $this->resize_image...'],180,135); } function resize_image($src,$dest,$type,$new_width,$new
resize image with the change in size of jpanel.. - Java Beginners
resize image with the change in size of jpanel..  hi.. i am try to insert image in jpanel in jform to give attractive look to application,but the of image do not changes if the size of jframe or jpanel changes. if there is any
auto sql script - SQL
auto sql script  Is there a way of generating inserts scripts using the table structure for oracle database
Date auto format
Date auto format  Hi, I have jsp page and Date field with input type. Requirement is, if we enter date as MMDDYY or MMDDYYYY and clicking the tab the date(MMDDYY or MMDDYYYY) have to auto format to MM/DD/YYYY. could you please
Auto Generated Employee ID
Auto Generated Employee ID  Hello Everyone I want to generate an ID like (SCS-0001) and then it should be auto incremented each time a new employee add page is opens. I am using My Sql database
Stumped with NOT NULL AUTO_INCREMENT
Stumped with NOT NULL AUTO_INCREMENT  I've almost made it through my... to create a new table with the ID column being NOT NULL AUTO_INCREMENT. The table will create if I do not have NOT NULL AUTO_INCREMENT, but it WILL NOT create
Auto field update
Auto field update  In my application I have a field called status which is having the 4 values like new,submitted,approved, rejected. How to set those filed in Database(MySQL), and how to auto update that field status in other
i want to resize tiff formated file in php - WebSevices
i want to resize tiff formated file in php  i know how to resize the jpeg,gif,png files but i need the code only for "tiff" files ? plz send guide lines for how to resize the tiff files?  Hi raja I could help better
Yahoo Auto Suggest
Yahoo Auto Suggest  Am using Yahoo Library for Auto Suggest and it is implementing well.. My Requirement is I've two radio buttons with a and b and its name is stype. When i selected a, I'll get a different suggestions
Resize outer div when inner div's height increases
Resize outer div when inner div's height increases   How can I increase the outer div height automatically when inner div's height increases in javascript
auto complete text box - Ajax
auto complete text box  How to create auto complete text box in jsp using ajax technology ? plz giv me steps wise code
Auto Fill Textbox - Java Beginners
Auto Fill Textbox   hi i am going to develope a php page with a select box and i want that this select box get auto fill when i write on it. please help me
MySQL Auto_Increment
MySQL Auto_Increment This example illustrates how to define AUTO_INCREMENT of a field. The AUTO_INCREMENT attribute can be used to generate a unique... AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id
Auto Search box using ajax
Auto Search box using ajax   Hi , i want to implement auto search box functionality like google and linkedin using ajax,jsp,servlet, javascript etc.when the value appears on the textbox then we should also be able to select
Jtree Nodes auto Hiding Problem
Jtree Nodes auto Hiding Problem  Have a nice day to everyone I am using Jtree and developed one hierarchic model as per requirement but i am having large no. of node so i have to hide of fold those node which i am not looking
java auto mail send - Struts
java auto mail send  Hello, im the beginner for Java Struts. i use java struts , eclipse & tomcat. i want to send mail automatically when the server start..I use the code for send mail..but i dont know how to sent
query regarding auto increment primary key
query regarding auto increment primary key  i want to use s1,s2.... as my auto increment primary key.cant i do this in mysql
Dojo Auto completer
Dojo Auto completer          In this section, you will learn how to create a auto completer in dojo.  Try Online: Auto Completer Auto Completer: The Auto Completer provides
How to auto increment primary key in mysql...
How to auto increment primary key in mysql...  How to auto increment primary key in mysql... and one more thing i need to get auto increment value in front end each time for inserting the value[JSP
Auto grow Text Area using jQuery plug-in
Auto grow Text Area using jQuery plug-in  Hi sir How can we make a textarea auto grow ? What is the name of the plug-in used for auto grow text area. Please mention code with your reply
How to make auto number? - JSP-Servlet
How to make auto number?  Dear, my friend... I really need your help.... I want to ask you, how to make auto number in mysql database? The format that I want is: ======> 00010809, 00020809, 00030809, etc 0001 = auto
jQuery to Auto Image Scroller
jQuery to Auto Image Scroller     ... that auto image scroller Steps to develop the program  Step 1...({ auto: 2, wrap: 'last', initCallback: mycarousel_initCallback
How create auto number? - JSP-Servlet
How create auto number?  Dear, my friend... I really need your help.... I want to ask you, how to make auto number in mysql database? The format that I want is: ======> 00010809, 00020809, 00030809, etc 0001 = auto
Client Auto Refresh in Servlets
Client Auto Refresh in Servlets       This section illustrates you how client gets auto refresh. We are providing you an example which explains you clearly. In the example, We have created
Auto fit the MS Excel cell width
Auto fit the MS Excel cell width  I am writing string in ms excel sheet via java code . Cell width is very large, and I want to auto fit the width of cell via java. Kindly help me as soon as possible. Its very urgent
Auto generated column in sql 5.0 - SQL
Auto generated column in sql 5.0  hi, in my data base i have declared one column has auto generating but currently am not able to insert the data unless i need to pass some integer value to that column.. regards pramod.k.r
how to declare a auto increment in sql - SQL
how to declare a auto increment in sql  Dear sir, How to declare a auto increment insql? i used a identity but it is nt working in sql,so... table form will get open. Click the checkbox option of Auto_Incrt for the field 'id
Non-edit Combobox with auto fill - Swing AWT
Non-edit Combobox with auto fill  Hi, I have a non-edit JCombobox with auto fill capability. Auto fill is working only for the first character...". The requirement is to extend this auto fill capability to support multiple characters in non
MySQL Auto_Increment
MySQL Auto_Increment       MySQL Auto_Increment is used to generate a unique number when a new... with Example The Tutorial illustrate an example from 'MySQL Auto_Increment
Auto Complete Text Box - JSP-Servlet
Auto Complete Text Box  Please help me in Aotocomplete text box code. I m a java programmer. I m working on jsp tech. please give me the code for Autocomplete text box in which the values will generate from database table
java web based auto dialers - MobileApplications
java web based auto dialers  Hi, I have assigned work that implementing web based auto dialers in java. I am new this technology. my question is I have a button (CALL) on the web page. when I click on that button. I
Ajax Auto Complete Tutorial
Auto Complete Example The auto complete feature helps the user to input the data correctly and quickly while submitting the form. An example of auto complete with JQuery is given below, to run this example you need to import two
Auto complete of word search using ajax with java
Auto complete of word search using ajax with java  I want to display the list of words when I type the first letter of the word in a text box. I am using jsp to design the form. I want ajax sample to achieve this feature. Its
PHP Auto schedule and run php scripts
PHP Auto schedule and run php scripts  Hi... This is vinay.. I am trying to schedule the execution of php scripts and run them... But I dont want to use cronJobs which are available in hosting servers.. I have to implement
Advertisements
 

 

 

DMCA.com