WEB programming page shows stray kid
As the saying goes, "Ten is the beginning is difficult", it is true that the beginner Web programming has always had a lot of questions. Here, the following is a relatively common problem - page display. There are many articles that are paged online, but most of them are implemented with ASP, this program implements paging display in JSP. The idea of the program is to calculate the total number of pages by obtaining the total number of OTALs, and the records that are displayed in each page. The read of the specified data is then implemented by controlling the movement of the pointer. The following is interpreted by the program example. First, create a data sheet and wait for a call. (Because only experiments are only used as a database), a database table named TEST is created. For the simple field, as long as three, it is ID (Auto Number), Name (Text), Passowrd (Text). Then insert some data to the database. Note The database is to establish a system DSN in the ODBC Data Source Manager.
<% //Written by qiyadeng; //pages.jsp%> <% @ page contenttype = "text / html; charset = GB2312"%> <% @ page import = "java.sql. *"%>
Web programming display </ title> <body> <center> <font color = red> User information table </ font> </ center> <% int everypage = 8; // Each page display Number of records; int onpage = 1; // Currently displayed pages; int total = 0; // Total number of records; int totalpage = 0; // records the total number of pages; // below is a connection database; Simple examples do not need Javabean; class.Forname ("Sun.jdbc.odbc.jdbcodbcdriver); connection conn = drivermanager.getConnection (" JDBC: ODBC: Test "); // DSN named Test; Statement Stmt = conn .CreateStatement (ResultSet.Type_Scroll_Insensitive, ResultSet.concur_read_only); String SQL = "Select * from test"; // Query statement; ResultSet RS = stmt.executequence (SQL);</p>
<p>Rs.last (); // Move to the last record; Total = rs.getrow (); // Total number of records; // calculate the total number of pages TotalPage; if (Total% Everypage == 0) Totalpage = Total / Everypage; elseTotalPage = Total / Everypage 1; // Get the value of the text box input; string pages = request.getParameter ("pages"); if (pages! = Null) {onpage = integer.parseint (PAGES); / / Convert the PAGES to an integer; / / Depending on the value of the input, it is determined that the page that should be displayed; if (onpage> TotalPage;} else if (onpage <= 0) {onpage = 1;}}} Absolute 1); / / Specify the position of the pointer;%> <center> User <% = Total%>, a total of <% = TotalPage%> Page is currently in the <font color = Red > <% = Onpage%> </ font> page </ center> <br> <center> <table border = 1 bordercolor = red> <TR> <TD> User No. </ TD> <TD> User Name </ TD> <TD> Password </ TD> </ TR> <% // Recording displayed; for (int i = 1; i <= everypage; i ) {%> <TR> <TD> <% = = r .getstring ("id")%> </ td> <td> <% = rs.getstring ("name")%> </ td> <td> <% = rs.getstring ("password")%> < /t></t> %%% (退 退;;;;;;;;;;;;;;;;; () .Close ();%> </ table> </ center> <% // is currently displaying something to display; if (onpage! = 1) {%> <br> <center> <a HREF = Pages.jsp? Pages = <% = 1% >> First page </a> <a href=pages.jsp?pages=<%=onpage-1%> Previous </a </ Center> <%} // currently displayed Is the last page should display something; if (onpage! = Totalpage) {%> <center> <a href=pages.jsp?pages=<%=onpage 1%> Next page </A> <a HREF = Pages.jsp? Pages = <% = TotalPage% >> Last page </a> </ center></p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-11696.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="11696" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.039</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'm_2FxI8S0yIrwwHK0oWT8rTxz8IVO4n73_2FNzqWr63nLSPvja3wciS0dfL8WAb14LVHBgIV7VqClDC5EH8x';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
