Skip to content

Instantly share code, notes, and snippets.

/dao.java method Secret

Created July 18, 2012 03:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/2e2560e7a04a769848a4 to your computer and use it in GitHub Desktop.
Save anonymous/2e2560e7a04a769848a4 to your computer and use it in GitHub Desktop.
prevent hibernate foreign key duplicates
public boolean addMember(M_member member)
{
Session session =HibernateUtil.getSessionFactory().openSession();
Transaction tx = null;
try
{
// SimpleDateFormat inFmt = new SimpleDateFormat("dd-MM-yyyy HH:mm:ss",new Locale("es", "ES"));
SimpleDateFormat inFmt1 = new SimpleDateFormat("dd-MM-yyyy",new Locale("es", "ES"));
SimpleDateFormat outFmt1 = new SimpleDateFormat("yyyy-MM-dd", new Locale("es", "ES"));
Date membershipdate=inFmt1.parse(member.getMembership_eff_date());
Date roledate=inFmt1.parse(member.getRole_eff_date());
// Date updateddate=inFmt1.parse(member.getUpdated_date_time());
System.out.println(" IN DAO Payment mode------"+member.getPayment_mode());
if(member.getPayment_mode().equals("Ch")||member.getPayment_mode().equals("DD")||member.getPayment_mode().equals("PO"))
{
Date ch_date=inFmt1.parse(member.getInstrument_date());
member.setInstrument_date(outFmt1.format(ch_date));
}
tx=session.beginTransaction();
Query qr1=session.createQuery("select m.devotee_id from M_member m");
List<M_member> l1=qr1.list();
for(M_member mi:l1)
{
if(!(l1.contains(member.getDevotee_id())))
{
member.setDevotee_id(member.getDevotee_id());
//System.out.println("print devotee id"+member.getDevotee_id());
}
}
////
// if(member.getDevotee_id()==)
member.setMembership_eff_date(outFmt1.format(membershipdate));
System.out.println(" IN DAO Membership eff date------"+member.getMembership_eff_date());
member.setRole_eff_date(outFmt1.format(roledate));
System.out.println(" IN DAO Role eff date------"+member.getRole_eff_date());
Query qry=session.createQuery("from M_member where membership_receipt_no=(select max(membership_receipt_no) from M_member)");
//Query qry=session.createQuery("select m.membership_receipt_no from M_member m, M_devotee d where membership_receipt_no=(select max(membership_receipt_no) from M_member)");
List<M_member> pl = qry.list();
int i=0;
for(M_member mp : pl)
{
i=Integer.parseInt(mp.getMembership_receipt_no());
i=i+1;
member.setMembership_receipt_no(String.valueOf(i));
}
if(member.getMembership_receipt_no()==null)
{
member.setMembership_receipt_no("1");
}
session.save(member);
tx.commit();
}
catch(Exception e)
{
if(tx!=null)
tx.rollback();
e.printStackTrace();
return false;
}
finally
{
session.close();
}
return true;
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.cmc.sibs.vo.M_devotee" table="m_devotee" dynamic-insert="true">
<id name="devotee_id" column="devotee_id" >
<generator class="native"/>
</id>
<!-- <property name="title">-->
<!-- <column name="title"/>-->
<!-- </property>-->
<many-to-one name="title" class="com.cmc.sibs.vo.M_title" column="title" cascade="none" >
</many-to-one>
<property name="first_name">
<column name="first_name"/>
</property>
<property name="middle_name">
<column name="middle_name"/>
</property>
<property name="last_name">
<column name="last_name"/>
</property>
<!-- <property name="rashi">-->
<!-- <column name="rashi"/>-->
<!-- </property> -->
<many-to-one name="rashi" class="com.cmc.sibs.vo.M_rashi" column="rashi" cascade="none" >
</many-to-one>
<property name="address1">
<column name="address1"/>
</property>
<property name="address2">
<column name="address2"/>
</property>
<property name="address3">
<column name="address3"/>
</property>
<!-- <property name="city">-->
<!-- <column name="city"/>-->
<!-- </property>-->
<many-to-one name="city" class="com.cmc.sibs.vo.M_city" column="city" cascade="none" not-null="true" >
</many-to-one>
<property name="pincode">
<column name="pincode"/>
</property>
<property name="mobile_no">
<column name="mobile_no"/>
</property>
<property name="email_id">
<column name="email_id"/>
</property>
<!-- <property name="state">-->
<!-- <column name="state"/>-->
<!-- </property> -->
<many-to-one name="state" class="com.cmc.sibs.vo.M_state" column="state" cascade="none" not-null="true" >
</many-to-one>
<!-- -->
<!-- <property name="nakshatra">-->
<!-- <column name="nakshatra"/>-->
<!-- </property> -->
<many-to-one name="nakshatra" class="com.cmc.sibs.vo.M_nakshatra" column="nakshatra" cascade="none" >
</many-to-one>
<property name="dob" >
<column name="dob"/>
</property>
<!-- <property name="created_by" >-->
<!-- <column name="created_by"/>-->
<!-- </property>-->
<many-to-one name="created_by" class="com.cmc.sibs.vo.M_users" column="created_by" cascade="none" >
</many-to-one>
<property name="created_date_time" >
<column name="created_date_time"/>
</property>
<property name="member_category" >
<column name="member_category"/>
</property>
<property name="gender" >
<column name="gender"/>
</property>
<property name="user_type" >
<column name="user_type"/>
</property>
<property name="stdcode" >
<column name="stdcode"/>
</property>
<property name="landline_no" >
<column name="landline_no"/>
</property>
<property name="committee_role" >
<column name="committee_role"/>
</property>
<!-- -->
<!-- <property name="country" >-->
<!-- <column name="country"/>-->
<!-- </property>-->
<many-to-one name="country" class="com.cmc.sibs.vo.M_country" column="country" cascade="none" not-null="true" >
</many-to-one>
<!-- -->
<!-- <property name="suburban" >-->
<!-- <column name="suburban"/>-->
<!-- </property>-->
<many-to-one name="suburban" class="com.cmc.sibs.vo.M_suburb" column="suburban" cascade="none" not-null="true" >
</many-to-one>
<property name="signatory_flag" >
<column name="signatory_flag"/>
</property>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.cmc.sibs.vo.M_member" table="m_member">
<id name="member_id" column="member_id" >
<generator class="native"/>
</id>
<many-to-one name="devotee_id" class="com.cmc.sibs.vo.M_devotee" column="devotee_id" unique="true" >
</many-to-one>
<property name="membership_type">
<column name="membership_type"/>
</property>
<property name="membership_eff_date">
<column name="membership_eff_date"/>
</property>
<property name="committee_role">
<column name="committee_role"/>
</property>
<property name="signatory_or_not">
<column name="signatory_or_not"/>
</property>
<property name="role_eff_date">
<column name="role_eff_date"/>
</property>
<many-to-one name="updated_by" class="com.cmc.sibs.vo.M_users" column="updated_by" >
</many-to-one>
<property name="updated_date_time">
<column name="updated_date_time"/>
</property>
<property name="active_status">
<column name="active_status"/>
</property>
<property name="payment_mode">
<column name="payment_mode"/>
</property>
<property name="membership_amount">
<column name="membership_amount"/>
</property>
<property name="instrument_no">
<column name="instrument_no"/>
</property>
<property name="instrument_date">
<column name="instrument_date"/>
</property>
<property name="bank_name">
<column name="bank_name"/>
</property>
<property name="bank_branch_location">
<column name="bank_branch_location"/>
</property>
<property name="membership_receipt_no">
<column name="membership_receipt_no"/>
</property>
</class>
</hibernate-mapping>
package com.cmc.sibs.vo;
public class M_devotee{
String devotee_id;
String first_name;
String middle_name;
String last_name;
M_title title;
String address1;
String address2;
String address3;
String pincode;
String mobile_no;
String email_id;
String dob;
M_users created_by;
String created_date_time;
String member_category;
String gender;
String user_type;
String stdcode;
String landline_no;
String committee_role;
String signatory_flag;
M_nakshatra nakshatra;
M_rashi rashi;
M_country country;
M_state state;
M_city city;
M_suburb suburban;
public String getAddress1() {
return address1;
}
public void setAddress1(String address1) {
this.address1 = address1;
}
public String getAddress2() {
return address2;
}
public void setAddress2(String address2) {
this.address2 = address2;
}
public String getAddress3() {
return address3;
}
public void setAddress3(String address3) {
this.address3 = address3;
}
public M_city getCity() {
return city;
}
public void setCity(M_city city) {
this.city = city;
}
public String getCommittee_role() {
return committee_role;
}
public void setCommittee_role(String committee_role) {
this.committee_role = committee_role;
}
public M_country getCountry() {
return country;
}
public void setCountry(M_country country) {
this.country = country;
}
public M_users getCreated_by() {
return created_by;
}
public void setCreated_by(M_users created_by) {
this.created_by = created_by;
}
public String getCreated_date_time() {
return created_date_time;
}
public void setCreated_date_time(String created_date_time) {
this.created_date_time = created_date_time;
}
public String getDevotee_id() {
return devotee_id;
}
public void setDevotee_id(String devotee_id) {
this.devotee_id = devotee_id;
}
public String getDob() {
return dob;
}
public void setDob(String dob) {
this.dob = dob;
}
public String getEmail_id() {
return email_id;
}
public void setEmail_id(String email_id) {
this.email_id = email_id;
}
public String getFirst_name() {
return first_name;
}
public void setFirst_name(String first_name) {
this.first_name = first_name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getLandline_no() {
return landline_no;
}
public void setLandline_no(String landline_no) {
this.landline_no = landline_no;
}
public String getLast_name() {
return last_name;
}
public void setLast_name(String last_name) {
this.last_name = last_name;
}
public String getMember_category() {
return member_category;
}
public void setMember_category(String member_category) {
this.member_category = member_category;
}
public String getMiddle_name() {
return middle_name;
}
public void setMiddle_name(String middle_name) {
this.middle_name = middle_name;
}
public String getMobile_no() {
return mobile_no;
}
public void setMobile_no(String mobile_no) {
this.mobile_no = mobile_no;
}
public M_nakshatra getNakshatra() {
return nakshatra;
}
public void setNakshatra(M_nakshatra nakshatra) {
this.nakshatra = nakshatra;
}
public String getPincode() {
return pincode;
}
public void setPincode(String pincode) {
this.pincode = pincode;
}
public M_rashi getRashi() {
return rashi;
}
public void setRashi(M_rashi rashi) {
this.rashi = rashi;
}
public String getSignatory_flag() {
return signatory_flag;
}
public void setSignatory_flag(String signatory_flag) {
this.signatory_flag = signatory_flag;
}
public M_state getState() {
return state;
}
public void setState(M_state state) {
this.state = state;
}
public String getStdcode() {
return stdcode;
}
public void setStdcode(String stdcode) {
this.stdcode = stdcode;
}
public M_suburb getSuburban() {
return suburban;
}
public void setSuburban(M_suburb suburban) {
this.suburban = suburban;
}
public M_title getTitle() {
return title;
}
public void setTitle(M_title title) {
this.title = title;
}
public String getUser_type() {
return user_type;
}
public void setUser_type(String user_type) {
this.user_type = user_type;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment