|
|
<%
for ( int i = 0; i < th_alphabet.length; i++ )
{
if ( alphabet.equals ( "" + i ) )
{
%>
| <%= th_alphabet [ i ] %> |
<%
}
else
{
%>
|
<%
}
out.print ( " | " );
}
%>
<%
int meanid = 0;
int rowCount = 0;
String m_group = null;
String m_word = null;
String m_description = null;
String m_date = null;
String strSQL = null;
//out.print ( "search" );
if ( search != null )
{
//out.print ( "search" );
strSQL = "Select * from means where m_word Like '%" + search + "%' order by m_word asc";
}
else
{
//out.print ( "no search" + ( th_alphabet.length - 1 ) );
if ( alphabet.equals ( "" + ( th_alphabet.length - 1 ) ) )
{
strSQL = "Select * from means order by m_word asc";
}
else
{
strSQL = "Select * from means where m_group = '" + search_alphabet + "' order by m_word asc";
}
}
//out.print ( strSQL );
rs = dbcon.executeQuery ( strSQL, chDelete, preview, pid );
totalRow = dbcon.getTotalRow ( );
totalPage = dbcon.getTotalPage ( );
while ( rs.next ( ) )
{
meanid = rs.getInt ( "meanid" );
m_group = rs.getString ( "m_group" );
m_word = rs.getString ( "m_word" );
m_description = rs.getString ( "m_description" );
m_date = rs.getString ( "m_date" );
// @@@ START LINUX
// m_word = new String ( m_word.getBytes ( "ISO8859_1" ), "MS874" );
// m_description = new String ( m_description.getBytes ( "ISO8859_1" ), "MS874" );
// @@@ END LINUX
if ( m_date != null )
{
d_date.setDate ( m_date );
m_date = d_date.getShortThaiDay ( ) + " " +d_date.getShortThaiMonth ( ) + " " + d_date.getShortThaiYear ( );
}
rowCount = rowCount + 1;
%>
|
<% if ( m_word != null ) { out.print ( m_word ); } %>
|
¤ÇÒÁËÁÒÂ
|
<% if ( m_description != null ) { out.print ( m_description ); } %>
|
|
 |
|
<%
if ( rowCount >= preview )
{
rs.afterLast ( );
}
}
rs.close ( );
//
row = " + dbcon.getTotalRow ( ) + " :: page = " + dbcon.getTotalPage ( )
if ( rowCount == 0 )
{
pid = 0;
}
%>
|
|
|
˹éÒ <%= pid %> ¨Ò¡ <%= totalPage %> ( <%= totalRow %> ¤Ó )
<%
int goPage = 0;
int totalpageLink = totalPage/pageLinkLen;
int start_pageLink = pageLinkLen * intlinkGroup;
if ( totalPage % pageLinkLen > 0 )
{
totalpageLink = totalpageLink + 1;
}
if ( start_pageLink > 0 )
{
out.print ( " " );
out.print ( " | " );
}
for ( int i = 1; i <= pageLinkLen; i++ )
{
goPage = i + start_pageLink;
if ( goPage <= totalPage )
{
if ( pid == goPage )
{
out.print ( "" + goPage + " | " );
}
else
{
out.print ( " | " );
}
}
else
{
goPage = totalPage;
}
}
if ( goPage < totalPage )
{
out.print ( " " );
}
else
{
if ( ( goPage + 1 ) < totalPage )
{
out.print ( "-" + totalPage + " >>" );
}
else
{
out.print ( "" );
}
}
}
%>
|
|
|
|
|
|