spring boot wip

1 files changed, 4 insertions, 5 deletions

diff --git a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
index 2073c3c0..ee9d0baa 100644
--- a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
+++ b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
@@ -23,8 +23,8 @@ import org.springframework.beans.factory.annotation.Value;
 import org.springframework.context.annotation.Bean;
 import org.springframework.context.annotation.ComponentScan;
 import org.springframework.context.annotation.Configuration;
-import org.springframework.context.annotation.PropertySource;
 import org.springframework.context.support.PropertySourcesPlaceholderConfigurer;
+import org.springframework.dao.DuplicateKeyException;
 import org.springframework.jdbc.core.JdbcTemplate;
 import org.springframework.jdbc.datasource.DataSourceTransactionManager;
 import org.springframework.transaction.PlatformTransactionManager;
@@ -40,7 +40,6 @@ import java.util.List;
  */
 @Configuration
 @EnableTransactionManagement
-@PropertySource(value = {"classpath:juick.conf"}, ignoreResourceNotFound = true)
 @ComponentScan(basePackages = {"com.juick.service"})
 public class DataConfiguration implements TransactionManagementConfigurer {
     @Value("${datasource_driver:org.h2.Driver}")
@@ -246,18 +245,18 @@ public class DataConfiguration implements TransactionManagementConfigurer {
                     "  `cnt` smallint(5) unsigned NOT NULL DEFAULT '0'," +
                     "  PRIMARY KEY (`user_id`)" +
                     ")");
-            jdbcTemplate.execute("CREATE TABLE `auth` (" +
+            jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS `auth` (" +
                     "  `user_id` int(10) unsigned NOT NULL," +
                     "  `protocol` enum('xmpp','email','sms') NOT NULL," +
                     "  `account` char(64) NOT NULL," +
                     "  `authcode` char(8) NOT NULL" +
                     ")");
-            jdbcTemplate.execute("CREATE TABLE `mail` (" +
+            jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS `mail` (" +
                     "  `user_id` int(10) unsigned NOT NULL," +
                     "  `hash` char(16) NOT NULL," +
                     "  PRIMARY KEY (`user_id`)" +
                     ")");
-            jdbcTemplate.execute("CREATE TABLE `usersinfo` (" +
+            jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS `usersinfo` (" +
                     "  `user_id` int(10) unsigned NOT NULL," +
                     "  `jid` char(32) DEFAULT NULL," +
                     "  `fullname` char(32) DEFAULT NULL," +