Guest User

Untitled

a guest
Aug 19th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.65 KB | None | 0 0
  1. <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
  2. <property name="driverClass" value="com.mysql.cj.jdbc.Driver" />
  3. <property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />
  4. <property name="username" value="root" />
  5. <property name="password" value="dnehd#65" />
  6. </bean>
  7.  
  8.  
  9.  
  10. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  11. <property name="dataSource" ref="dataSource"></property>
  12. <property name="configLocation" value="classpath:/mybatis-config.xml"></property>
  13. </bean>
  14.  
  15. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  16. <property name="dataSource" ref="dataSource"></property>
  17. </bean>
  18.  
  19.  
  20.  
  21. <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  22. <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
  23. </bean>
  24.  
  25. <!DOCTYPE configuration
  26.  
  27. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  28.  
  29. "http://mybatis.org/dtd/mybatis-3-config.dtd">
  30.  
  31. <typeAliases>
  32.  
  33. <typeAlias type="com.myproject.model.User" alias="user" />
  34.  
  35. </typeAliases>
  36.  
  37. <mappers>
  38.  
  39. <mapper resource="com/myproject/mapper/user.xml" />
  40.  
  41. </mappers>
  42.  
  43. <?xml version="1.0" encoding="UTF-8"?>
  44.  
  45. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  46.  
  47. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  48.  
  49. <insert id="insertUser" parameterType="user">
  50. insert into web_users
  51. values(#{id}, #{password})
  52. </insert>
  53.  
  54. public class UserDao {
  55.  
  56. @Autowired
  57. private SqlSession session;
  58.  
  59.  
  60. public int insertUser(User user) {
  61. System.out.println("session : "+session);
  62. String key = "com.myproject.mapper.user.insertUser";
  63. Map<String, String> map = new HashMap<String, String>();
  64.  
  65. return session.insert(key, user);
  66. }
  67.  
  68. @RequestMapping(value = "/in", method = RequestMethod.GET)
  69. public String home1(Locale locale, Model model) {
  70. logger.info("Welcome home! The client locale is {}.", locale);
  71.  
  72. Date date = new Date();
  73. DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);
  74.  
  75. String formattedDate = dateFormat.format(date);
  76.  
  77. model.addAttribute("serverTime", formattedDate );
  78.  
  79. System.out.println("@@@@@@@@@@@@@@");
  80. UserDao dao = new UserDao();
  81. User user = new User();
  82. user.setId("idid");
  83. user.setPassword("pwpwpw");
  84.  
  85. int result = dao.insertUser(user);
  86. //System.out.println("Result " +result);
  87. return "home";
  88. }
  89.  
  90. java.lang.NullPointerException
  91. at com.myproject.dao.UserDao.insertUser(UserDao.java:23)
  92. at com.myproject.HomeController.home1(HomeController.java:61)
  93. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  94. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  95. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  96. at java.lang.reflect.Method.invoke(Method.java:498)
  97. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
  98. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
  99. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
  100. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
  101. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
  102. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  103. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
  104. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
  105. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
  106. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:866)
  107. at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  108. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
  109. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  110. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  111. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  112. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  113. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  114. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  115. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  116. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  117. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  118. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  119. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
  120. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  121. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
  122. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
  123. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
  124. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  125. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  126. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  127. at org.apache.tomcat.util.threads.TaskThrea
Add Comment
Please, Sign In to add comment