package?Insert;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.jspsmart.upload.SmartUpload;
import?com.jspsmart.upload.SmartUploadException;
import?com.mysql.jdbc.Statement;

public?class?insertGuochuang?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?insertGuochuang（）?{
		super（）;
	}

	/**
	?*?Destruction?of?the?servlet.?

	?*/
	public?void?destroy（）?{
		super.destroy（）;?//?Just?puts?“destroy“?string?in?log
		//?Put?your?code?here
	}

	/**
	?*?The?doGet?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		this.doPost（request?response）;
	}

	/**
	?*?The?doPost?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
	
			response.setCharacterEncoding（“utf-8“）;//字符編碼utf-8
			response.setContentType（“text/html“）;
			PrintWriter?out?=?response.getWriter（）;
			SmartUpload?su=new?SmartUpload（）;
			su.initialize（this.getServletConfig（）requestresponse）;
			su.setMaxFileSize（1024*1024*10）;?//上傳圖大小最大為10M
			su.setAllowedFilesList（“jpgpnggif“）;//支持格式
			try?{
				su.upload（）;
				String?savepath=request.getSession（）.getServletContext（）.getRealPath（“/“）+“images\\main“;??//request.getSession（）.getServletContext（）.getRealPath（“/“）取得整個web應用的物理根路徑（注意不是jsp項目根路徑）
				su.save（savepath）;
				String?image=“images/main/“+su.getFiles（）.getFile（0）.getFileName（）;//-
				String?time=su.getRequest（）.getParameter（“time“）;//-
				String?drama=su.getRequest（）.getParameter（“drama“）;//-
				String?information=su.getRequest（）.getParameter（“information“）;//-
				String?author=su.getRequest（）.getParameter（“author“）;//-
				String?name=su.getRequest（）.getParameter（“name“）;//-
				
				String?uname=“root“;
				String?pwd=“123456“;
				String?url=“jdbc:mysql://localhost:3306/dongman“;
				Class.forName（“com.mysql.jdbc.Driver“）;
				Connection?conne

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-03-16?10:47??Project_Comics\
?????文件?????????529??2017-12-21?18:42??Project_Comics\.classpath
?????文件?????????315??2017-12-24?14:13??Project_Comics\.mymetadata
?????文件????????1757??2017-12-21?18:46??Project_Comics\.project
?????目錄???????????0??2019-03-16?10:47??Project_Comics\.settings\
?????文件?????????500??2017-12-21?18:43??Project_Comics\.settings\.jsdtscope
?????文件?????????260??2018-08-15?14:20??Project_Comics\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-12-21?18:42??Project_Comics\.settings\org.eclipse.jdt.core.prefs
?????文件?????????480??2017-12-21?18:42??Project_Comics\.settings\org.eclipse.wst.common.component
?????文件?????????252??2017-12-21?18:42??Project_Comics\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-12-21?18:42??Project_Comics\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-21?18:42??Project_Comics\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\meta-INF\
?????文件??????????36??2017-12-21?18:42??Project_Comics\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\WEB-INF\
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\WEB-INF\classes\
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\WEB-INF\classes\Insert\
?????文件????????4224??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\Insert\insertGuochuang.class
?????文件????????4208??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\Insert\insertMovie.class
?????文件????????4224??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\Insert\insertRecommend.class
?????文件????????4208??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\Insert\insertRiman.class
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\WEB-INF\classes\MyFilter\
?????文件????????2064??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyFilter\userfilter.class
?????目錄???????????0??2019-03-16?10:47??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\
?????文件????????1273??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\Cartoon.class
?????文件????????2275??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\GuoChuang.class
?????文件????????2259??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\Movie.class
?????文件?????????935??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\MyConnection.class
?????文件????????2275??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\Recommend.class
?????文件????????2259??2018-12-25?20:48??Project_Comics\WebRoot\WEB-INF\classes\MyJavaBean\RiMan.class
............此處省略184個文件信息