<%@ page contentType="text/html; charset=gb2312"%> <%@ page import="java.util.*"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%> <%@ page import="org.apache.commons.fileupload.*" %> <%@ page import="java.text.*" %> <%@ page import="javax.servlet.*,javax.servlet.http.*"%> <jsp:useBean id="conn" scope="page" class="DBLink.DBSQL"/> <jsp:useBean id="ReadTemplates" scope="page" class="ball.news.ReadTemplates"/> <jsp:useBean id="WriteHtml" scope="page" class="ball.news.WriteHtml"/> <jsp:useBean id="ReplaceAll" scope="page" class="ball.news.ReplaceAll"/> <% //request.setCharacterEncoding("gb2312");
try{ String dir=request.getRealPath("."); DiskFileUpload fu = new DiskFileUpload();
fu.setSizeMax(4194304); //设置文件大小. 这里文件只能上传4M以内的
fu.setSizeThreshold(4096); //设置缓冲大小.
fu.setRepositoryPath(dir+"/ball/news/images"); //设置临时目录.
List fileItems = fu.parseRequest(request); //解析请求,返回一个集合.
Iterator i = fileItems.iterator(); String fieldvalue=""; String ff = ""; String picname="false"; Object tt = ""; Vector v = new Vector();
while(i.hasNext()) {
FileItem fi = (FileItem)i.next();
if(fi.isFormField()) //这是用来确定是否为文件属性, {
String fieldName = fi.getFieldName(); //这里取得表单名 fieldvalue=fi.getString(); //这里取得表单值
v.addElement(fieldvalue);
}
else //这里开始外理文件 {
File fullFile = new File(fi.getName()); ff = fullFile.getName(); String rr = "";
java.util.Date date2 = new java.util.Date(); SimpleDateFormat formatter = new SimpleDateFormat ("yyyyMMddHHmmss"); //取得时间 String str2 = formatter.format(date2); StringTokenizer st = new StringTokenizer(ff,"."); if (st.hasMoreTokens()){ String test12 = st.nextToken(); rr = st.nextToken(); //System.out.println(rr); } if (rr.equals("")&&!rr.equals("gif")&&!rr.equals("jpg")&&!rr.equals("jpeg")) { picname = "false"; }
else { picname = str2+"."+rr; //以时间为图片名称
File savedFile = new File(getServletContext().getRealPath("/ball/news/images/"),picname);
fi.write(savedFile); //上传到服务器 } //System.out.println("picname------------------------"+picname); } //System.out.println("v------------------------"+v); } String[] flag = {"<temp_title>","<temp_date>","<temp_author>","<temp_content>","<str_Temp>","<temp_picture>"};
//将数据写入到数据库 Object newtype1 = v.elementAt(0); String t = newtype1.toString(); int newtype = Integer.parseInt(t); Object rowid1 = v.elementAt(1); String rowid = rowid1.toString(); Object title1 = v.elementAt(2); String title = title1.toString(); Object content1 = v.elementAt(3); String content = content1.toString(); // System.out.println(down); java.util.Date date = new java.util.Date(); String strdate = date.toLocaleString();
java.util.Date StrDate1 = new java.util.Date(); String StrDate = StrDate1.toLocaleString(); // 新闻发布时间 //String newtype="0"; conn.openDB(); String sql = "select top 5 * from b_news where newtype="+newtype+" order by id desc"; String strTemp="<tr><td>相关新闻</td></tr>"; ResultSet rs = conn.executeQuery(sql); while (rs.next()) { String t2 = rs.getString(2); String t4 = rs.getString(4); strTemp += "<tr><td>"; strTemp +="<a href=../../../"+t4+">"; strTemp += t2; strTemp +="</a>"; } strTemp +="</td></tr>"; rs.close();
//读取模板
String filePath = ""; filePath = request.getRealPath("\\ball\\news\\pnews.template"); String templateContent = null; try{ templateContent = ReadTemplates.getTlpContent(filePath); System.out.println(templateContent); } catch(Exception e) { System.out.println("error to template!"); } //替换模板中的内容 //System.out.println("picname--------------------------------"+picname);
templateContent = ReplaceAll.replace(templateContent,flag[0],title); templateContent = ReplaceAll.replace(templateContent,flag[1],StrDate); //templateContent = ReplaceAll.replace(templateContent,flag[2],editer); templateContent = ReplaceAll.replace(templateContent,flag[3],content); templateContent = ReplaceAll.replace(templateContent,flag[4],strTemp); templateContent = ReplaceAll.replace(templateContent,flag[5],picname);
// 根据时间得文件名与路径名
Calendar calendar = Calendar.getInstance(); String fileName = String.valueOf(calendar.getTimeInMillis()) +".html"; String pathName = request.getRealPath("ball/news")+"\\"+ calendar.get(Calendar.YEAR) + "\\"+ (calendar.get(Calendar.MONTH)+1) +"\\"+ calendar.get(Calendar.DAY_OF_MONTH)+"\\"; String url = calendar.get(Calendar.YEAR) + "/"+ (calendar.get(Calendar.MONTH)+1) +"/"+ calendar.get(Calendar.DAY_OF_MONTH)+"/"; url +=fileName; //System.out.println(url);
try{ WriteHtml.save(templateContent,pathName,fileName); }catch(Exception e){ System.out.println("error to html!-----------"+e.getMessage()); }
//写入数据库 String sqlInsert = null; if (!picname.equals("false")){ sqlInsert = "insert into b_news (title,content,url,picture,newtype,addtime,rowid) values (‘"+title+"‘,‘"+content+"‘,‘"+url+"‘,‘"+picname+"‘,‘"+newtype+"‘,getdate(),‘"+rowid+"‘)"; } else { picname="images/"+picname; sqlInsert = "insert into b_news (title,content,url,newtype,addtime,rowid) values (‘"+title+"‘,‘"+content+"‘,‘"+url+"‘,‘"+newtype+"‘,getdate(),‘"+rowid+"‘)"; } //System.out.println("sql insert---------------"+sqlInsert); conn.executeUpdate (sqlInsert); } catch(Exception e) { System.out.println("upload error------------------"+e.getMessage()); }
%> <%out.println("新闻生成html成功了!");%>
|