各位兄弟姐妹,帮我看看是什么回事.

Question

怎么没人来,难道上帝都不打救吗?

Answer 1

我把代码贴出来吧/**
*处理增加新闻的请求类。
*/
package util;import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import tools.*;
import Bean.*;public class NewsInput extends HttpServlet {
private static DBConnectionManager dbcm=DBConnectionManager.getInstance();
private static Log log=Log.getInstance();
private Connection con;
private Statement stmt;
private ResultSet rs; public NewsInput(){ }

protected void doGet(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}

protected void doPost(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
response.sendRedirect(handlerRequest(request, response));
}

public String handlerRequest(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
String op=request.getParameter("op");

Integer iFlag1,iFlag2,iFlag3,iFlag4; String sFlag1=request.getParameter("LastNews");
String sFlag2=request.getParameter("CoLaNews");
String sFlag3=request.getParameter("HotNews");
String sFlag4=request.getParameter("ClassNews");

iFlag1= new Integer(0);
iFlag2= new Integer(0);
iFlag3= new Integer(0);
iFlag4= new Integer(0);

if(sFlag1==null || sFlag1.equals(""))
{
iFlag1= new Integer(0);
}
else
{
iFlag1=Integer.valueOf(sFlag1);
}

if(sFlag2==null || sFlag2.equals(""))
{
iFlag2= new Integer(0);
}
else
{
iFlag2=Integer.valueOf(sFlag2);
}

if(sFlag3==null || sFlag3.equals(""))
{
iFlag3= new Integer(0);
}
else
{
iFlag3=Integer.valueOf(sFlag3);
}

if(sFlag4==null || sFlag4.equals(""))
{
iFlag4= new Integer(0);
}
else
{
iFlag4=Integer.valueOf(sFlag4);
} String sPhoto=request.getParameter("NewsPhoto");
String sValidDate=request.getParameter("ValidTime");
String sTitle=ConvertString.toChinese(request.getParameter("Title"));
String sContent=ConvertString.toChinese(request.getParameter("content"));

NewsMsgBean BeanNewsMsg=new NewsMsgBean(sTitle,sContent,sPhoto,sValidDate,iFlag1,iFlag2,iFlag3,iFlag4);
if(op.equals("NewsChek"))
return CheckTitle(request,response,BeanNewsMsg);
else
return NewsInsert(request,response,BeanNewsMsg);
}

public String CheckTitle(HttpServletRequest request,HttpServletResponse response,NewsMsgBean BeanNewsMsg) throws ServletException,IOException
{
String result=null;

try{
con=dbcm.getConnection("access");
stmt=con.createStatement();
String sql=null;

sql="select * from tbNews_Msg where MemberNo='"+BeanNewsMsg.getTitle()+"'";
rs=stmt.executeQuery(sql);
if(rs.next())
result="checkno";
else
result="checkok";

request.setAttribute("result",result);
request.setAttribute("BeanNewsMsg",BeanNewsMsg);
return "AddNews.jsp";
}catch(SQLException sqle){
Log.write("连接数据库异常");
result="连接数据库发生错误";
request.setAttribute("result",result);
request.setAttribute("BeanNewsMsg",BeanNewsMsg);
return "AddNews.jsp";
}finally{
dbcm.freeConnection("access",con);
if(rs!=null)
rs=null;
if(stmt!=null)
stmt=null;
if(con!=null)
con=null;
}
} public String NewsInsert(HttpServletRequest request,HttpServletResponse response,NewsMsgBean BeanNewsMsg) throws ServletException,IOException{
String result=null; String sTitle=BeanNewsMsg.getTitle();;
String sPhoto=BeanNewsMsg.getPhoto();
String dAddDate=BeanNewsMsg.getAddTime();
String sContent=BeanNewsMsg.getContent();
Integer iFlag1=BeanNewsMsg.getLastNews();
Integer iFlag2=BeanNewsMsg.getCoLaNews();
Integer iFlag3=BeanNewsMsg.getHotNews();
Integer iFlag4=BeanNewsMsg.getClassNews();

try{
con=dbcm.getConnection("access");
stmt=con.createStatement();
String sql=null;

/*增加记录*/
sql="insert into tbNews_Msg (fdcTitle,fdcPhoto,fdcContent,fdiFlag1,fdiFlag2,fdiFlag3,fdiFlag4)";
sql=sql+" VALUES('"+sTitle+"','"+sPhoto+"','"+sContent+"'," +iFlag1 +",";
sql = sql + iFlag2 + "," + iFlag3 + "," + iFlag4 + ")"; stmt.executeUpdate(sql); Log.write("增加新闻["+ sTitle+"]"); if( BeanNewsMsg.getAddTime() == null )
BeanNewsMsg.setAddTime("");

request.setAttribute("result",result);
request.setAttribute("BeanNewsMsg",BeanNewsMsg);
return "NewsInput/AddNews.jsp";
}catch(SQLException sqle){
Log.write("连接数据库异常:"+sqle.toString() );
result="连接数据库发生错误";
request.setAttribute("result",result);
request.setAttribute("BeanNewsMsg",BeanNewsMsg);
return "AddNews.jsp";
}finally{
dbcm.freeConnection("access",con);
if(rs!=null)
rs=null;
if(stmt!=null)
stmt=null;
if(con!=null)
con=null;
}
}

}

Answer 2

也太多了。看一下就吓着了。闪！