<%
rs.close();
ps.close();
conn.close();
%>
新闻发布
<%@ page language="java" import="java.util.*,java.sql.*,javax.servlet.http.HttpSession"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page pageEncoding="gb2312"%>
<%request.setCharacterEncoding("gb2312");%>
<%
try{
String ss=(String)session.getAttribute("id");
if( ss.length() <1)
{
out.println("登陆失败,只有登陆为管理员才能管理系统");
}
else
{
out.println("欢迎,管理员");
}
}
catch(Exception e){
//out.println("登陆失败,只有登陆为管理员才能管理系统");
response.sendRedirect("denglu.jsp");
}
%>
<%
String biaoti=req
uest.getParameter("biaoti");
String zhengwen=request.getParameter("zhengwen");
if( biaoti!=null &;&; zhengwen!=null )
{
String url="jdbc:odbc:d1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String user="";
String password="";
Connection conn;
conn=DriverManager.getConnection(url,user,password);
Statement ps=conn.createStatement();
String sql="insert into xinwen(biaoti,zhengwen) values('" + biaoti + "','" + zhengwen + "')";
int affectnum=ps.executeUpdate(sql);
ps.close();
conn.close();
out.println("成功添加新闻");
out.println("请继续添加新闻");
}
else
{
out.println("请正确输入数据");
}
%>
&;nbsp;