SpringMVC+JPA
- PO
@Entity
@Table(name = "TABLE_NAME")
@SequenceGenerator(name = "SEQ_ALIAS_NAME",sequenceName =
"SEQ_Name",allocationSize = 1)
@Id
@Column(name = "COLUMN_NAME")
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "SEQ_ALIAS_NAME")
- DAO
//DAO
public interface DAO extends JpaRepository<PO,Serializable>,DAOCustom {
...
}
//DAO扩展接口
public interface DAOCustom {
...
}
//实现类
@Repository
public class DAOImpl implements DAOCustom {
@PersistenceContext(unitName = "fpsUnit")
protected EntityManager entityManager;
//insert delete update
public void updateInfo(){
String sql = "";
Query query = entityManager.createNativeQuery(sql);
query.executeUpdate();
}
//自定义sql+分页
public List<PO> getListBySQL(Integer start,Integer end){
return (new AbstractPagingQuery<TrackMoneyConfirmVO>(entityManager) {
@Override
public String getQuerySql() {
String sql = "";
return sql;
}
}).getData(start,end);
}
...
}
- Service
@Service
public class TrackMoneyConfirmService {
@Inject
private DAO DAO;
@Transactional(value = "transactionManagerName")
public void update(){
DAO.update()
}
}
- Controller
@controller
public class IndexController{
@Inject
private Service service;
//普通get请求
@RequestMapping(value="/URL",method = RequestMethod.GET)
public String toIndex(Model model,HttpServletReqest request){
return "index";
}
//post请求 返回json串
@RequestMapping(value = "/url",method= RequestMethod.POST,produces="text/html;charset=UTF-8")
@ResponseBody
public String returnJSON(){
return "JSON.......";
}
//从url获取参数
@RequestMapping(value = "/url/{argName0}/{argName1}")
public String downloadPDF(@PathVariable Long argName0, @PathVariable String argName1, HttpServletResponse response, ModelMap model) {
}
- 从properties文件中取值
@Value("${propertyName}")
private Long xxx;
配置文件在下篇博客中贴出来