Family web
1.0.0
2 years ago JSP PROJECT Review & Front End Boot Strap
I don't know what the problem is -problem: DB connection. Ping Failed
What if you change again?
-> Program execution environment should be set up and gitHub should be linked.
-> What to solve
Determined to use git bash for maintenance management
$ git init
$ git remote add origin [url]
$ git pull origin master
$ git add .
$ git commit -m ' modify file '
$ git push origin masterC: TOMCAT 8.0 -Tomcat Installation Route This must be stopped at this time. If you work in Eclipse while running, port collisions occur-> configure Tomcat-> http: // localhost: 8080
Dynamic project creation
JSP File
Tomcat 8.0.30 with Eclipse Jee (EE) Server Test Success
Oracle Database Setting
There was an error in the DB interlocking during the previous project rehabilitation, which seems to be a port number error. In the previous project, the Oracle port number was set to 9090. ------------ 12-27/5: 36 Tasks until DB setting, test completed
Error name: Tomcat Server Error -Port 8080 ALREADY in use error: Other Process is using the port. Solution: Run CMD with administrator privileges.
> netstat -ano | findstr 8080
> taskkill /F /pid [해당 포트를 사용하고 있는 놈 번호]
Ping Failed continued to ping test. I finally found a solution to this.
Eclipse and Oracle linkage success with JSP account (the same as password JSP)
Complete the overall framework, including the current INDEX page.
It seems to need to be beautifully decorated using bootstrap on the front end.
Running Eclipse by turning on the computer and again, it was not connected to the DB again (Ping Failed)
=> Ping succeeded after restarting OracleServicexe and Oraclexetnslistener services in the list of work managers/service.
INSERT.JSP Run-> Test whether INSERT is inserted in DB
SQL> conn jsp/jsp
SQL> desc book
SQL> col publisher format a10 /* 출력 시 해당 column이 차지하는 칸 수 조정 */
SQL> col writer format a5
SQL> set line 150 /* 출력 라인 칸 수 조정 */
SQL> select * from book;
https://timjlee.github.io/post-let/
delete.jsp, delete_ok.jsp test success
Modified. After reviewing the ArrayList side, the data value from the client should be taken as ArrayList and put into the DB.
It is connected to the DB only when the service is re -executed periodically.
Bootstrap is applied to decorate the main page.
Crash by pushing without git pull. -> Solve the merger problem with Source Tree
JavaBean posting after learning blog
Once the Eclipse was Run, I knew that Oracletnslistener was executed.
Add a new table to the DB
create table jsp_member
(no number primary key ,
name varchar2 ( 20 ) not null ,
id varchar2 ( 15 ) not null ,
passwd varchar2 ( 10 ) not null ,
ssn1 varchar2 ( 6 ) not null ,
ssn2 varchar2 ( 7 ) not null ,
email varchar2 ( 30 ),
hp1 varchar2 ( 3 ),
hp2 varchar2 ( 4 ),
hp3 varchar2 ( 4 ),
joindate varchar2 ( 10 ));
create sequence jsp_member_no ;Successful registration test
I can't find a reason that I can't maintain DB Connection for more than 5 seconds. There is a hassle of testing and testing two services periodically
-- 오류원인 첫번째 : tomcat 과 oracle 이 같은 포트번호(8080)을 사용하고 있었음. oracle port 9090으로 변경
SQL > conn / as sysdba
SQL > select dbms_xdb . gethttpport () from dual;
SQL > exec dbms_xdb . sethttpport ( 9090 );
-- 위와 같이 한 후 다시 해보니 이번엔 ORA-12519 error 발생.
-- 검색해보니 프로세스 할당 수를 늘려주면 해결이 된다는 사례가 많아서 시도해봄.
SQL > alter system set processes = 500 scope = spfile;
SQL > shutdown immediate;
SQL > startup;
SQL > SELECT * FROM v$resource_limit WHERE resource_name IN ( ' processes ' , ' sessions ' );
-- 이것까지 해보았으나 12초정도 지나고 db와의 연결이 끊어지는 문제는 계속 발생함. Since there may have been a conflict with the Oracle used and used for the existing school DB Project, it was proceeded as follows after deleting.
After deleting the Oracle 11g in conjunction with the JSP, reinstallation C: oraclexe App oracle Product 11.2.0 Server bin Run SQLPLUS.EXE
SQL > conn system / oracle -- 관리자 계정 접속
SQL > exec dbms_xdb . sethttpport ( 9090 ); -- http포트번호 바꾸기
SQL > select dbms_xdb . gethttpport () from dual; -- 포트번호 확인하기
SQL > create user jsp identified by jsp; -- 사용자 계정 만들기
SQL > grant connect, resource to jsp; -- 계정에 권한주기
SQL > conn jsp / jsp -- 사용자계정으로 들어가기
-- table 생성
SQL > create table book
(name varchar2 ( 20 ),
writer varchar2 ( 20 ),
publisher varchar2 ( 30 ),
price number ,
joindate varchar2 ( 10 ));
SQL > create table jsp_member
(no number primary key ,
name varchar2 ( 20 ) not null ,
id varchar2 ( 15 ) not null ,
passwd varchar2 ( 10 ) not null ,
ssn1 varchar2 ( 6 ) not null ,
ssn2 varchar2 ( 7 ) not null ,
email varchar2 ( 30 ),
hp1 varchar2 ( 3 ),
hp2 varchar2 ( 4 ),
hp3 varchar2 ( 4 ),
joindate varchar2 ( 10 ));
create sequence jsp_member_no ;Finally, the error was resolved. The cause of the previous error is chosen as follows.
Alter Table Book 2 Modify Name Varchar2 (30);
< input type =" button " value =" 수정 " onClick =" location.href='http://www.daum.net' " > < input type =" button " value =" 버튼 " onClick =" window.open('http://www.daum.net') " >git branch front1
git branch
git checkout front1 // front1 branch 로 작업스페이스 변경
git checkout master // master 로 돌아가기
git checkout front1
git branch front2 // front1 상태를 그대로 가져간 front2 branch
git checkout master
git merge front2 // front1 의 상태를 포함한 front2 를 master 로 병합FRONT3 -Once with the version master until just before using the DB Connection Pool
Book management programs are updated so that only users who log in
TOP.JSP Added Login Function to the upper right corner
If you fail to log in, you have set up to go to login.jsp.
Find a password as a login page function, add ID Finding function
Bootstrap 3.3.1-> Upgraded Revolutionary Engineering to 4.4.1
Modify the error that requires ID password when clicking the membership button
Server hosting test using UDP through port forwarding. A total of three users accessed the site with another IP and tested the bulletin board posts and book registration without errors.
Answer bulletin board function, file upload function, chat function will be added after tomorrow
221.145.79.167 -IP inside and outside
172.30.1.48 -My internal IP
ID: ktuser
Password: Homehub
https://m.blog.naver.com/catstar9898/220804915390 -How to forward KT port forwarding
http://221.145.79.167:8080/home/login/login.jsp -Login page
When you enter the login page after logging in, you should also get a login session on a bug found that you do not maintain the session.
ID redundant confirmation function is pending for a while due to lack of understanding AJAX concept
Answer bulletin board function, paging function added to the bulletin board
Bulletin JavaScript error resolution: The problem caused by the overlapping form name overlapped with F
Restructuring from the existing MVC1 pattern to the MVC2 pattern
DB schema modification
