1.在Dao层和service中:
//添加主表
int addpa(String pType,String pName,String pUnit,int pNum,String pPerson);
//添加从表
int adda();
2.Dao层的实现方法
//添加主表
public int shen(int pId, String date) {
Connection conn = helper.getConnection();
try {
PreparedStatement ps = conn.prepareStatement("update tbl_pur_approval set paDate=?, paState=? where pId=?");
ps.setString(1, date);
ps.setString(2, "已审批");
ps.setInt(3, pId);
int i = ps.executeUpdate();
return i;
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
注意
新添加数据的PId是最大的(select max(pId) from tbl_purchase) 外键
insert into tbl_pur_approval values((select max(pId) from tbl_purchase),0,null,default)
添加从表
public int adda() {
Connection conn = helper.getConnection();
try {
//添加从表 有外键 新添加数据的PId是最大的(select max(pId) from tbl_purchase) 外键
PreparedStatement ps = conn.