Tuesday, December 25, 2012

Dao with save method

 public Course CourseSave(Integer programmeId, String courseCode, String courseName, String creator, Date create_date) {
        s = sessionFactory.openSession();
        Transaction t = null;
        Programme pro = new Programme();
        UserList u = new UserList();
        try {
            t = s.beginTransaction();
            pro.setProgrammeId(programmeId);
            u.setEmailId(creator);
            Course CourseModel = new Course();
            CourseModel.setCourseCode(courseCode);
            CourseModel.setCourseName(courseName);
            CourseModel.setProgramme(pro);
            CourseModel.setCoursCreator(u);
            CourseModel.setCourceCreatorDate(create_date);
            s.save(CourseModel);
            t.commit();
            return CourseModel;
        } catch (Throwable ex) {
            //Log the Exception
            t.rollback();
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        } finally {
            s.close();
            sessionFactory.close();
        }
    }

Dao with Update method

public References ReferencesUpdate(long references_id, String user_id, String name, String designation, String org_univ, String place, String city, String state, String country, Long phoneno, Long mobileno, String email_id, String website) {
         s = sf.openSession();
        Transaction t = null;
        try {
            t = s.beginTransaction();
            References UpdateInfo = (References) s.load(References.class, references_id);
            UpdateInfo.setCity(city);
            UpdateInfo.setCountry(country);
            UpdateInfo.setDesignation(designation);
            UpdateInfo.setEmailId(email_id);
            UpdateInfo.setMobileno(mobileno);
            UpdateInfo.setName(name);
            UpdateInfo.setOrgUniv(org_univ);
            UpdateInfo.setPhoneno(phoneno);
            UpdateInfo.setPlace(place);
            UpdateInfo.setState(state);
            UpdateInfo.setWebsite(website);
            if (null != UpdateInfo) {
                s.update(UpdateInfo);
            }
            t.commit();
            return UpdateInfo;
        } catch (Throwable ex) {
            //Log the Exception
            t.rollback();
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        } finally {
            s.close();
            sf.close();
        }
    }

Dao delete example

@SuppressWarnings("unchecked")
    public AcademicDelete AcademicInformation(long academicInfoId) {
         s = sf.openSession();
        Transaction t = null;
        try {
            t = s.beginTransaction();

            Academic deleteInfo = (Academic) s.load(Academic.class, academicInfoId);
            if (deleteInfo != null) {
                s.delete(deleteInfo);
            }
            t.commit();
            return deleteInfo;
        } catch (Throwable ex) {
            //Log the Exception
            t.rollback();
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        } finally {
            s.close();
            sf.close();
        }
    }

DAo with list example

 @SuppressWarnings("unchecked")
    public List<Academic> ProfileAcademicListByUserId(String user_id) {
        s = sf.openSession();
        Transaction t = s.beginTransaction();

        List<Academic> academiclist = null;
        try {
            academiclist = s.createQuery("from Academic where user_id='" + user_id + "'").list();
        } catch (HibernateException HE) {
            System.out.println(HE);
        }
        t.commit();
        s.close();
        sf.close();
        return academiclist;
    }

Printing of div

function lprintf()
{
var DocumentContainer = document.getElementById('live');
var WindowObject = window.open('', 'PrintWindow','width=550,height=350,top=50,left=50,toolbars=no,scrollbars=yes,status=no,resizable=yes');
WindowObject.document.writeln(DocumentContainer.innerHTML);
WindowObject.document.close();
WindowObject.focus();
WindowObject.print();
WindowObject.close();
}

How to create a Word Document

just download the apache poi.jar


package org.IGNOU.ePortfolio.Action;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.xwpf.usermodel.Borders;
import org.apache.poi.xwpf.usermodel.ParagraphAlignment;
import org.apache.poi.xwpf.usermodel.VerticalAlign;
import org.apache.poi.xwpf.usermodel.XWPFDocument;
import org.apache.poi.xwpf.usermodel.XWPFParagraph;
import org.apache.poi.xwpf.usermodel.XWPFRun;

/**
 *
 * @author Amit
 */
public class CreateWordDoc {

     public static void main(String[] args) throws IOException {
        XWPFDocument document = new XWPFDocument();

        XWPFParagraph paragraphOne = document.createParagraph();
        paragraphOne.setAlignment(ParagraphAlignment.CENTER);
        paragraphOne.setBorderBottom(Borders.SINGLE);
        paragraphOne.setBorderTop(Borders.SINGLE);
        paragraphOne.setBorderRight(Borders.SINGLE);
        paragraphOne.setBorderLeft(Borders.SINGLE);
        paragraphOne.setBorderBetween(Borders.SINGLE);

        XWPFRun paragraphOneRunOne = paragraphOne.createRun();
        paragraphOneRunOne.setBold(true);
        paragraphOneRunOne.setItalic(true);
        paragraphOneRunOne.setText("Hello world! This is paragraph one!");
        paragraphOneRunOne.addBreak();

        XWPFRun paragraphOneRunTwo = paragraphOne.createRun();
        paragraphOneRunTwo.setText("Run two!");
        paragraphOneRunTwo.setTextPosition(100);

        XWPFRun paragraphOneRunThree = paragraphOne.createRun();
        paragraphOneRunThree.setStrike(true);
        paragraphOneRunThree.setFontSize(20);
        paragraphOneRunThree.setSubscript(VerticalAlign.SUBSCRIPT);
        paragraphOneRunThree.setText(" More text in paragraph one...");

        XWPFParagraph paragraphTwo = document.createParagraph();
        paragraphTwo.setAlignment(ParagraphAlignment.DISTRIBUTE);
        paragraphTwo.setIndentationRight(200);
        XWPFRun paragraphTwoRunOne = paragraphTwo.createRun();
        paragraphTwoRunOne.setText("And this is paragraph two.");

        FileOutputStream outStream = null;
        try {
            outStream = new FileOutputStream("C:/Users/Amit/Downloads/Amit.doc");
        } catch (FileNotFoundException e) {
        }

        try {
            document.write(outStream);
            outStream.close();
        } catch (FileNotFoundException e) {
        } catch (IOException e) {
        }
    }

}