环境:
- IDEA
- MySQL 5.7.19
- Tomcat 9
- Maven 3.6
要求:
需要熟练掌握MySQL数据库,Spring,JavaWeb及MyBatis知识,简单的前端知识;
pojo层:
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Combos {
//号码查询
public int registernumberID;//号码ID
public String registernumber;//号码
public String paymentamount;//支付总价
}
dao层:
import com.liang.pojo.*;
import org.apache.ibatis.annotations.Param;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public interface ComboMapper {
List<Combos> queryAllCombo();
//查询所有号码数据
List<Combos>selectUserList();
/**
* 分页操作,调用findByPage limit分页方法
* @param map
* @return
*/
List<Combos> findByPage(HashMap<String,Object> map);
}
dao Mapper层:
<select id="queryAllCombo" resultType="Combos">
select * from chinamobile.p_sim
</select>
<!--查询所有用户数据 -->
<select id="selectUserList" resultType="com.liang.pojo.Combos">
select
<include refid="Base_Column_List" />
from p_regi