<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>

<%!
String id = "";
String title = "";
String title1 = "";
String content = "";
String keyw = "";
String author = "";
boolean flag1=false;
boolean flag2=false;
boolean flag3=false;
boolean flag4=false;
boolean flag5=false;
String sql = "";
ResultSet rs = null;
%>
<link rel="stylesheet" type="text/css" href="news.css">
<%
	Connection conn=null;
	Statement stmt= null;
	ResultSet rs =null;
	try
	{
		String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		 conn =DriverManager.getConnection(strurl);
		 stmt= conn.createStatement();
		 rs= stmt.executeQuery("select * from news");
	}
	catch(Exception e)
	{
	out.println("輸出錯誤!") ;
	out.println(e) ;	
	}
request.setCharacterEncoding("GBK");
if(request.getParameter("id")!=null)     {
	flag1=true; id = request.getParameter("id");
}
if(request.getParameter("title")!=null)  {
	flag2=true; title = request.getParameter("title");
}
if(request.getParameter("body")!=null)   {
	flag3=true; content = request.getParameter("body");  
}
if(request.getParameter("keyw")!=null)    {
	flag4=true; keyw = request.getParameter("keyw");
}
if(request.getParameter("author")!=null)  {
	flag5=true; author = request.getParameter("author");
}
// 如果title不為空，則添加或修改記錄
if(flag1 & flag2 & flag3 & flag4 & flag5 ) {
        // 執行插入操作
	    sql =  "update news set title='" + title ;
	    sql += "',content='" + content + "',keyw='" + keyw + "',author='";
	    sql += author + "' where id=" + id;
        stmt.executeUpdate( sql );
		out.println("<hr>");
		out.println("<h2>新聞添加成功！</h2>");
		out.println("<hr>");
}else {
		out.println("<hr>");
        out.println("<h2>請輸入正確的信息后再進行錄入！</h2>");
		out.println("<hr>");
}
%>
<jsp:forward page="newsedit.jsp"/>