package?org.apache.jsp;

import?javax.servlet.*;
import?javax.servlet.http.*;
import?javax.servlet.jsp.*;
import?java.util.Date;
import?java.sql.*;

public?final?class?business_jsp?extends?org.apache.jasper.runtime.HttpJspbase
????implements?org.apache.jasper.runtime.JspSourceDependent?{

??private?static?java.util.Vector?_jspx_dependants;

??public?java.util.List?getDependants（）?{
????return?_jspx_dependants;
??}

??public?void?_jspService（HttpServletRequest?request?HttpServletResponse?response）
????????throws?java.io.IOException?ServletException?{

????JspFactory?_jspxFactory?=?null;
????PageContext?pageContext?=?null;
????HttpSession?session?=?null;
????ServletContext?application?=?null;
????ServletConfig?config?=?null;
????JspWriter?out?=?null;
????object?page?=?this;
????JspWriter?_jspx_out?=?null;
????PageContext?_jspx_page_context?=?null;


????try?{
??????_jspxFactory?=?JspFactory.getDefaultFactory（）;
??????response.setContentType（“text/html;?charset=GBK“）;
??????pageContext?=?_jspxFactory.getPageContext（this?request?response
??????			null?true?8192?true）;
??????_jspx_page_context?=?pageContext;
??????application?=?pageContext.getServletContext（）;
??????config?=?pageContext.getServletConfig（）;
??????session?=?pageContext.getSession（）;
??????out?=?pageContext.getOut（）;
??????_jspx_out?=?out;

??????out.write（“\r\n\r\n\r\n\r\n\r\ntle>\r\nbusiness\r\ntle>\r\n\r\n\r\n“）;

//建立數據庫連接
Connection?conn=null;
Statement?stat=null;
try{
??String?driver=“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
??String?url=“jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=db_database01“;
??String?username=“sa“;
??String?password=““;
??Class.forName（driver）;
??conn=DriverManager.getConnection（urlusernamepassword）;
??stat=conn.createStatement（）;
}catch（Exception?e）{
??e.printStackTrace（）;
}
//執行業務邏輯
if（request.getParameter（“topicId“）==null）{?????//添加主題
??String?topic?=?request.getParameter（“topic“）;
??String?content?=request.getParameter（“content“）;
??//通過轉碼解決中文亂碼
??topic=new?String（topic.trim（）.getBytes（“ISO8859_1“）“GB2312“）;
??content=new?String（content.trim（）.getBytes（“ISO8859_1“）“GB2312“）;
??Date?date=new?Date（）;
??int?year=date.getYear（）+1900;
??int?month=date.getMonth（）+1;
??int?day=date.getDate（）;
??String?dates=year+“-“+month+“-“+day;
??String?sql=“insert?into?tb_topicGF（ownertopiccontentdates）?values（‘高飛‘‘“+topic+“‘‘“+content+“‘‘“+dates+“‘）“;
??try{
????stat.executeUpdate（sql）;
??}catch（Exception?e）{
????e.printStackTrace（）;
??}
}else{?????//刪除主題
??try{
????String?topicId=request.getParameter（“topicId“）;
????stat.executeUpdate（“delete?from?tb_topicGF?where?id=“+topicId）;
??}catch（Exception?e）{
????e.printStackTrace（）;
??}
}
//關閉數據庫連接
try{
??stat.close（）;
??conn.close（）;
}catch（Exception?e）{
??e.printStackTrace（）;
}
//轉入成功頁
response.sendRedirect（“success.jsp“）;

??????out.write（“\r\n