import?javax.servlet.*;
import?javax.servlet.http.*;
import?java.sql.*;
import?java.util.*;
import?java.io.*;
import?java.util.Calendar;
import?java.util.Date;
import?db.*;

public?class?addbookservlet?extends?HttpServlet?{
	private?dbConn?myconn;
	//Servlet的構造函數
	public?addbookservlet（）?{
		myconn?=?new?dbConn（）;//加載數據庫驅動
	}

	//接收GET請求，執行數據庫操作，把視圖派發到下一個頁面
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?IOException?ServletException?{
		response.setContentType（“text/html;charset=gb2312“）;
		request.setCharacterEncoding（“gb2312“）;//解決編碼問題
		int?bookid?=Integer.parseInt（request.getParameter（“bookid“））;
		String?bookname?=?request.getParameter（“bookname“）;
		String?author?=?request.getParameter（“author“）;
		String?publisher?=?request.getParameter（“publisher“）;
		String?year?=?request.getParameter（“year“）;
		String?isbn?=?request.getParameter（“isbn“）;
		try
		{
			int?flag=myconn.executeUpdate（“insert?into?book（bookidbooknameauthorpublisheryearisbnstatus）?values（‘“+bookid+“‘‘“+bookname+“‘‘“+author+“‘‘“+publisher+“‘‘“+year+“‘‘“+isbn+“‘‘1‘）“）;	
			PrintWriter?out?=?response.getWriter（）;
			if（flag==1）
			{
				request.setAttribute（“flag““1“）;
			}
			else
			{
				request.setAttribute（“flag““0“）;
			}
			RequestDispatcher?requestDispatcher?=?request.getRequestDispatcher（“zbbaddbook.jsp“）;
			requestDispatcher.forward（request?response）;
			myconn.closeConn（）;//關閉數據庫連接
		}
		catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	//和GET請求的處理一樣
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?IOException?ServletException?{
		doPost（request?response）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-27?14:06??MyEclipse?8.6\
?????目錄???????????0??2013-06-06?23:09??MyEclipse?8.6\.metadata\
?????文件???????????0??2013-06-06?23:08??MyEclipse?8.6\.metadata\.lock
?????文件??????427678??2013-06-11?09:04??MyEclipse?8.6\.metadata\.log
?????目錄???????????0??2013-06-06?23:09??MyEclipse?8.6\.metadata\.me_tcat\
?????目錄???????????0??2013-06-06?23:09??MyEclipse?8.6\.metadata\.me_tcat\temp\
?????目錄???????????0??2013-06-08?19:14??MyEclipse?8.6\.metadata\.plugins\
?????目錄???????????0??2013-06-06?23:29??MyEclipse?8.6\.metadata\.plugins\com.collabnet.subversion.merge\
?????目錄???????????0??2013-06-06?23:29??MyEclipse?8.6\.metadata\.plugins\com.collabnet.subversion.merge\MergeResults\
?????目錄???????????0??2013-06-08?19:14??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.dehory\
?????目錄???????????0??2013-06-07?12:00??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.derby\
?????目錄???????????0??2013-06-06?23:09??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.easie.tomcat.myeclipse\
?????目錄???????????0??2013-06-06?23:58??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.hibernate\
?????目錄???????????0??2013-06-06?23:09??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\
?????文件????????1606??2013-06-07?13:52??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\ConnectionProfiles.xml
?????文件???????17347??2013-06-07?13:52??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\SQLDrivers.xml
?????目錄???????????0??2013-06-07?19:19??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.templates\
?????文件????????3735??2013-06-08?19:14??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.templates\velocity.log
?????目錄???????????0??2013-06-11?12:27??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\
?????目錄???????????0??2013-06-11?09:04??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\
?????文件????????2047??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\base.xml
?????文件????????1989??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\baselabel.xml
?????文件????????1486??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\blocklabel.xml
?????文件?????????702??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\booleanCheckbox.xml
?????文件????????1271??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\button.xml
?????文件????????2889??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\commandButton.xml
?????文件????????1170??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\containerbase.xml
?????文件????????1043??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\directionTable.xml
?????文件?????????556??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\emptycontainer.xml
?????文件?????????998??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\graphicImage.xml
?????文件????????1031??2013-06-07?10:35??MyEclipse?8.6\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\bindings\hidden.xml
............此處省略1141個文件信息