ReeBook

---

정리안됨

0115 길어서 나중에 한번에 2020학년도 1학기 교재대여사업

Working History> 0101 / o.s.w.s.r.ResourceHttpRequestHandler : Path with jsp 파일의 경로를 올바르게 지정했음에도 STS에서 경로 오류가 발생하며 웹페이지에선 404 에러.

Solve > https://dogcowking.tistory.com/326 걍 리부팅;

• 스프링부트로 실행한 상태에서 properties에 경로를 변경해줘서 발생하는 듯.

Error?

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2020-01-01 08:09:50.334 ERROR 8968 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: Docs at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108) ~[spring-context-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) ~[spring-context-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) [spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.2.2.RELEASE.jar:2.2.2.RELEASE] at net.skhu.Rb0Application.main(Rb0Application.java:10) [classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_221] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_221] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_221] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_221] at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-2.2.2.RELEASE.jar:2.2.2.RELEASE] Caused by: java.lang.NoClassDefFoundError: Docs at java.lang.Class.getDeclaredMethods0(Native Method) ~[na:1.8.0_221] at java.lang.Class.privateGetDeclaredMethods(Unknown Source) ~[na:1.8.0_221] at java.lang.Class.getDeclaredMethods(Unknown Source) ~[na:1.8.0_221] at org.hibernate.annotations.common.reflection.java.JavaXClass.getDeclaredMethodProperties(JavaXClass.java:95) ~[hibernate-commons-annotations-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.annotations.common.reflection.java.JavaXClass.getDeclaredProperties(JavaXClass.java:112) ~[hibernate-commons-annotations-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.annotations.common.reflection.java.JavaXClass.getDeclaredProperties(JavaXClass.java:104) ~[hibernate-commons-annotations-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.cfg.InheritanceState.determineDefaultAccessType(InheritanceState.java:252) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.cfg.InheritanceState.getElementsToProcess(InheritanceState.java:211) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:781) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.boot.model.source.internal.annotations.AnnotationMetadataSourceProcessorImpl.processEntityHierarchies(AnnotationMetadataSourceProcessorImpl.java:254) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess$1.processEntityHierarchies(MetadataBuildingProcess.java:230) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:273) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1202) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1233) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) ~[spring-orm-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) ~[spring-beans-5.2.2.RELEASE.jar:5.2.2.RELEASE] ... 21 common frames omitted Caused by: java.lang.ClassNotFoundException: Docs at java.net.URLClassLoader.findClass(Unknown Source) ~[na:1.8.0_221] at java.lang.ClassLoader.loadClass(Unknown Source) ~[na:1.8.0_221] at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) ~[na:1.8.0_221] at java.lang.ClassLoader.loadClass(Unknown Source) ~[na:1.8.0_221] at org.springframework.boot.devtools.restart.classloader.RestartClassLoader.loadClass(RestartClassLoader.java:144) ~[spring-boot-devtools-2.2.2.RELEASE.jar:2.2.2.RELEASE] at java.lang.ClassLoader.loadClass(Unknown Source) ~[na:1.8.0_221] ... 42 common frames omitted

Docs Table Join Error 외래키 두개의 조합을 기본키로 사용하려 했으나, 위와 같은 오류 발생. 핵심은 Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 이 아니라 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.MappingException: Repeated column in mapping for entity: net.skhu.domain.Document column: id (should be mapped with insert="false" update="false")

기본키 값이 중복이 발생할 수 있는 경우? 등 무결성이 침해될 때 생기는 듯

기본키 id 만들기, 설정 변경 등등 해봤으나

• docs table 수정. mysql> desc docs; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | bid | int(10) unsigned | YES | MUL | NULL | | | lid | int(10) unsigned | YES | MUL | NULL | | | kind | char(10) | YES | | NULL | | +-------+------------------+------+-----+---------+-------+

mysql> desc document; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | id | int(10) unsigned | NO | PRI | NULL | | | bid | int(10) unsigned | YES | MUL | NULL | | | lid | int(10) unsigned | YES | MUL | NULL | | | kind | char(10) | YES | | NULL | | +-------+------------------+------+-----+---------+-------+

그럴필요없이 애초 기획대로 외래키 두개를 기본키로 사용하고, primary key(bid,lid) 엔티티에서 @Id 두개의 컬럼에 모두 붙여주며 엔티티 클래스는 implements Serializable.

Sol> https://dkfkslsksh.tistory.com/64

document table creation query update.

데이터베이스 연동은 성공. 실행 확인. &*1

/ 문제 재발 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.MappingException: Repeated column in mapping for entity: net.skhu.domain.Document column: id (should be mapped with insert="false" update="false")

걍 JoinColumn 잘못씀

+복합 PK Mapping Sol>http://blog.breakingthat.com/2018/03/16/jpa-entity-%EB%B3%B5%ED%95%A9pk-%EB%A7%B5%ED%95%91-embeddedid-idclass/

/ Json 형식으로 테스트 Sol>https://mrrootable.tistory.com/75 성공.

/ Github 연동 Sol>https://all-record.tistory.com/163 성공.

02/11

• 복합키, 외래키 to 기본키
  • http://woowabros.github.io/experience/2019/01/04/composit-key-jpa.html
  • https://jistol.github.io/java/2017/03/24/jpa-troubleshooting-no-indentifier-entity/
  • https://dkfkslsksh.tistory.com/64
• DB PW
  • https://blog.habonyphp.com/213
  • https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_password
• TODO issue
  • PW
    • in Spring?
    • in DB?

02/12

• JSP/JSTL Mix

  • https://tonyne.jeju.onl/2016/04/21/jsp-jstl-variation-cross-use/
  • JAVA>JSTL>HTML>Javascript

• User Accept the Terms add

  • http://wonwoo.ml/index.php/post/995

• !!! fucking redirect data transfer

  • jsp>controller>jsp redirect>recive
  • https://gdtbgl93.tistory.com/108
  • http://noveloper.github.io/blog/spring/2015/02/16/how-transport-parateter-when-redirect.html
  • https://m.blog.naver.com/PostView.nhn?blogId=allkanet72&logNo=220964699929&proxyReferer=https%3A%2F%2Fwww.google.com%2F

• SignUp last

  • https://kutar37.tistory.com/entry/%ED%95%9C%EA%B0%9C%EC%9D%98-Form%EC%97%90%EC%84%9C-%EC%97%AC%EB%9F%AC%EA%B0%9C-Submit-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0

• SignUp Layout

  • https://www.codingfactory.net/10510

Signup Delete part

SignUpSuc del

SignUp Upgrade

controller @RequestMapping(value="signup",method=RequestMethod.GET) public String signUpG(Model model) { // model.addAttribute("user",new User()); model.addAttribute("userRegistrationModel", new UserRegistrationModel()); model.addAttribute("deptList", departmentRepository.findAll()); return "user/signup"; }

@RequestMapping(value="signup",method=RequestMethod.POST,produces="text/plain;charset=UTF-8")
public String signUpP(@Valid UserRegistrationModel userModel, RedirectAttributes redirectAttributes,
		BindingResult bindingResult, Model model) throws Exception{
	
	System.out.println(userModel);
	
	if(bindingResult.hasErrors()) {
		model.addAttribute("deptList", departmentRepository.findAll());
		model.addAttribute("userRegistrationModel", userModel);
		return "user/signup";
	}
	
	userModel.setPwc(userModel.getPw().equals(userModel.getPc()));
	
	if(userModel.getAgree()&&userModel.getPwc()) {
		model.addAttribute("user",userModel);
		redirectAttributes.addFlashAttribute("user",userModel);
		redirectAttributes.addAttribute("user",userModel);
		//			return "redirect:./signups";
		//			return "user/signupsuc";
		return "redirect:signups";
	}
	else {
		model.addAttribute("deptList", departmentRepository.findAll());
		model.addAttribute(userModel);
		return "user/signup";
	}
}

jsp <form:form method="post" modelAttribute="user">

사용자 ID	<input type="text" name="user_id" autocomplete="on" size="20" maxlength="9" value=${ user.id==0?"":user.id }>	반드시 학번을 입력하세요 예) 201732009
이름	<input type="text" name="user_name" autocomplete="on" size="20" maxlength="20" value=${ user.name.equals("D")?"":user.name }>	시스템에 저장된 이름과 동일해야 합니다
암호
암호 확인
이메일	<input type="email" name="user_email" autocomplete="on" size="20" maxlength="30" value=${ user.email.equals("D")?"":user.email }>
연락처	<input type="text" name="user_hp" onKeyup="inputPhoneNumber(this);" size="20" autocomplete="on" maxlength="13" value=${ user.hp.equals("D")?"":user.hp }>	- 없이 입력
학년	<% int i=0; pageContext.setAttribute("index",i); %> <c:forEach var="i" begin="1" end="4" step="1"> <input type="radio" name="user_grade" value=<%=++i%> class="none" ${ user.grade==i?"checked":"" }> <%= i %>   </c:forEach>
소속	<c:forEach items="${deptList}" var="dept"> <option value=${ dept.id } ${dept.id==user.department.id?"selected":""}>${dept.name} </c:forEach>
회원가입	개인정보 수집 및 이용 동의	<input type="radio" name="user_agree" value="1" ${ user.agree?"checked":"" }&gt; 예     &lt;input type="radio" name="user_agree" value="0" ${ user.agree?"":"checked" }> 아니오

</form:form>

개같은 에러체크는 나중으로 현재 동일 아이디 save되는 형식.

• JSTL > JSP / JSP > JSTL

  • https://intro0517.tistory.com/129 !

• H/P input type

  • http://magic.wickedmiso.com/61

• 현재 과제제출시스템

  • 학번/이름 ... 양식 제약 없음
  • 학번 중복은 확인

• 쿼리 만들어서 PW 암호화 시도 - 실패.

  • http://wonwoo.ml/index.php/post/1004

• TODO password hashing

• #3 rent

• jsp style

  • https://www.codingfactory.net/10561
  • https://fonts.google.com/?subset=korean&selection.family=East+Sea+Dokdo

0214

• #3
• jsp
  • https://cpdev.tistory.com/25
  • https://hongku.tistory.com/123 modelAttribute
  • https://jootc.com/p/201807211394 alert
• jsp style
  • https://zzaps.tistory.com/68
  • http://uxuiz.cafe24.com/wp/archives/1445
  • direction = main/~
• jpa
  • entity compare:
    • https://stackoverflow.com/questions/49561425/cant-use-findone-in-my-code-with-jparepository
  • redirect:
    • https://m.blog.naver.com/PostView.nhn?blogId=allkanet72&logNo=220964699929&proxyReferer=https%3A%2F%2Fwww.google.com%2F

0218

• jsp
  • https://blog-pleur.tistory.com/36 table column
  • https://www.codingfactory.net/10691 js redirection
• jpa
  • https://jistol.github.io/java/2017/02/03/jpa-datetype/ date class
  • https://anddev.tistory.com/85 date set(Calendar)

0221

• jsp

  • #1: onclick https://wallel.com/onclick-%EB%A7%81%ED%81%AC-%EC%83%88%EC%B0%BD%ED%8C%9D%EC%97%85%ED%98%84%EC%9E%AC%EC%B0%BD%ED%94%84%EB%A0%88%EC%9E%84/
  • #1: cursor https://ofcourse.kr/css-course/cursor-%EC%86%8D%EC%84%B1
  • #1: hover https://www.w3schools.com/csSref/sel_hover.asp

• DB

  • update book set available='Y' where id=?;
  • delete from rent where bid=?;

0303 ~ 0304

• Project Locker00 >> RB0 project absorption, add locker assignment category to titlebar, layout setting

/* * * trans from Locker // 0303

- Unknown column 'user0_.department_id' in 'field list'

Caused: @ManyToOne(cascade= {CascadeType.ALL}) @JoinColumn(name="departmentId") <-- departmentId > department_id. Department department;

Solve 1: int departmentId; // err int departmentid; // suc

Solve: @ManyToOne(cascade= {CascadeType.ALL}) @JoinColumn(name="departmentid") <-- change Department department;

시벌 내가 이전프로젝트를 어케해놓은건지 문제없이 돌아가다가 옮겨서쓰니까 에러나네

나중에 통합하면될덧

지금할까

• • */

#2 그냥 모델에 로커 넣고 넘기니까 지알아서 채워지긴 하는데 그거에 맞춰서 수정하기 귀찮으니까 그냥 숨긴 인풋태그로 ㄱ

html/jsp layout

• center align: https://jhnyang.tistory.com/170

0305

• JSP user manual class
  • https://kmj1107.tistory.com/entry/jsp%EC%97%90%EC%84%9C-%EC%9E%90%EA%B8%B0%EA%B0%80-%EB%A7%8C%EB%93%A0-class-import-%ED%95%98%EA%B8%B0
• JSTL > JSP / JSP > JSTL
  • https://rwd337.tistory.com/41

0307

• JSP Error Solve
  • 개같이 페이지 양쪽에 공백생기던거
    • 이게 해답
    • ??

-- 0308 ~ 0312 Format

0312

• Git
  • 포맷하고 그냥 커밋했더니 외부유저커밋으로뜨네 시부럴
  • Global 설정하고 커밋.

0314

• html
  • table caption
  • https://www.codingfactory.net/11002

0327

• html/jsp
  • side navigation
  • https://webruden.tistory.com/94

0408

• html/jsp
  • user button http://rwdb.kr/interactionbutton/
  • before <button id=<%= C?"albtn":"lbtn" %> type="submit" name="lnum" value=<%= i100000+j1000+c %> <%= C?"disabled":"" %>><%= c++ %>

0424

• javaScript
  • var counter https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_html&wr_id=91173

0425

• git
  • 뭐지 레포바꾸면서 경로가 갈렸나
    • #1 관리자 페이지 생성/ 기존 페이지 레이아웃 변경/ 교재 리스트 레이아웃 변경/ 관리자 페이지 교재 등록 페이지 생성
    • #3 교재 대여 내부 알고리즘 변경-대여 가능 여부 판별/ 교재 목록 조회 알고리즘 변경-대여 가능 여부
    • #7 교재 정보 추가-교재 수, 대여 수/ 대여 가능 여부 판별
    • #9 등록 페이지/ 등록 알고리즘/ 등록 알림 | ?? 이슈 목록에서 9번 사라짐 뭐여

tqtq