본문 바로가기
728x90

전체 글

 (318)
mybatis oracle get sequence value 웹서핑해서 하라는대로 BEFORE, AFTER 다 해봐도 계속 1만 리턴됨. 버전 문제?? http://www.mybatis.org/mybatis-3/ko/sqlmap-xml.html#insert_update_and_delete 1. order="BEFORE" NEXTVAL useGeneratedKeys: 데이터베이스에서 내부적으로 생성한 키(MySQL, SQL Server와 같은 자동 증가 필드)를 받는 getGeneratedKeys 메소드를 사용하도록 설정. 오라클X select SEQ_MEMBER.NEXTVAL from dual INSERT INTO member ( mno, id, pw, name ) VALUES ( #{mno}, #{id}, #{pw}, #{name} ) INSERT INTO me..
Spring MVC Project - web.xml/servlet-context.xml web.xml contextConfigLocation /WEB-INF/spring/root-context.xml org.springframework.web.context.ContextLoaderListener appServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation /WEB-INF/spring/appServlet/servlet-context.xml 1 appServlet / servlet-context.xml
oracle CREATE TABLE MEMBER CREATE TABLE "PURPLIKE"."MEMBER" ("MNO" NUMBER NOT NULL ENABLE, "ID" VARCHAR2(50 BYTE) NOT NULL ENABLE, "PW" VARCHAR2(50 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE, "REGDATE" DATE DEFAULT SYSDATE NOT NULL ENABLE, CONSTRAINT "MEMBER_PK" PRIMARY KEY ("MNO") ) ; INSERT INTO member ( mno, id, pw, name ) VALUES ( SEQ_MEMBER.NEXTVAL, 'purplike', '1', '보라좋아' ); CREATE SEQUENCE SEQ_..
spring pom.xml 1 java-version: 1.6 > 1.8 1.6은 너무 낮은거 같아서 JDK 6+ for Spring Framework 4.x - https://spring.io/projects/spring-framework org.springframework-version: 3.1.1 > 4.3.19 GA https://spring.io/projects/spring-framework#learn 무난해보여서 버전4 commons-dbcp: 1.4 (JDK 6) Commons DBCP 이해하기 4.0.0 com.purplike member Member war 1.0.0-BUILD-SNAPSHOT 1.8 4.3.19.RELEASE 1.6.10 1.6.6 oracle Oracle JDBC Repository http://r..
1 eclipse New Spring MVC Project New > Project > Spring - Spring Legacy Project - Next Project name: MemberTemplates: Spring MVC ProjectNext packagecom.purplike.memberFinish
SyntaxHighliter v3 CDN (3.0.83) System.out.println("Hello World!"); System.out.println("Hello World!"); http://alexgorbatchev.com/SyntaxHighlighter/manual/brushes/ http://alexgorbatchev.com/SyntaxHighlighter/ https://cdnjs.com/libraries/SyntaxHighlighter CDN을 이용한 SyntaxHighlighter 적용 http://blackgoatdev.tistory.com/19
pom.xml 4.0.0 com.myc mya board war 1.0.0-BUILD-SNAPSHOT 1.6 3.1.1.RELEASE 1.6.10 1.6.6 org.springframework spring-context ${org.springframework-version} commons-logging commons-logging org.springframework spring-webmvc ${org.springframework-version} org.aspectj aspectjrt ${org.aspectj-version} org.slf4j slf4j-api ${org.slf4j-version} org.slf4j jcl-over-slf4j ${org.slf4j-version} runtime org.slf4j slf4j..
SyntaxHighlighter v4 SyntaxHighlighter v4https://github.com/syntaxhighlighter/syntaxhighlighter
728x90

티스토리툴바