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("
");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;
}
}
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