91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.18MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-11-11
  • 語言: Java
  • 標簽: 在線影評??系統??JSP??

資源簡介

本在線影評系統利用jsp動態網頁技術和MySql數據庫,以B/S模式開發,實現電影的動態發布和管理。前臺為用戶提供了電影搜索、分類和評論等功能;管理用戶可以通過Web瀏覽器登陸后臺實現電影的刪除,添加。

資源截圖

代碼片段和文件信息

package?beans;

import?java.sql.*;

import?com.sun.rowset.CachedRowSetImpl;

public?class?database?{

//?格式輸出
StringBuffer?queryResult;
//?Vector?vector=new?Vector();
//?定義變量,id,pic,moviename,daoyan,zhuyan,difang,pianchang,leibie,pingfen,shangyingshijian
String?keyword?=?““;//
int?id?pianchang;
float?pingfen;
int?shangyingshijian;
String?pic?=?““?moviename?=?““?daoyan?=?““?zhuyan?=?““?difang?=?““
leibie?=?““;
String?logname?=?““?text?=?““;

int?pageSize?=?2;
int?showPage?=?1;
int?pageAllCount?=?0;
int?a?=?0;//?計算字段個數
CachedRowSetImpl?rowSet;

//?構造函數
public?database()?{
queryResult?=?new?StringBuffer();
}

public?void?chaxun(String?str?String?biao)?{
Connection?con;
Statement?sql;
ResultSet?rs;
String?uri?=?“jdbc:mysql://localhost:3306/movie“;//?或者“jdbc:mysql://localhost/shuju”,不用寫端口

try?{
queryResult.append(““);
Class.forName(“com.mysql.jdbc.Driver“);
con?=?DriverManager.getConnection(uri?“root“?“root“);
DatabasemetaData?metadata?=?con.getmetaData();
ResultSet?rs1?=?metadata.getColumns(null?null?biao?null);

queryResult.append(““);
while?(rs1.next())?{
a++;
String?clumnName?=?rs1.getString(4);
queryResult.append(““?+?clumnName?+?““);
}
queryResult.append(““);
sql?=?con.createStatement();
rs?=?sql.executeQuery(str);

rowSet?=?new?CachedRowSetImpl();
rowSet.populate(rs);
rowSet.last();
int?m?=?rowSet.getRow();
int?n?=?pageSize;
pageAllCount?=?((m?%?n)?==?0)???(m?/?n)?:?(m?/?n?+?1);
if?(showPage?>?pageAllCount)
showPage?=?1;
if?(showPage?<=?0)
showPage?=?pageAllCount;
try?{
rowSet.absolute((showPage?-?1)?*?pageSize?+?1);
for?(int?i?=?1;?i?<=?pageSize;?i++)?{
queryResult.append(““);
for?(int?k?=?1;?k?<=?a;?k++)
queryResult.append(““?+?rowSet.getString(k)
+?““);
queryResult.append(““);
rowSet.next();
}
}?catch?(SQLException?e)?{
e.printStackTrace();
}
queryResult.append(““);
con.close();
}?catch?(Exception?e)?{
queryResult.append(e);
}
}

//?順序查詢,在本例中是“新片”的方法,查詢出上映時間在一年內的電影
public?StringBuffer?getShunxuchaxun()?{
chaxun(“select?*?from?movie?where?(2011-shangyingshijian)<=1“?“movie“);
return?queryResult;
}

//?“分類”的方法
public?StringBuffer?getTiaojianchaxun()?{
Connection?con;
Statement?sql;
ResultSet?rs;
String?uri?=?“jdbc:mysql://localhost:3306/movie?useUnicode=true&characterEncoding=UTF-8“;

try?{
queryResult.append(““);
Class.forName(“com.mysql.jdbc.Driver“);
con?=?DriverManager.getConnection(uri?“root“?“root“);
DatabasemetaData?metadata?=?con.getmetaData();
ResultSet?rs1?=?metadata.getColumns(null?null?“movie“?null);
int?a?=?0;
queryResult.append(““);
while?(rs1.next())?{
a++;
String?clumnName?=?rs1.getString(4);

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????705??2013-06-30?09:07??movie2\.classpath

?????文件????????291??2013-06-30?09:01??movie2\.mymetadata

?????文件???????1749??2013-06-30?09:01??movie2\.project

?????文件????????500??2013-06-30?09:01??movie2\.settings\.jsdtscope

?????文件????????109??2012-04-13?17:25??movie2\.settings\com.genuitec.eclipse.ws.prefs

?????文件????????395??2013-06-30?09:01??movie2\.settings\org.eclipse.jdt.core.prefs

?????文件????????456??2013-06-30?09:01??movie2\.settings\org.eclipse.wst.common.component

?????文件????????252??2013-06-30?09:01??movie2\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-06-30?09:01??movie2\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-06-30?09:01??movie2\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????9483??2013-06-30?10:03??movie2\src\beans\database.java

?????文件????????664??2012-04-13?17:25??movie2\src\beans\Login.java

?????文件????????669??2012-04-13?17:25??movie2\src\beans\ManagerLogin.java

?????文件???????1484??2012-04-13?17:25??movie2\src\beans\MovieInform.java

?????文件????????633??2012-04-13?17:25??movie2\src\beans\Register.java

?????文件???????1821??2013-06-30?10:08??movie2\src\handle\HandleDatabase.java

?????文件???????3308??2013-06-30?15:42??movie2\src\handle\HandleLogin.java

?????文件???????3097??2013-06-30?10:08??movie2\src\handle\HandleManagerLogin.java

?????文件???????3073??2013-06-30?10:08??movie2\src\handle\HandleRegister.java

?????文件???????3178??2013-06-30?14:32??movie2\WebRoot\fenlei.jsp

?????文件????????605??2013-06-30?14:31??movie2\WebRoot\header.jsp

?????文件????????766??2012-04-13?17:25??movie2\WebRoot\img\abclg.png

?????文件???????5874??2012-04-13?17:25??movie2\WebRoot\img\pic1.jpg

?????文件???????5240??2012-04-13?17:25??movie2\WebRoot\img\pic2.jpg

?????文件???????6094??2012-04-13?17:25??movie2\WebRoot\img\pic3.jpg

?????文件???????4569??2012-04-13?17:25??movie2\WebRoot\img\pic4.jpg

?????文件???????3914??2012-04-13?17:25??movie2\WebRoot\img\pic5.jpg

?????文件???????5966??2012-04-13?17:25??movie2\WebRoot\img\pic6.jpg

?????文件???????4427??2012-04-13?17:25??movie2\WebRoot\img\pic7.jpg

?????文件???????5155??2012-04-13?17:25??movie2\WebRoot\img\pic8.jpg

............此處省略48個文件信息

評論

共有 條評論