Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void fullInfo() {
- MotorDao dao = new MotorDao();
- List<Motor> lc = dao.getMotorById(VNOPOL);
- System.out.println(lc.get(0).VNOPOL);
- this.VIDCUSTOMER = lc.get(0).VIDCUSTOMER;
- this.VFRAMENUM = lc.get(0).VFRAMENUM;
- this.VENGINENUM = lc.get(0).VENGINENUM;
- this.VTHNPROD = lc.get(0).VTHNPROD;
- this.NKMSERVICE = lc.get(0).NKMSERVICE;
- }
- public List<Motor> getMotorById(String motid) {
- System.out.println(motid);
- // Customer cust = null;
- Transaction trns = null;
- Session session = HibernateUtil.getSessionFactory().openSession();
- try {
- trns = session.beginTransaction();
- String queryString = "from Motor where VNOPOL = :id";
- Query query = session.createQuery(queryString);
- query.setString("id", motid);
- //cust = (Customer) query.uniqueResult();
- List<Motor> list = query.list();
- if (list.size() > 0) {
- return list;
- }
- } catch (RuntimeException e) {
- e.printStackTrace();
- } finally {
- session.flush();
- session.close();
- }
- return null;
- }
- <?xml version="1.0"?>
- <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <!-- Generated Jul 5, 2013 10:57:32 AM by Hibernate Tools 3.2.1.GA -->
- <hibernate-mapping>
- <class name="com.javaknowledge.entity.Motor" table="ahmdsmts_mstmotor" catalog="ahmids">
- <id name="VFRAMENUM" type="string">
- <column name="VVFRAMENUM" />
- </id>
- <property name="VENGINENUM" type="string">
- <column name="VENGINENUM" length="100" />
- </property>
- <property name="VNOPOL" type="string">
- <column name="VNOPOL" length="100" />
- </property>
- <property name="VTYPECODE" type="string">
- <column name="VTYPECODE" length="15" />
- </property>
- <property name="VCLRCODE" type="string">
- <column name="VCLRCODE" length="4"/>
- </property>
- <property name="VTHNPROD" type="java.lang.Integer">
- <column name="VTHNPROD" length="100" />
- </property>
- <property name="NKMSERVICE" type="java.lang.Integer">
- <column name="NKMSERVICE" length="100" />
- </property>
- <property name="VIDCUSTOMER" type="string">
- <column name="VIDCUSTOMER" length="4"/>
- </property>
- </class>
- </hibernate-mapping>
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
- <hibernate-configuration>
- <session-factory>
- <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
- <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
- <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ahmids?zeroDateTimeBehavior=convertToNull</property>
- <property name="hibernate.connection.username">root</property>
- <property name="hibernate.connection.password">ahmids</property>
- <mapping resource="com/javaknowledge/entity/Customer.hbm.xml"/>
- <mapping resource="com/javaknowledge/entity/TipeMotor.hbm.xml"/>
- <mapping resource="com/javaknowledge/entity/Service.hbm.xml"/>
- <mapping resource="com/javaknowledge/entity/Motor.hbm.xml"/>
- </session-factory>
- </hibernate-configuration>
- String queryString = "from ahmdsmts_mstmotor where VNOPOL = :id";
Add Comment
Please, Sign In to add comment