DB TABLE 공유

[shk3029]

CREATE TABLE TBL_BOARD( BNO INT NOT NULL auto_increment, TITLE VARCHAR(200) NOT NULL, CONTENT TEXT NULL, WRITER VARCHAR(50) NOT NULL, REGDATE TIMESTAMP NOT NULL DEFAULT NOW(), VIEWCNT INT default 0, primary key(BNO) );

CREATE TABLE TBL_MEMBER( USER_ID varchar(50) NOT NULL, USER_PW VARCHAR(50) NOT NULL, USER_NAME varchar(50) NOT NULL, USER_EMAIL VARCHAR(200) NULL, USER_REGDATE TIMESTAMP NOT NULL default NOW(), USER_UPDATEDATE TIMESTAMP NOT NULL default NOW(), primary KEY(USER_ID) );

mysql

[shk3029]

application-context.xml DB설정

<!-- JDBC 연결을 처리하는 기능을 가진 DataSource -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="url" 
            value="jdbc:mysql://127.0.0.1:3306/book_ex?useSSL=false"></property>
    <property name="username" value="js"></property>
    <property name="password" value="js"></property>
</bean>

각자 DB에 맞게 설정하면됨