SPring面试要点

浅浅的花香味﹌ 2023-07-07 11:29 6阅读 0赞

#EmployeeMapper.xml
    
    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
      PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    <mapper namespace="com.atguigu.mybatis.mapper.EmployeeMapper">
    	
    	<select id="getEmployeeById" resultMap="myMap">
    		select * from employees where id = #{id}
    	</select>
    	
    	
        <resultMap type="com.atguigu.mybatis.entities.Employee" id="myMap">
        	
        	<id column="id" property="id"/>
        	
        	<result column="last_name" property="lastName"/>
        	<result column="email" property="email"/>
        	<result column="salary" property="salary"/>
        	<result column="dept_id" property="deptId"/>
        </resultMap>
    </mapper>
    
    
    
    #log4j.xml
    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
     
    <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
     
     <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
       <param name="Encoding" value="UTF-8" />
       <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />
       </layout>
     </appender>
     <logger name="java.sql">
       <level value="debug" />
     </logger>
     <logger name="org.apache.ibatis">
       <level value="info" />
     </logger>
     <root>
       <level value="debug" />
       <appender-ref ref="STDOUT" />
     </root>
    </log4j:configuration>
    
    
    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
    		 
    
    
    	<environments default="development">
    		<environment id="development">
    			<transactionManager type="JDBC" />
    			<dataSource type="POOLED">
    				<property name="driver" value="com.mysql.jdbc.Driver" />
    				<property name="url" value="jdbc:mysql://localhost:3306/springboot" />
    				<property name="username" value="root" />
    				<property name="password" value="123456" />
    			</dataSource>
    		</environment>
    	</environments>
    	
    	<mappers>
    		<mapper resource="EmployeeMapper.xml" />
    	</mappers>
    </configuration>
    
    
    2020-02-22突然间失业，找工作，目前在租的房子里面学习怎么样提高自己的奇数水平，要找工作了。好好学习，一些资料放在这儿。HashMap的手写版本，让你更能明白底层原理