%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312");%>
新闻信息添加
<%!
String sql;
int years,months,days;
int i,j;
ResultSet rs;
String type;
String title;
String content;
java.util.Date today;
%>
<% if(request.getParameter("action")!=null){
type=request.getParameter("type");
title=request.getParameter("title");
content=request.getParameter("content");
sql="select * from tb_News where Title='"+title+"' and Content='"+content+"' and Type='"+type+"'";
rs=data.getrs(sql);
rs.beforeFirst();
if(rs.next()){
data.close();
%>
<%
}
else{
data.close();
today=new java.util.Date();
years=today.getYear();
months=today.getMonth();
days=today.getDate();
java.sql.Date dates=new java.sql.Date(years,months,days);
sql="insert into tb_News values('"+title+"','"+content+"','"+dates+"','"+type+"')";
i=data.getint(sql);
if(i>0){
%>
<%
}
}
data.close();
}
%>