zuixin_add_deal.jsp

来自「用JSP制作的个人网站」· JSP 代码 · 共 25 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page import="liangjuyan.dao.zuixindaoimpl"%>
<jsp:useBean id="zuixin" scope="page" class="liangjuyan.zuixin">
<jsp:setProperty name="zuixin" property="*"/>
</jsp:useBean>
<jsp:useBean id="chStr" scope="page" class="liangjuyan.chStr"/>
<jsp:useBean id="conn" scope="page" class="liangjuyan.conndb"/>
<%
String title=chStr.chStr(zuixin.getTitle());
ResultSet rs=conn.executeQuery("select * from haha where title='"+title+"'");
if (rs.next()){
	out.println("<script language='javascript'>alert('该商品信息已经添加！');window.location.href='zuixin_add.jsp';</script>");
}else{
	int ret=0;
       zuixindaoimpl ins_zuixin=new zuixindaoimpl();
        ret=ins_zuixin.insert(zuixin);
	if (ret!=0){
          out.println("<script language='javascript'>alert('最新信息添加成功！');window.location.href='zuixinzhixunguanli.jsp';</script>");
        }else{
          out.println("<script language='javascript'>alert('最新信息添加失败！');//window.location.href='zuixinzhixunguanli.jsp';</script>");
        }
}
%>