-
-
Save anonymous/2e2560e7a04a769848a4 to your computer and use it in GitHub Desktop.
prevent hibernate foreign key duplicates
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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