一、mybatis注解
1.@Alias(“User”)
-
加在实体类的注解,给实体类取别名
-
实体类注解:要使用注解,必须进行包扫描
package com.liuyue.pojo;
import org.apache.ibatis.type.Alias;
// 实体类注解:要使用注解,必须进行包扫描
@Alias("User")
public class User {
private int id;
private String name;
private String pwd;
public User() {
}
public User(int id, String name, String pwd) {
this.id = id;
this.name = name;
this.pwd = pwd;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", pwd='" + pwd + '\'' +
'}';
}
}
2.@Select(“select * from user”)
-
加在UserMapper上的注解,省略sql代码.
-
同类型的其他注解:@Update、@Insert等类似
package com.liuyue.dao;
import com.liuyue.pojo.User;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface UserMapper {
@Select("select * from user")
List<User> getUsers();
}
3.@Param(“参数名”)注解
- 基本类型的参数或者String类型,需要加上
- 引用类型不需要加
- 如果只有一个基本类型的话,可以忽略,但是建议大家都加上
- 我们在sql中引用的就是我们这里的 @Param(“id”) 中设定的属性名!
// 方法存在多个参数,所有的参数前面必须加上 @Param("参数名")注解
@Select("select * from user where id = #{id} and name = #{name}")
User getUserById(@Param("id") int id, @Param("name") String name);
二、spring注解
1.@Autowired —> Bean自动装配
xml配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
https://www.springframework.org/schema/beans/spring-beans.xsd">
<bean id="cat" class="com.liuyue.pojo.Cat" />
<bean id="dog" class="com.liuyue.pojo.Dog" />
<!--手动装配-->
<bean id="people" class="com.liuyue.pojo.People">
<property name="name" value="六月" />
<property name="cat" ref="cat" />
<property name="dog" ref="dog" />
</bean>
<!--
autowire:Bean自动装配
byName:会自动在容器上下文中查找,和自己对象 set 方法括号里的值对应的 beanId
byType:会自动在容器上下文中查找,和自己对象属性类型相同的bean
-->
<bean id="people1" class="com.liuyue.pojo.People" autowire="byName">
<property name="name" value="demo" />
</bean>
</beans>
直接使用在属性上即可
package com.liuyue.pojo;
import org.springframework.beans.factory.annotation.Autowired;
public class People {
/*
* @Autowired(required = false)
* 如果显式定义了AutoWired的required属性为false,说明这个对象可以为null,否则不允许为null
* */
@Autowired
private Cat cat;
@Autowired
private Dog dog;
private String name;
public Cat getCat() {
return cat;
}
public void setCat(Cat cat) {
this.cat = cat;
}
public Dog getDog() {
return dog;
}
public void setDog(Dog dog) {
this.dog = dog;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "People{" +
"cat=" + cat +
", dog=" + dog +
", name='" + name + '\'' +
'}';
}
}
2.@Qualifier(value = “xxx”)
- 如果使用@Autowired自动装配的环境比较复杂,自动装配无法通过一个注解【@Autowired】完成的时候,我们可以使用@Qualifier(value = “xxx”)去配置@Autowired的使用,指定一个唯一的bean对象注入!
xml配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd">
<context:annotation-config/>
<bean id="cat1" class="com.liuyue.pojo.Cat">
<property name="name" value="cat1" />
</bean>
<bean id="cat2" class="com.liuyue.pojo.Cat">
<property name="name" value="cat2" />
</bean>
<bean id="cat3" class="com.liuyue.pojo.Cat">
<property name="name" value="cat3" />
</bean>
<bean id="dog1" class="com.liuyue.pojo.Dog">
<property name="name" value="dog1" />
</bean>
<bean id="dog2" class="com.liuyue.pojo.Dog">
<property name="name" value="dog2" />
</bean><bean id="dog3" class="com.liuyue.pojo.Dog">
<property name="name" value="dog3" />
</bean>
<bean id="people" class="com.liuyue.pojo.People">
<property name="name" value="六月" />
</bean>
</beans>
实体类
package com.liuyue.pojo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
public class People {
private String name;
/*
* @Autowired(required = false)
* 如果显式定义了AutoWired的required属性为false,说明这个对象可以为null,否则不允许为null
* */
@Autowired
@Qualifier(value = "cat1")
private Cat cat1;
@Autowired
@Qualifier(value = "cat2")
private Cat cat2;
@Autowired
@Qualifier(value = "cat3")
private Cat cat3;
@Autowired
@Qualifier(value = "dog1")
private Dog dog1;
@Autowired
@Qualifier(value = "dog2")
private Dog dog2;
@Autowired
@Qualifier(value = "dog3")
private Dog dog3;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Cat getCat1() {
return cat1;
}
public void setCat1(Cat cat1) {
this.cat1 = cat1;
}
public Cat getCat2() {
return cat2;
}
public void setCat2(Cat cat2) {
this.cat2 = cat2;
}
public Cat getCat3() {
return cat3;
}
public void setCat3(Cat cat3) {
this.cat3 = cat3;
}
public Dog getDog1() {
return dog1;
}
public void setDog1(Dog dog1) {
this.dog1 = dog1;
}
public Dog getDog2() {
return dog2;
}
public void setDog2(Dog dog2) {
this.dog2 = dog2;
}
public Dog getDog3() {
return dog3;
}
public void setDog3(Dog dog3) {
this.dog3 = dog3;
}
@Override
public String toString() {
return "People{" +
"name='" + name + '\'' +
", cat1=" + cat1 +
", cat2=" + cat2 +
", cat3=" + cat3 +
", dog1=" + dog1 +
", dog2=" + dog2 +
", dog3=" + dog3 +
'}';
}
}
3.@Resource(name = xxx)
@Resource和@Autowired的区别:
- 都是用来自动装配的,都可以放在属性字段上
- @Autowired默认通过byType的方式实现,如果存在多个同类型的对象,则根据buName装配。而且必须要求这个对象存在
- @Resource默认通过byName的方式实现,如果找不到名字,则通过byType实现。
xml配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
https://www.springframework.org/schema/context/spring-aop.xsd">
<context:annotation-config/>
<bean id="cat1" class="com.liuyue.pojo.Cat">
<property name="name" value="cat1" />
</bean>
<bean id="cat2" class="com.liuyue.pojo.Cat">
<property name="name" value="cat2" />
</bean>
<bean id="cat3" class="com.liuyue.pojo.Cat">
<property name="name" value="cat3" />
</bean>
<bean id="dog1" class="com.liuyue.pojo.Dog">
<property name="name" value="dog1" />
</bean>
<bean id="dog2" class="com.liuyue.pojo.Dog">
<property name="name" value="dog2" />
</bean><bean id="dog3" class="com.liuyue.pojo.Dog">
<property name="name" value="dog3" />
</bean>
<bean id="people" class="com.liuyue.pojo.People">
<property name="name" value="六月" />
</bean>
</beans>
实体类
package com.liuyue.pojo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import javax.annotation.Resource;
public class People {
private String name;
/*
* @Autowired(required = false)
* 如果显式定义了AutoWired的required属性为false,说明这个对象可以为null,否则不允许为null
* */
@Resource(name = "cat1")
private Cat cat1;
@Resource(name = "cat2")
private Cat cat2;
@Resource(name = "cat3")
private Cat cat3;
@Resource(name = "dog1")
private Dog dog1;
@Resource(name = "dog2")
private Dog dog2;
@Resource(name = "dog3")
private Dog dog3;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Cat getCat1() {
return cat1;
}
public void setCat1(Cat cat1) {
this.cat1 = cat1;
}
public Cat getCat2() {
return cat2;
}
public void setCat2(Cat cat2) {
this.cat2 = cat2;
}
public Cat getCat3() {
return cat3;
}
public void setCat3(Cat cat3) {
this.cat3 = cat3;
}
public Dog getDog1() {
return dog1;
}
public void setDog1(Dog dog1) {
this.dog1 = dog1;
}
public Dog getDog2() {
return dog2;
}
public void setDog2(Dog dog2) {
this.dog2 = dog2;
}
public Dog getDog3() {
return dog3;
}
public void setDog3(Dog dog3) {
this.dog3 = dog3;
}
@Override
public String toString() {
return "People{" +
"name='" + name + '\'' +
", cat1=" + cat1 +
", cat2=" + cat2 +
", cat3=" + cat3 +
", dog1=" + dog1 +
", dog2=" + dog2 +
", dog3=" + dog3 +
'}';
}
}