I. Project Name: J2EE Three-layer Structure Book Management System DEMO 1.0
Second, the author: Luo Lei
Third, development tools: Dreamweaver MX 2004 (with JB9 editing JSP page) JBuilder WebLogic Edition 9.0.125.0 Weblogic 8.1.3.0 (Chinese) Oracle 9.0.1
Fourth, Database: Database character set: US7ASCII Country character set: America Sid: DYHSB User: Hujq Password: 1874 Name field Property Description 1, CZRY ID VARCHAR2 (10) Primary Key: Operator KL VARCHAR2 (10) Password 2, BookInfo BH Number (10) Primary Key: Book No. MC VARCHAR2 (40) Title ZZ VARCHAR2 (40) Authors CBS VARCHAR2 (40) Press FXRQ VARCHAR2 (20) Release Date TSFL VARCHAR2 (10) Book Classification
3, TSFL ID VARCHAR2 (10) Classification number FL VARCHAR2 (10) Category 5: WebLogic Configuration 1, copy C: / BEA / WebLogic81 / Server / Bin / OCI901_8 to copy to the previous directory : C: / BEA / WebLogic81 / Server / BIN / below: WebLogic connection Oracle database has three ways, which is the driver comes with WebLogic to connect the Oracle database, because Oracle comes with the driver Classes12.zip when displaying Chinese It is garbled, the upload file is also written, it is recommended to use this OCI mode) 2, new Basic WebLogic Server Domain domain after WebLogic 8.1.3, start the domain into the console (http: // localhost: 7001 / console) Configure the JDBC Connection Pool and Data Source Connection Configuration: Database Type: Oracle Driver: WebLogic's Oracle Driver (TYPE2) Before you are configured: Name: hujqpool URL: JDBC: WebLogic: Oracle: DYHSB driver class: WebLogic. Jdbc.oci.driver attribute: user = hujq code = GBK Server = DYHSB password: 1874 data Source Configuration: Name: Hujqds JNDi Name: hujqds (Remember this name, use this in the program to deal in the program) buffer pool: hujqpool 6: JBuilder Configuration 1, Tools ------ Configure Servers ---- - Select WebLogic Platform Server8.x, right ENABLE Server tick, below the contents of the two tabs according to your actual configuration, then you can use 2, Tools ------- Editor Options ----- --- Color ----- Java one of the following options, if you have a hook in front of the bold on the right, please go, don't write the code, the cursor and the input location is often missed :) 嘿嘿
7: Source code description: 1. New project file: TSGL.JPX 2, New Web Application: TSGL 3, New EJB2.0: TSGL 4, JSP file: (represent layer) addbook.jsp ----- >> increase The form input of the book is submitted to servlet (addts.java), and the JavaBean (Flbean.java) is called to display the maintenance book classification. Book_list.jsp --- >> Page Display the book information in the database, provide print function Delbook.jsp ----- >> Delete book, entry the book number and submit it to servlet (delts.java) index.jsp --- ---- >> Login page, submit users and passwords to servlet (DL.java) left.jsp -------- >> System Function Menu Main.jsp -------- >> System main console page Manager.jsp ----- >> Background management page (to be continued) Printer.jsp ----- >> Call the ACTIVX control with Windows print function code TOP.JSP ----- ---- >> Main console banner (with left.jsp, work.jsp) Work.jsp -------- >> Workspace Java file: (process control layer, including Servlet, JavaBean) Addts.java ------ >> Receive the input from addbook.jsp, and call the ejb's AddbookInfo method to write the book information into the database book.java after encoding the conversion. > Call EJB's getBookInfo code.java ---- >> Common class: Character encoding conversion (the encoding of the web server is ISO-8895-1, JSP must be GB2312 to display Chinese) DELTS.JAVA ----- - >> Delete the servlet of the book, receive the number of book numbers passed by DelBook.jsp, then call the EJB DelBookInfo to delete the DL.java -------- >> Receive the username and password passing the index.jsp. Then call the EJB's Check method to verify Flbean.java ----- >> belonging to JavaBean, calling EJB Get FLTABLE, get the List object of the book classification, Page.java ------- >> Publication Category: The control of business logic, displays the next side according to the Servlet's Request and Response objects.
