技能训练
SSM轻量级框架p161页:
1,查询出所有供应商数据
2,按照供应商名称模糊查询供应商信息
SSM轻量级框架p165页:
3, 实现订单表查询操作
创建java-web项目
1,加载所需要的jar包
2,在src下面编写代码
编写实体类对象:provider
package com.aaa.entity;
/**
* @author :jinxin
* @date :Created in 2020/10/13 13:47
* @version: $
*/
public class Provider {
private int id;
private String proCode;
private String proName;
private String proDesc;
private String proContact;
private String ProPhone;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getProCode() {
return proCode;
}
public void setProCode(String proCode) {
this.proCode = proCode;
}
public String getProName() {
return proName;
}
public void setProName(String proName) {
this.proName = proName;
}
public String getProDesc() {
return proDesc;
}
public void setProDesc(String proDesc) {
this.proDesc = proDesc;
}
public String getProContact() {
return proContact;
}
public void setProContact(String proContact) {
this.proContact = proContact;
}
public String getProPhone() {
return ProPhone;
}
public void setProPhone(String proPhone) {
ProPhone = proPhone;
}
}
编写dao接口:
package com.aaa.dao;
import com.aaa.entity.Provider;
import java.util.List;
public interface ProviderDao {
//查询出所有供应商数据
public List<Provider> listAll();
//按照供应商名称模糊查询供应商信息
public List<Provider> findByProName(String ProName);
}
编写dao实现类
package com.aaa.dao;
import com.aaa.entity.Provider;
import org.mybatis.spring.SqlSessionTemplate;
import java.util.List;
/**
* @author :jinxin
* @date :Created in 2020/10/13 13:50
* @version: $
*/
public class ProviderDaoImpl implements ProviderDao {
priv