data.asp

基于C#语言的一个物流信息网数据库系统开发案例的源代码 ,很实用

<!-- #include file="../../Conn/conn.asp" -->
<% 
	title=request.form("title")
	content=request.form("content")
	sql="select * from tb_NewMeg where Title='"&title&"'"
	rs.open sql,conn
	if not rs.eof or not rs.bof then 
%>
		<script language="javascript">
			alert("同标题信息已经存在，请更改标题或将同标题信息删除后再重新保存!");
			history.back();
		</script>
<% 
		set rs=nothing
		conn.close
		set conn=nothing
		else 
%>
			<!-- #include file="../../Conn/conn.asp" -->
<% 
			sql="insert into tb_NewMeg values('"&title&"','"&content&"','"&Date()&"')"
			rs.open sql,conn
			set rs=nothing 
			conn.close
			set conn=nothing
%>
			<!-- #include file="../../Conn/conn.asp" -->
<%	
			sql="select * from tb_NewMeg where Title='"&title&"'"
			rs.open sql,conn
			if rs.eof or rs.bof then 
%>
				<script language="javascript">
					alert("保存失败，请重新保存");
					history.back();
				</script>
		<% else %>
				<script language="javascript">
					alert("物流动态信息添加成功");
					window.close();
					opener.location.reload();
				</script>
		<% end if %>
	<% end if %>