Guest User

Untitled

a guest
Feb 4th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.58 KB | None | 0 0
  1. public void fullInfo() {
  2. MotorDao dao = new MotorDao();
  3. List<Motor> lc = dao.getMotorById(VNOPOL);
  4. System.out.println(lc.get(0).VNOPOL);
  5. this.VIDCUSTOMER = lc.get(0).VIDCUSTOMER;
  6. this.VFRAMENUM = lc.get(0).VFRAMENUM;
  7. this.VENGINENUM = lc.get(0).VENGINENUM;
  8. this.VTHNPROD = lc.get(0).VTHNPROD;
  9. this.NKMSERVICE = lc.get(0).NKMSERVICE;
  10.  
  11. }
  12.  
  13. public List<Motor> getMotorById(String motid) {
  14. System.out.println(motid);
  15. // Customer cust = null;
  16. Transaction trns = null;
  17. Session session = HibernateUtil.getSessionFactory().openSession();
  18. try {
  19. trns = session.beginTransaction();
  20. String queryString = "from Motor where VNOPOL = :id";
  21. Query query = session.createQuery(queryString);
  22. query.setString("id", motid);
  23. //cust = (Customer) query.uniqueResult();
  24. List<Motor> list = query.list();
  25. if (list.size() > 0) {
  26. return list;
  27. }
  28. } catch (RuntimeException e) {
  29. e.printStackTrace();
  30. } finally {
  31. session.flush();
  32. session.close();
  33. }
  34. return null;
  35. }
  36.  
  37. <?xml version="1.0"?>
  38. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
  39. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  40. <!-- Generated Jul 5, 2013 10:57:32 AM by Hibernate Tools 3.2.1.GA -->
  41. <hibernate-mapping>
  42. <class name="com.javaknowledge.entity.Motor" table="ahmdsmts_mstmotor" catalog="ahmids">
  43. <id name="VFRAMENUM" type="string">
  44. <column name="VVFRAMENUM" />
  45.  
  46. </id>
  47. <property name="VENGINENUM" type="string">
  48. <column name="VENGINENUM" length="100" />
  49. </property>
  50. <property name="VNOPOL" type="string">
  51. <column name="VNOPOL" length="100" />
  52. </property>
  53. <property name="VTYPECODE" type="string">
  54. <column name="VTYPECODE" length="15" />
  55. </property>
  56. <property name="VCLRCODE" type="string">
  57. <column name="VCLRCODE" length="4"/>
  58. </property>
  59. <property name="VTHNPROD" type="java.lang.Integer">
  60. <column name="VTHNPROD" length="100" />
  61. </property>
  62. <property name="NKMSERVICE" type="java.lang.Integer">
  63. <column name="NKMSERVICE" length="100" />
  64. </property>
  65. <property name="VIDCUSTOMER" type="string">
  66. <column name="VIDCUSTOMER" length="4"/>
  67. </property>
  68. </class>
  69. </hibernate-mapping>
  70.  
  71. <?xml version="1.0" encoding="UTF-8"?>
  72. <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  73. <hibernate-configuration>
  74. <session-factory>
  75. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  76. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  77. <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ahmids?zeroDateTimeBehavior=convertToNull</property>
  78. <property name="hibernate.connection.username">root</property>
  79. <property name="hibernate.connection.password">ahmids</property>
  80. <mapping resource="com/javaknowledge/entity/Customer.hbm.xml"/>
  81. <mapping resource="com/javaknowledge/entity/TipeMotor.hbm.xml"/>
  82. <mapping resource="com/javaknowledge/entity/Service.hbm.xml"/>
  83. <mapping resource="com/javaknowledge/entity/Motor.hbm.xml"/>
  84. </session-factory>
  85. </hibernate-configuration>
  86.  
  87. String queryString = "from ahmdsmts_mstmotor where VNOPOL = :id";
Add Comment
Please, Sign In to add comment