-
大小: 11.17MB文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2023-07-01
- 語言: Java
- 標(biāo)簽: jsp大作業(yè)??word文檔??
資源簡介
家鄉(xiāng)菜學(xué)習(xí)系統(tǒng)-jsp大作業(yè)-java大作業(yè)-sq文件-源碼-word文檔,文件齊全,部署方便簡單
代碼片段和文件信息
package?ch08;
import?java.sql.*;
public?class?JavaBeanProject?{
private?String?drivername=“com.mysql.jdbc.Driver“;
private?String?url=“jdbc:mysql://localhost:3306/adminlogin?useUnicode=true&characterEncoding=gbk“;
private?String?user=“root“;
private?String?password=“123456“;
private?String?s[];
public?String?getDrivername()?{
return?drivername;
}
public?void?setDrivername(String?drivername)?{
this.drivername?=?drivername;
}
public?String?getUrl()?{
return?url;
}
public?void?setUrl(String?url)?{
this.url?=?url;
}
public?String?getUser()?{
return?user;
}
public?void?setUser(String?user)?{
this.user?=?user;
}
public?String?getPassword()?{
return?password;
}
public?void?setPassword(String?password)?{
this.password?=?password;
}
public?String[]?getS()?{
return?s;
}
public?void?setS(String[]?s)?{
this.s?=?s;
}
public?Connection?getConnection()
{
try
{
Class.forName(drivername);
return?DriverManager.getConnection(url?user?password);
}catch(Exception?e)
{
e.printStackTrace();
return?null;
}
}
public?ResultSet?select(String?sqls)//查詢
{
PreparedStatement?stmt;
try
{
stmt=getConnection().prepareStatement(sqls);
for(int?i=0;i stmt.setString(i+1s[i]);
return?stmt.executeQuery();
}catch(Exception?e){
e.printStackTrace();
return?null;
}
}
public?void?insertJournal(String?sqls){//添加新聞
PreparedStatement?stmt;
//int?rs=0;
try?{
stmt?=?getConnection().prepareStatement(sqls);
for(int?i=0;i stmt.setString(i+1s[i]);
stmt.executeUpdate();
}?catch?(Exception?e)?{
e.printStackTrace();
} /*finally{
return?rs;
}*/
}
public?void?updateJournal(String?sqls){//修改新聞
PreparedStatement?stmt;
try?{
stmt?=?getConnection().prepareStatement(sqls);
for(int?i=0;i stmt.setString(i+1s[i]);
stmt.executeUpdate();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
public?void?deleteJournal(String?sqls){//刪除新聞
PreparedStatement?stmt;
try?{
stmt?=?getConnection().prepareStatement(sqls);
for(int?i=0;i stmt.setString(i+1s[i]);
stmt.executeUpdate();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-10-19?09:12??新聞管理系統(tǒng)\
?????文件?????5834752??2018-10-19?09:12??新聞管理系統(tǒng)\0152203166.doc
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\
?????文件????????1252??2017-12-24?18:14??新聞管理系統(tǒng)\新聞\JournalWork\.classpath
?????文件????????1336??2016-10-29?20:44??新聞管理系統(tǒng)\新聞\JournalWork\.project
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\.settings\
?????文件?????????522??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\.settings\.jsdtscope
?????文件?????????135??2016-11-01?22:08??新聞管理系統(tǒng)\新聞\JournalWork\.settings\com.genuitec.eclipse.core.prefs
?????文件??????????81??2016-11-14?20:47??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.jdt.core.prefs
?????文件?????????492??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.wst.common.component
?????文件?????????358??2017-12-24?17:00??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\me
?????文件??????????39??2016-10-29?19:37??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\me
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\classes\ch08\
?????文件????????3395??2017-12-28?10:57??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\classes\ch08\JavaBeanProject.class
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\lib\
?????文件??????802721??2016-10-29?19:51??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.20-bin.jar
?????文件???????15718??2017-12-28?10:56??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\WEB-INF\lib\upload_jelin.jar
?????目錄???????????0??2018-10-19?09:10??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\
?????文件????????3802??2017-12-28?10:46??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\Insertjournal.jsp
?????文件????????2195??2017-12-28?17:28??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\add.jsp
?????文件????????2420??2017-12-28?17:31??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\addDeal.jsp
?????文件????????3144??2017-12-24?17:01??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\article.jsp
?????文件????????1452??2017-12-28?23:06??新聞管理系統(tǒng)\新聞\JournalWork\WebRoot\adminIndex\delete.jsp
............此處省略62個文件信息
評論
共有 條評論