Wed Apr 13, 2011 7:14 am
Wed Apr 13, 2011 9:54 pm
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
</web-app>
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.http.HttpServletResponse;
public class allsubtitles {
private final int limit=25;
/** Creates a new instance of allsubtitles */
public String DoFilmSearch(String page,String letter) throws IOException
{
String returnTable = "";
if(letter==null)letter="A";
if(page==null)page="1";
int mypage=Integer.parseInt(page);
int myBase=(limit*mypage)-limit;
int myLimit=(limit*mypage);
boolean flag=false;
try{
try {
Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost/mysite?user=root&password=root");
String sql=null;
Statement statement = connection.createStatement();
if(letter.equals("0-9"))
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('0%') OR " +
"FILM_NAME like('1%') OR FILM_NAME like('2%') OR FILM_NAME like('3%') OR FILM_NAME like('4%') OR FILM_NAME like('5%') OR " +
"FILM_NAME like('6%') OR FILM_NAME like('7%') OR FILM_NAME like('8%') OR FILM_NAME like('9%') " +
" group by FILM_NAME,FILM_YEAR order by 'Film name' ,Subtitles limit "+myBase+","+myLimit+ ";";
else
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('"+letter+"%')" +
" 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)+"("+myresult.getString(4)+")"+"</a></td>";
returnTable+="<td>"+myresult.getString(3)+"</td>";
returnTable+="</tr>";
}
if(!flag)
returnTable+="<tr><td colspan=2> No results found </td></tr>";
if(letter.equals("0-9"))
sql="Select COUNT(FILM_ID) " +
" from Films where FILM_NAME like('0%') OR " +
"FILM_NAME like('1%') OR FILM_NAME like('2%') OR FILM_NAME like('3%') OR FILM_NAME like('4%') OR FILM_NAME like('5%') OR " +
"FILM_NAME like('6%') OR FILM_NAME like('7%') OR FILM_NAME like('8%') OR FILM_NAME like('9%') " +
" ;";
else
sql="Select COUNT(FILM_ID) from Films where FILM_NAME like('"+letter+"%')";
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+"&&letter="+letter+">"+i+"</a>|";
else
returnTable+="<u>"+i+"</u>|";
count-=limit;
}
returnTable+="</td></tr></table> ";
connection.close();
statement.close();
}
catch (SQLException ex) {
ex.printStackTrace();
}
return returnTable;
}
}
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
Powered by phpBB © phpBB Group.