<%@ page errorPage="error.jsp" %>
<%@ page language="java"%>
<%@ page import="java.util.Date" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%><%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
	response.sendRedirect("login.jsp");
} %> 
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<%
String d,tempclass2,sql,tempclass1,file1,file2,file3,oldfile1,oldfile2,oldfile3;
//聲明變量
Date dd = new Date();//定義一個date型的變量
d = dd.toLocaleString();//日期格式轉換為當前系統設定值
oldfile1 = request.getParameter("file1").trim();
oldfile2 = request.getParameter("file2").trim();
oldfile3 = request.getParameter("file3").trim();
file3=new String(oldfile3.getBytes("ISO8859_1"),"GBK");
file2=new String(oldfile2.getBytes("ISO8859_1"),"GBK");
file1=new String(oldfile1.getBytes("ISO8859_1"),"GBK");

String author=new String(request.getParameter("author").getBytes("ISO8859_1"),"GBK");
String news=new String(request.getParameter("news").trim().getBytes("ISO8859_1"),"GBK");
String title=new String(request.getParameter("title").trim().getBytes("ISO8859_1"),"GBK");
//得到post提交過來的參數值，并予以編碼轉換
if(news.equals("")||title.equals("")) response.sendRedirect("add.jsp");//如果記錄標題為空或是正文為空，則不予處理，返回到記錄添加頁面
else
{
String parentclass=new String(request.getParameter("selMain").getBytes("ISO8859_1"),"GBK");

String class2=new String(request.getParameter("selSlave").getBytes("ISO8859_1"),"GBK");
//得到記錄的類目信息，并予以編碼轉換
ResultSet rs = sqlbean.executeQuery("select * from class where parentclass='"+parentclass+"' and class='"+class2+"'");
//調用sqlbean的executeQuery方法找到類別標識，并將結果賦予rs這個記錄集
rs.first();	//如果返回的記錄集不為空
String classid2=rs.getString("id");
rs.close();
int classid = Integer.parseInt(classid2);//將要添加的類ID轉換為int類型
//sql="INSERT INTO news (news, d,parentclass,class,title) Values ('"+news+"', '"+d+"','"+parentclass+"', '"+class2+"', '"+title+"')";
sql="INSERT INTO news (news,classid, d,parentclass,class,title,file1,file2,file3,author,hit) Values ('"+news+"', "+classid+",'"+d+"','"+parentclass+"', '"+class2+"', '"+title+"', '"+file1+"', '"+file2+"', '"+file3+"', '"+author+"',0)";
//實現記錄插入操作的SQL語句
sqlbean.executeInsert(sql);//調用sqlbean的executeInsert方法將記錄插入數據庫中
}
%>
<jsp:forward page="add_cfrm.jsp"/>