/** * 查找学生的课程 * 没有加上学生类型 * */ public boolean findStdCourseByScId(int uid, int cid) {
// String sql = "select * from 7east_usercourse_right where userid=? and courseid=? and type=1"; String sql = "select * from 7east_usercourse_right where userid=? and courseid=?"; UserCourseMapper argTypes =new UserCourseMapper();
Object[] args = new Object[] { uid, cid }; List<UserCourse> list = getJdbcTemplate().query(sql, args, argTypes );
@Data public class UserCourse implements Serializable { private static final long serialVersionUID = 1L;
private int endtime;
@EmbeddedId private UserCourseRightPK id;
private int lessonnumber;
private int listentimes;
private int starttime;
private int totallessonnumber;
public UserCourse() { }
@Data public class UserCourseRightPK implements Serializable { //default serial version id, required for serializable classes. private static final long serialVersionUID = 1L;
public void setEndCity(String endCity) { this.endCity = endCity; }
@Override public int hashCode() { final int PRIME = 31; int result = 1; result = PRIME * result + ((endCity == null) ? 0 : endCity.hashCode()); result = PRIME * result + ((staCity == null) ? 0 : staCity.hashCode()); return result; }
@Override public boolean equals(Object obj) { if (this == obj) return true; if (obj == null) return false; if (getClass() != obj.getClass()) return false; final AirLinePK other = (AirLinePK) obj; if (endCity == null) { if (other.endCity != null) return false; } else if (!endCity.equals(other.endCity)) return false; if (staCity == null) { if (other.staCity != null) return false; } else if (!staCity.equals(other.staCity)) return false; return true; }
}
@Entity @Table(name = "AIRLINE") public class AirLineEntity {
private AirLinePK a_id;
private String a_name;
// 联合主键 @EmbeddedId public AirLinePK getA_id() { return a_id; }
public void setA_id(AirLinePK a_id) { this.a_id = a_id; }
@Column(length = 50) public String getA_name() { return a_name; }
public void setA_name(String a_name) { this.a_name = a_name; }
}
public class CompositePKTest { @Test public void save(){ EntityManagerFactory factory = Persistence.createEntityManagerFactory("mengya"); EntityManager em = factory.createEntityManager(); em.getTransaction().begin();
AirLineEntity airLine = new AirLineEntity(); airLine.setA_id(new AirLinePK("BeJing","ShangHai")); airLine.setA_name("北京至上海");
[code="java"]/** * 查找学生的课程 * 没有加上学生类型 * */ public boolean findStdCourseByScId(int uid, int cid) {// String sql = "select * from 7east_usercourse_right where userid=? and cour...