jsp新闻系统核心代码.docx
- 文档编号:18438685
- 上传时间:2023-08-18
- 格式:DOCX
- 页数:20
- 大小:18.90KB
jsp新闻系统核心代码.docx
《jsp新闻系统核心代码.docx》由会员分享,可在线阅读,更多相关《jsp新闻系统核心代码.docx(20页珍藏版)》请在冰点文库上搜索。
jsp新闻系统核心代码
附
录
index.java主要用于处理首页上的功能:
packagecom.ly;
importjava.sql.*;
publicclassindex{
Connectioncon;
ResultSetrs;
Statementsql;
StringBufferqueryResult;//定义结果集变量
publicindex(){
queryResult=newStringBuffer();
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(Exceptione){
queryResult.append(e);
}
}
/*结果集的get方法,主要功能是显示新闻首页的新闻*/
publicStringBuffergetQueryResult(){
try{
Stringuri="jdbc:
sqlserver:
//localhost:
1433;DatabaseName=NEWS";
Stringuser="sa";
Stringpassword="123";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("selecttop(7)*fromtb_newsorderbysDatedesc");
while(rs.next())
{
queryResult.append("
}
con.close();
}
catch(Exceptione){
queryResult.append(e);
}
returnqueryResult;
}
}
selectpage.Java用于处理搜索功能:
packagecom.ly;
importjava.sql.*;
publicclassselectpage{
Connectioncon;
ResultSetrs;
Statementsql;
StringBufferqueryResult;//定义结果集变量
Stringresult;
publicselectpage(){
queryResult=newStringBuffer();
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(Exceptione){
queryResult.append(e);
}
}
publicStringgetResult()
{
returnresult;
}
publicvoidsetResult(Strings)
{
result=s.trim();
}
publicStringBuffergetQueryResult(){
try{
Stringuri="jdbc:
sqlserver:
//localhost:
1433;DatabaseName=NEWS";
Stringuser="sa";
Stringpassword="123";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("select*fromtb_newswheresTitlelike'%"+result+"%'");
while(rs.next())
{
queryResult.append("
queryResult.append(" 10px0px0px0px'> nid="+rs.getString (1)+"'>"+rs.getString (2)+""); queryResult.append("
}
con.close();
}
catch(Exceptione){
queryResult.append(e);
}
returnqueryResult;
}
}
shownews.Java用于显示所有新闻:
packagecom.ly;
importjava.sql.*;
publicclassshownews{
Connectioncon;
ResultSetrs;
Statementsql;
StringBufferqueryResult;//定义结果集变量
publicshownews(){
queryResult=newStringBuffer();
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(Exceptione){
queryResult.append(e);
}
}
/*结果集的get方法,主要功能是显示新闻首页的新闻*/
publicStringBuffergetQueryResult(){
try{
Stringuri="jdbc:
sqlserver:
//localhost:
1433;DatabaseName=NEWS";
Stringuser="sa";
Stringpassword="123";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("select*fromtb_news");
while(rs.next())
{
queryResult.append(" left'>"); queryResult.append(" queryResult.append(" 10px0px0px0px'>"); queryResult.append(" nid="+rs.getString (1)+"'>"); queryResult.append(rs.getString (2)); queryResult.append(""); queryResult.append(""); queryResult.append(""); ");
queryResult.append("");
}
con.close();
}
catch(Exceptione){
queryResult.append("e");
}
returnqueryResult;
}
}
houtai.java用于增删改和回收站功能:
packagecom.ly;
importjava.sql.*;
publicclasshoutai{
Stringst="";//标题
Stringsd="";//发布日期
Stringsu="";//发布人
Stringsc="";//新闻内容
Stringaddmessage="";//显示增加结果信息
Stringdelmessage="";//显示删除结果信息
Stringaltermessage="";//显示修改结果
Stringrecvmessage="";//显示彻底删除结果
Stringcomdelmessage="";
Stringnid="";//用于接收传过来的值
Stringstr;
Connectioncon;
Statementsql;
ResultSetrs;
Stringuri="jdbc:
sqlserver:
//localhost:
1433;DatabaseName=NEWS";
Stringuser="sa";
Stringpassword="123";
publichoutai(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(Exceptione){}
}
publicvoidsetNid(Strings)
{
nid=s.trim();
StringCondition="select*fromtb_newswherenid='"+nid+"'";
try{
ResultSetrs;
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery(Condition);
while(rs.next()){
this.st=rs.getString
(2);
this.sd=rs.getString(3);
this.su=rs.getString(4);
this.sc=rs.getString(8);
}
}
catch(Exceptione){
System.out.print(e);
}
}
/*表字段的set方法*/
publicvoidsetSt(Strings){
this.st=s.trim();
try{
bytebb[]=st.getBytes("ISO-8859-1");
st=newString(bb,"gbk");
}catch(Exceptione){}
}
publicvoidsetSd(Strings){
this.sd=s.trim();
try{
bytebb[]=sd.getBytes("ISO-8859-1");
sd=newString(bb,"gbk");
}catch(Exceptione){}
}
publicvoidsetSu(Strings){
this.su=s.trim();
try{
bytebb[]=su.getBytes("ISO-8859-1");
su=newString(bb,"gbk");
}catch(Exceptione){}
}
publicvoidsetSc(Strings){
this.sc=s.trim();
try{
bytebb[]=sc.getBytes("ISO-8859-1");
sc=newString(bb,"gbk");
}catch(Exceptione){}
}
/*表字段的set方法结束*/
/*在修改的输入框内显示内容的get方法*/
publicStringgetSt(){
returnthis.st;
}
publicStringgetSd(){
returnthis.sd;
}
publicStringgetSu(){
returnthis.su;
}
publicStringgetSc(){
returnthis.sc;
}
/*get方法结束*/
/*对表进行insert操作*/
publicStringgetAddmessage(){
StringinsertCondition="insertintotb_news(sTitle,sDate,sUser,sContent)values('"+st+"','"+sd+"','"+su+"','"+sc+"')";
try{
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
if(st.length()>0&&sc.length()>0){
intm=sql.executeUpdate(insertCondition);
if(m!
=0)
{
str="对表中增加"+m+"条记录成功";
}
else
{
str="添加失败";
}
}
else{
str="*号内容不能为空";
}
con.close();
}catch(SQLExceptione){
str="数据库内已有记录"+e;
}
returnstr;
}
/*insert结束*/
/*对表进行delete操作*/
publicStringgetDelmessage(){
StringdeleteCondition="deletefromtb_newswherenid="+nid;
try{
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
intm=sql.executeUpdate(deleteCondition);
if(m!
=0){
str="删除成功,你还可进入 tip=恢复'>【回收站】来恢复数据"; } else{ str="删除失败"; } con.close(); }catch(SQLExceptione){ str=""+e; } returnstr; } /*delete结束*/ /*对表进行update操作*/ publicStringgetAltermessage(){ StringinsertCondition="updatetb_newssetsTitle='"+st+"',sDate='"+sd+"',sUser='"+su+"',sContent='"+sc+"'wherenid='"+nid+"'"; try{ con=DriverManager.getConnection(uri,user,password); sql=con.createStatement(); if(st.length()>0&&sc.length()>0){ intm=sql.executeUpdate(insertCondition); if(m! =0) { str="对表中修改"+m+"条记录成功"; } else { str="修改失败"; } } else{ str="*号内容不能为空"; } con.close(); }catch(SQLExceptione){ str="数据库内已有记录"+e; } returnstr; } /*update结束*/ /*对表的彻底删除功能*/ publicStringgetComdelmessage(){ StringdeleteCondition="deletefrombackupswherenid="+nid; try{ con=DriverManager.getConnection(uri,user,password); sql=con.createStatement(); intm=sql.executeUpdate(deleteCondition); if(m! =0){ str="彻底删除成功"; } else{ str="彻底删除失败"; } con.close(); }catch(SQLExceptione){ str=""+e; } returnstr; } /*对表的恢复功能*/ publicStringgetRecvmessage() { Stringst2=""; Stringsd3=""; Stringsu4=""; Stringsc8=""; try{ con=DriverManager.getConnection(uri,user,password); sql=con.createStatement(); rs=sql.executeQuery("select*frombackupswherenid="+nid); while(rs.next()){ st2=rs.getString (2); sd3=rs.getString(3); su4=rs.getString(4); sc8=rs.getString(8); } StringrecvCondition="insertintotb_news(sTitle,sDate,sUser,sContent)values('"+st2+"','"+sd3+"','"+su4+"','"+sc8+"')"; intm=sql.executeUpdate(recvCondition); if(m! =0){ intn=sql.executeUpdate("deletefrombackupswherenid="+nid); if(n! =0){ str="恢复成功"; } } else{ str="恢复失败"; } }catch(SQLExceptione){ str=""+e; } returnstr; } /*恢复结束*/ } xianshi.java用于页面显示对新闻进行什么操作: packagecom.ly; importjava.sql.*; publicclassxianshi{ Connectioncon; ResultSetrs; Statementsql; StringBufferqueryResult;//定义结果集变量 Stringtip="";//保存传过来的删除或修改 Stringurl="";//记录跳转页面 StringtableName=""; publicxianshi(){ queryResult=newStringBuffer(); try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch(Exceptione){ queryResult.append(e); } } publicvoidsetTip(Strings) { tip=s.trim(); try{ bytebb[]=tip.getBytes("ISO-8859-1"); tip=newString(bb,"gbk"); }catch(Exceptione){} } /*结果集的get方法,主要功能是显示新闻首页的新闻*/ publicStringBuffergetQueryResult(){ try{ Stringuri="jdbc: sqlserver: //localhost: 1433;DatabaseName=NEWS"; Stringuser="sa"; Stringpassword="123"; con=DriverManager.getConnection(uri,user,password); sql=con.createStatement(); if(tip.equals("删除")){ url="delete.jsp"; tableName="tb_news"; } elseif(tip.equals("修改")){ url="alter.jsp"; tableName="tb_news"; } else{ url="comdel.jsp"; tableName="backups"; } rs=sql.executeQuery("select*from"+tableName); while(rs.next()) { S
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- jsp 新闻 系统 核心 代码