SHARE MY TRICKS

Export to file writer using java

2011-02-05T12:40:00.000-08:00

export data to file using java
simple java programe to export to filewriter
how to export to filewriter using java source code
/**
* @author JohnJustin
www.johnjustin.tk
*
*/


public class ExportFileWriter{
 
 int intPageNumber = 0;
 java.sql.ResultSet rsExportResult = null;
 ResultSetBuilder resultBuilder = ResultSetBuilderFactory.getInstance();
 
 POIExcelWriter poiExcelWriter = null;
 TextWriter textWriter = null;

 ExportBuilder exportBuilder = null;
 
 private int intRowIndex = 0;

 public ExportFileWriter(ExportBuilder exportBuilder, TextWriter textWriter){
  this.textWriter = textWriter;
  this.exportBuilder = exportBuilder;
 }

 public ExportFileWriter(ExportBuilder exportBuilder, POIExcelWriter poiExcelWriter){
  this.exportBuilder = exportBuilder;
  this.poiExcelWriter = poiExcelWriter;
 }

 /*
 * @Method : setTextWriter
 * @param1 : TextWriter
 * sets the text writer
 */
 public void setTextWriter(TextWriter textWriter){
  this.textWriter = textWriter;
 }
 
 /*
 * @Method : setPOIExcelWriter
 * @param1 : POIExcelWriter poiExcelWriter
 * sets the poi excel writer
 */
 public void setPOIExcelWriter(POIExcelWriter poiExcelWriter){
  this.poiExcelWriter = poiExcelWriter;
 }
 
 /*
 * @Method : setExportBuilder
 * @param1 : ExportBuilder exportBuilder
 * sets the ExportBuilder instance
 */
 public void setExportBuilder(ExportBuilder exportBuilder){
  this.exportBuilder = exportBuilder;
 }
 
 /*
 * @Method : writeToTextFile
 * @param : no param
 * write the contents to the text file.
 */
 public boolean writeToTextFile(){
  java.io.BufferedWriter bufferedWriter = new java.io.BufferedWriter(textWriter);
  try{
   int numberOfColumns = 0;
   /*if paging is enabled, we are getting the current page and querying the page counted.*/
   if(exportBuilder.isPagingEnabled()){
    int intCurrentPage = resultBuilder.getCurrentPage();
    if(intCurrentPage != -1) rsExportResult = resultBuilder.getResultSet(rsExportResult, intCurrentPage);
   }else{
    rsExportResult = resultBuilder.getResultSet(rsExportResult);
   }

   if(rsExportResult != null){

    /*determining the fields to be printed as header and getting the number of columns and printing the header.*/
    String strHeader[] = null;
    if(exportBuilder.getHeader() != null) strHeader = exportBuilder.getHeader();
    if(strHeader == null && exportBuilder.getExportFields() != null) strHeader = exportBuilder.getExportFields();
    
    if(exportBuilder.getExportFields() == null || exportBuilder.getFieldPosition() == null){
     java.sql.ResultSetMetaData rsMetaData = rsExportResult.getMetaData();
     numberOfColumns = rsMetaData.getColumnCount();
     if(strHeader == null){
      strHeader = new String[numberOfColumns];
      for(int index=0; index<numberOfColumns; index++){
       strHeader[index] = rsMetaData.getColumnName(index + 1);
      }
     }
    }
    if(exportBuilder.getExportFields() != null){
     numberOfColumns = exportBuilder.getExportFields().length;     
    }else if(exportBuilder.getFieldPosition() != null){
     numberOfColumns = exportBuilder.getFieldPosition().length;
    }
    for(int index=0; index<strHeader.length; index++){
     if(index == 0){
      bufferedWriter.write(strHeader[index]);
     }else{
      bufferedWriter.write(exportBuilder.getDelimiter() + strHeader[index]);
     }
    }
    bufferedWriter.write("\r\n");
    strHeader = null;
    /*end of determining the fields to be printed as header and getting the number of columns and printing the header*/
    /*writing the header */    
    
    if(exportBuilder.isPagingEnabled()){
     int intCurrentPage = 0;
     do{
      writeResultSetToTextFile(rsExportResult, bufferedWriter, numberOfColumns);
      if(rsExportResult != null) rsExportResult.close();
      intCurrentPage = resultBuilder.getCurrentPage();
      if(intCurrentPage == -1) break;
      rsExportResult = resultBuilder.getResultSet(rsExportResult, intCurrentPage);
     }while(rsExportResult != null);
    }else{
     writeResultSetToTextFile(rsExportResult, bufferedWriter, numberOfColumns);
     if(rsExportResult != null) rsExportResult.close();
    }
   }
  }catch(Exception e){
   System.out.println("Error in writeToTextFile() ------ " + e);
  }
  try{
   if(bufferedWriter != null) bufferedWriter.close();
  }catch(Exception ee){
  }
  return(true);
 }
 
 public boolean writeToExcelFile(){
  try{
   int numberOfColumns = 0;   
   /*if paging is enabled, we are getting the current page and querying the page counted.*/
   if(exportBuilder.isPagingEnabled()){
    int intCurrentPage = resultBuilder.getCurrentPage();
    if(intCurrentPage != -1) rsExportResult = resultBuilder.getResultSet(rsExportResult, intCurrentPage);
   }else{
    rsExportResult = resultBuilder.getResultSet(rsExportResult);
   }

   if(rsExportResult != null){    
    poiExcelWriter.resetSheetIndex();
    poiExcelWriter.setSheet();
    
    /*determining the fields to be printed as header and getting the number of columns and printing the header.*/
    String[] strHeader = null;
    if(exportBuilder.getHeader() != null) strHeader = exportBuilder.getHeader();
    if(strHeader == null && exportBuilder.getExportFields() != null) strHeader = exportBuilder.getExportFields();
    
    if(exportBuilder.getExportFields() == null || exportBuilder.getFieldPosition() == null){
     java.sql.ResultSetMetaData rsMetaData = rsExportResult.getMetaData();
     numberOfColumns = rsMetaData.getColumnCount();
     if(strHeader == null){
      strHeader = new String[numberOfColumns];
      for(int index=0; index<numberOfColumns; index++){
       strHeader[index] = rsMetaData.getColumnName(index + 1);
      }
     }
    }
    if(exportBuilder.getExportFields() != null){
     numberOfColumns = exportBuilder.getExportFields().length;     
    }else if(exportBuilder.getFieldPosition() != null){
     numberOfColumns = exportBuilder.getFieldPosition().length;
    }

    poiExcelWriter.insertRow(intRowIndex);
    for(int index=0; index<strHeader.length; index++){
     poiExcelWriter.writeData(index, intRowIndex, strHeader[index]);
    }
    strHeader = null;
    intRowIndex++;
    /*end of determining the fields to be printed as header and getting the number of columns and printing the header*/
    /*writing the header */    

    /*writing the data*/
    if(exportBuilder.isPagingEnabled()){
     int intCurrentPage = 0;
     do{
      writeResultSetToExcelFile(rsExportResult, numberOfColumns);
      if(rsExportResult != null) rsExportResult.close();
      intCurrentPage = resultBuilder.getCurrentPage();
      if(intCurrentPage == -1) break;
      rsExportResult = resultBuilder.getResultSet(rsExportResult, intCurrentPage);
     }while(rsExportResult != null);
    }else{
     writeResultSetToExcelFile(rsExportResult, numberOfColumns);
     if(rsExportResult != null) rsExportResult.close();
    }
   }
  }catch(Exception e){
   System.out.println("Error in writeToExcelFile() ------ " + e);
  }
  try{
   if(poiExcelWriter != null) poiExcelWriter.closeExcel();
  }catch(Exception ee){
  }
  return(true);
 }

 private void writeResultSetToTextFile(java.sql.ResultSet rsExportResult, java.io.BufferedWriter bufferedWriter, int numberOfColumns){
  try{
   while(rsExportResult.next()){
    if(numberOfColumns != 0){
     for(int intFieldPostion = 0; intFieldPostion < numberOfColumns; intFieldPostion++){
      if(exportBuilder.getExportFields() != null){
       if(intFieldPostion == 0){
        bufferedWriter.write(rsExportResult.getString(exportBuilder.getExportFields()[intFieldPostion]));
       }else{
        bufferedWriter.write(exportBuilder.getDelimiter() + rsExportResult.getString(exportBuilder.getExportFields()[intFieldPostion]));
       }
      }else if(exportBuilder.getFieldPosition() != null){
       if(intFieldPostion == 0){
        bufferedWriter.write(rsExportResult.getString(exportBuilder.getFieldPosition()[intFieldPostion]));
       }else{
        bufferedWriter.write(exportBuilder.getDelimiter() + rsExportResult.getString(exportBuilder.getFieldPosition()[intFieldPostion]));
       }
      }else{
       if(intFieldPostion == 0){
        bufferedWriter.write(rsExportResult.getString(intFieldPostion + 1));
       }else{
        bufferedWriter.write(exportBuilder.getDelimiter() + rsExportResult.getString(intFieldPostion + 1));
       }
      }
     }
     bufferedWriter.write("\r\n");
    }
   }
  }catch(Exception e){
   System.out.println("Error in writeResultSetToTextFile() --------- " + e);
  }
 }

 private void writeResultSetToExcelFile(java.sql.ResultSet rsExportResult, int numberOfColumns){
  try{
   while(rsExportResult.next()){
    if(intRowIndex != 0 && (intRowIndex % 65536) == 0){
     poiExcelWriter.setSheet();
     intRowIndex = 0;
    }
    poiExcelWriter.insertRow(intRowIndex);
    if(numberOfColumns != 0){
     for(int intFieldPostion = 0; intFieldPostion < numberOfColumns; intFieldPostion++){
      if(exportBuilder.getExportFields() != null){       
       poiExcelWriter.writeData(intFieldPostion, intRowIndex, rsExportResult.getString(exportBuilder.getExportFields()[intFieldPostion]));
      }else if(exportBuilder.getFieldPosition() != null){
       poiExcelWriter.writeData(intFieldPostion, intRowIndex, rsExportResult.getString(exportBuilder.getFieldPosition()[intFieldPostion]));
      }else{       
       poiExcelWriter.writeData(intFieldPostion, intRowIndex, rsExportResult.getString(intFieldPostion + 1));       
      }
     }
     intRowIndex++;
    }
   }
  }catch(Exception e){
   System.out.println("Error in writeResultSetToExcelFile() --------- " + e);
  }
 }
}

Export to excel using java and poi

2011-02-05T12:25:00.000-08:00

simple Java program to export a data to excel file using apache poi.
with the help of these below java program you can easily export
your data from database to excel file with the help of below java source code
/**
* @author JohnJustin
www.johnjustin.tk
*
*/


import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.*;
import org.apache.poi.poifs.filesystem.*;
import java.io.*;

public class  POIExcelWriter{ 
 private POIFSFileSystem poiStream = null;
 private HSSFWorkbook document = null;
 private HSSFSheet sheet = null;
 private HSSFRow excelRow = null;
 private HSSFCell cell = null; 
 private HSSFCellStyle style = null;
 private HSSFFont font = null;

 String strExcelFile = "";
 int intSheetIndex = 0;
 
 public POIExcelWriter(){}

 public POIExcelWriter(String strExcelFile){
  openExcelFile(strExcelFile);
 }

 public boolean openExcelFile(String strExcelFile){
  try{
   this.strExcelFile = strExcelFile;
   document = new HSSFWorkbook();
   java.io.FileOutputStream fileOut = new java.io.FileOutputStream(strExcelFile);
   document.write(fileOut);
   fileOut.close();

   poiStream = new POIFSFileSystem(new FileInputStream(strExcelFile));
   document = new HSSFWorkbook(poiStream);
   return(true);
  }catch(Exception e){
   System.out.println(e);
  }
  return(false);
 }

 public boolean openExcelFile(String strExcelFile, boolean blnFlag){
  try{
   this.strExcelFile = strExcelFile;
   poiStream = new POIFSFileSystem(new FileInputStream(strExcelFile));
   document = new HSSFWorkbook(poiStream);
   return(true);
  }catch(Exception e){
   System.out.println(e);
  }
  return(false);
 }
 
 /* @Method : resetSheetIndex
 * @Param : no param
 * @Description : Method will reset the global index variable with 0
 */
 public void resetSheetIndex(){
  intSheetIndex = 0;
 }

 /* @Method : setSheet
 * @Param : no param
 * @Description : Method will try to get the sheet at specified index. If the sheet is nulll
 *      will try to create new sheet.
 */
 public void setSheet(){
  try{
   sheet = document.getSheetAt(intSheetIndex);
   if(sheet == null){
    sheet = document.createSheet();
   }
  }catch(Exception e){
   sheet = document.createSheet();
  }
  intSheetIndex++;
  System.out.println("intSheetIndex >> " + intSheetIndex + " sheet >> " + sheet);
 }
 
 /* @Method : insertRow
 * @Param : rowindex
 * @Description : Method will insert new row if the row does not exists.
 */
 public void insertRow(int row){
  if(sheet != null){
   if(sheet.getRow(row) != null) excelRow = sheet.getRow(row);
   else excelRow = sheet.createRow(row);
  }
 }

 /* @Method : insertRow
 * @Param : rowindex
 * @Description : Method will insert new row if the row does not exists.
 */
 public void insertRow(short row){
  if(sheet != null){
   if(sheet.getRow(row) != null) excelRow = sheet.getRow(row);
   else excelRow = sheet.createRow(row);
  }
 }

 /* @Method : insertRow
 * @Param : rowindex
 * @Description : Method will insert new row if the row does not exists.
 */
 public void insertRow(int row, boolean blnAppend){
  if(sheet != null){
   excelRow = sheet.createRow((short)row);
  }
 }
 
 /* @Method : writeData
 * @Param1 : col
 * @Param2 : row
 * @Param3 : data
 * @Description : Method will write float data in specified row and column.
 */
 public void writeData(int col, int row, Object data){
  excelRow = sheet.getRow(row);
  cell = excelRow.createCell(col);
  if(data instanceof Boolean) {
   cell.setCellType(HSSFCell.CELL_TYPE_BOOLEAN);
   cell.setCellValue(Boolean.getBoolean(data.toString()));
  } else if(data instanceof String) {
   cell.setCellType(HSSFCell.CELL_TYPE_STRING);
   cell.setCellValue(new HSSFRichTextString(data.toString()));
  } else if(data instanceof Integer) {
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(Double.parseDouble(data.toString()));
  } else if(data instanceof Double) {
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(Double.parseDouble(data.toString()));
  } else if(data instanceof Float) {
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(Float.parseFloat(data.toString()));
  } else if(data instanceof Long) {
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(Long.parseLong(data.toString()));
  }
 }
  
 /* @Method : fillColor
 * @Param1 : sindex
 * @Param2 : startcol
 * @Param3 : endcol
 * @Param4 : row
 * @Description : Method will fill the color in specified row and column.
 */ 
 public void fillColor(short sindex, int row, int startcol, int endcol){
  try{
   excelRow = sheet.getRow(row);
   style = document.createCellStyle();
   
   style.setFillForegroundColor(sindex);
   style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
   for(int index=startcol; index <= endcol; index++){
    cell = excelRow.getCell(index);
    if(cell == null) cell = excelRow.createCell(index);
    cell.setCellStyle(style);
   }
  }catch(Exception e){
   System.out.println("Error in fillColor () --- " + e);
  }
 }
 
 public void fillColor(short sindex, int row, int startcol, int endcol, int red, int green, int blue) {
  //creating a custom palette for the workbook
     HSSFPalette palette = document.getCustomPalette();

     //replacing the standard red with freebsd.org red
     palette.setColorAtIndex(sindex, (byte) red, (byte) green, (byte) blue);
     excelRow = sheet.getRow(row);
  style = document.createCellStyle();
  
  style.setFillForegroundColor(sindex);
  style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
  for(int index=startcol; index <= endcol; index++){
   cell = excelRow.getCell(index);
   if(cell == null) cell = excelRow.createCell(index);
   cell.setCellStyle(style);
  }
 }
 
 public void setBorder(int row, int startCol, int endCol, boolean left, boolean top, boolean right, boolean bottom) {
  excelRow = sheet.getRow(row);
  for(int index = startCol; index <= endCol; index++) {
   cell = excelRow.getCell(index);
   if(cell == null) cell = excelRow.createCell(index);
   
   HSSFCellStyle cellStyle = cell.getCellStyle();
   
   if(left) cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
   if(top) cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
   if(right) cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
   if(bottom) cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
   
   cell.setCellStyle(cellStyle);
  }
 }
 
 public void setBorder(int row, int col, boolean left, boolean top, boolean right, boolean bottom) {
  excelRow = sheet.getRow(row);
  cell = excelRow.getCell(col);
  if(cell == null) cell = excelRow.createCell(col);
  
  HSSFCellStyle cellStyle = cell.getCellStyle();
  
  if(left) cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
  if(top) cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
  if(right) cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
  if(bottom) cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
  
  cell.setCellStyle(cellStyle);
  
 } 
 /* @Method : merge
 * @Param : firstRow, lastRow, firstCol, lastCol
 * @Description : Merges the selected rows/columns to one
 */ 
 public void merge(int firstRow, int lastRow, int firstCol, int lastCol) {
  sheet.addMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
 }
 
 /* @Method : setColumnWidth
 * @Param : col, width
 * @Description: Sets the column width
 */
 public void setColumnWidth(int col, int width) {
  sheet.setColumnWidth(col, width);
 }
 /* @Method : closeExcel
 * @Param : no param
 * @Description : Method will write the contents to excel file and closes the stream.
 */
 public void closeExcel(){
  try{
   // Rewrite the spreadsheet to the File System 
   FileOutputStream modSpreadsheet = new FileOutputStream(strExcelFile);
   document.write(modSpreadsheet);
   modSpreadsheet.close();
  }catch(Exception e){
  }
 }
 
 /*deprecated functions*/
 
 /* @Method : writeData
 * @Param1 : col
 * @Param2 : row
 * @Param3 : data
 * @Description : Method will write String data in specified row and column.
 */
 /**
  * @deprecated
  */
 public void writeData(int col, int row, String data){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);   
   cell.setCellType( HSSFCell.CELL_TYPE_STRING);
   cell.setCellValue(new HSSFRichTextString(data));
  }catch(Exception e){
   System.out.println("Error in writeData (String) --- " + e);
  }
 }
 
 /* @Method : writeData
 * @Param1 : col
 * @Param2 : row
 * @Param3 : data
 * @Description : Method will write integer data in specified row and column.
 */
 /**
  * @deprecated
  */
 public void writeData(int col, int row, int data){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);      
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(data);
  }catch(Exception e){
   System.out.println("Error in writeData (int) --- " + e);
  }
 }

 /* @Method : writeData
 * @Param1 : col
 * @Param2 : row
 * @Param3 : data
 * @Description : Method will write float data in specified row and column.
 */
 /**
  * @deprecated
  */
 public void writeData(int col, int row, float data){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);      
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(data);
  }catch(Exception e){
   System.out.println("Error in writeData (float) --- " + e);
  }
 }
 

 /* @Method : writeData
 * @Param1 : col
 * @Param2 : row
 * @Param3 : data
 * @Param4 : format
 * @Description : Method will write float data in specified row and column.
 */
 /**
  * @deprecated
  */
 public void writeData(int col, int row, float data, String strFormat){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);      
   cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
   cell.setCellValue(data);
   style = document.createCellStyle();
   style.setDataFormat(document.createDataFormat().getFormat(strFormat));
   cell.setCellStyle(style);
  }catch(Exception e){
   System.out.println("Error in writeData (float) + format --- " + e);
  }
 }
 
 /* @Method : fillColor
 * @Param1 : startcol
 * @Param2 : endcol
 * @Param3 : row
 * @Description : Method will fill the color in specified row and column.
 */
 /**
  * @deprecated
  */
 public void fillColor(int startcol, int endcol, int row){
  try{
   excelRow = sheet.getRow(row);
   style = document.createCellStyle();
   style.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index);
   style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
   for(int index=startcol; index <= endcol; index++){
    cell = excelRow.createCell(index);
    cell.setCellStyle(style);
   }
  }catch(Exception e){
   System.out.println("Error in fillColor () --- " + e);
  }
 }
 
 /* @Method : setCellFormula
 * @Param1 : col
 * @Param2 : row
 * @Param3 : strFormula
 * @Description : Method will set the formula
 */
 /**
  * @deprecated
  */
 public void setCellFormula(int col, int row, String strFormula){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);      
   cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
   cell.setCellFormula(strFormula);
   style = document.createCellStyle();
   style.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index);
   style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
   font = document.createFont();
   font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            style.setFont(font);
   cell.setCellStyle(style);
  }catch(Exception e){
   System.out.println("Error in fillColor () --- " + e);
  }
 }

 /* @Method : setCellFormula
 * @Param1 : col
 * @Param2 : row
 * @Param3 : strFormula
 * @Description : Method will set the formula
 */
 /**
  * @deprecated
  */
 public void setCellFormula(int col, int row, String strFormula, String strFormat){
  try{
   excelRow = sheet.getRow(row);
   cell = excelRow.createCell(col);      
   cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
   cell.setCellFormula(strFormula);
   style = document.createCellStyle();
   style.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index);
   style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
   style.setDataFormat(document.createDataFormat().getFormat(strFormat));
   font = document.createFont();
   font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            style.setFont(font);
   cell.setCellStyle(style);
  }catch(Exception e){
   System.out.println("Error in fillColor () --- " + e);
  }
 }
 
}

SIMPLE JAVA PROGRAME TO CONVERT A PNG FILE TO JPEG FORMAT

2011-02-05T12:12:00.000-08:00

java Programe for converting png file to jpeg file format

simple java program for converting png file format to png file format
/**
* @author JohnJustin
www.johnjustin.tk
*
*/


import java.awt.Graphics2D;
import java.awt.RenderingHints;
import java.awt.image.BufferedImage;
import java.awt.image.RenderedImage;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.Vector;

import javax.imageio.ImageIO;

public class PNGtoJPG{
 public static void main(String[] args) 
 {
  try{
  File infile = new File("file1.png");
  File outfile = new File("file54.jpg");
  BufferedImage img = ImageIO.read(infile);
  Graphics2D g = img.createGraphics();
  

  g.setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING, RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
  g.setRenderingHint(RenderingHints.KEY_ANTIALIASING, RenderingHints.VALUE_ANTIALIAS_ON);
  g.setRenderingHint(RenderingHints.KEY_RENDERING, RenderingHints.VALUE_RENDER_QUALITY);
  
  ImageIO.write(img, "jpg", outfile);
  }catch(Exception e){
   System.out.println(e);
  }
 }
}

HOW TO CONVERT A PDF FILE TO PNG FORMAT USING JAVA PROGRAM

2011-02-05T12:07:00.000-08:00

this program is very much useful to convert a pdf file to png format using java
you can use this java program for converting pdf files to png file format.
free download and use this programe. java using pdf convertion to png file format
/**
* @author JohnJustin
www.johnjustin.tk
*
*/


import java.awt.Graphics2D;
import java.awt.RenderingHints;
import java.awt.image.BufferedImage;
import java.awt.image.RenderedImage;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.Vector;

import javax.imageio.ImageIO;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletResponse;

import com.sun.media.jai.codec.ImageCodec;   

import com.sun.media.jai.codec.ImageDecoder;
import com.sun.media.jai.codec.ImageEncoder;
import com.sun.media.jai.codec.PNGEncodeParam;
import com.sun.media.jai.codec.SeekableStream;
import com.sun.media.jai.codec.TIFFDecodeParam;
import com.sun.media.jai.codec.TIFFDirectory;

import multivalent.Behavior;
import multivalent.Context;
import multivalent.Document;
import multivalent.Node;
import multivalent.std.adaptor.pdf.PDF;

public class PDFToPNG extends HttpServlet {

/**
*
*/
private static final long serialVersionUID = 1L;

public byte[] ConvertToPngImage(byte[] tiffRawData, HttpServletResponse res)
throws Exception {
Vector pngs = new Vector();
// set stream to the tiff url
SeekableStream tiffStream = SeekableStream.wrapInputStream(
new ByteArrayInputStream(tiffRawData), true);

// how many pages in one tiff
int pageNumber = TIFFDirectory.getNumDirectories(tiffStream);

TIFFDecodeParam decodeParam = new TIFFDecodeParam();
decodeParam.setDecodePaletteAsShorts(true);

ImageDecoder tiffDecoder = ImageCodec.createImageDecoder("tiff",
tiffStream, decodeParam);

// for (int p = 0; p < pageNumber; p ++) {
// render the current page
RenderedImage tiffPage = tiffDecoder.decodeAsRenderedImage();

PNGEncodeParam png = PNGEncodeParam.getDefaultEncodeParam(tiffPage);

// The png stream is outputted to a file. Change the directory
// accordingly.
ByteArrayOutputStream baos = new ByteArrayOutputStream();

// Gets a PNG encoder.
ImageEncoder pngEncoder = ImageCodec.createImageEncoder("PNG", baos,png);

// Encodes the RenderedImage object.
pngEncoder.encode(tiffPage);

byte[] content = baos.toByteArray();
baos.close();
return content;
}

public static void main(String args[]) {
File outfile = new File("c:\\file.png");

try {

PDF pdf = (PDF) Behavior.getInstance("AdobePDF", "AdobePDF", null,
null, null);
File file = new File("c:\\somepdf.pdf");
pdf.setInput(file);

Document doc = new Document("doc", null, null);
pdf.parse(doc);
doc.clear();

doc.putAttr(Document.ATTR_PAGE, Integer.toString(1));
pdf.parse(doc);

Node top = doc.childAt(0);
doc.formatBeforeAfter(200, 200, null);
int w = top.bbox.width;
int h = top.bbox.height;
BufferedImage img = new BufferedImage(w, h,
BufferedImage.TYPE_INT_RGB);
Graphics2D g = img.createGraphics();
g.setClip(0, 0, w, h);

g.setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING,
RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
g.setRenderingHint(RenderingHints.KEY_ANTIALIASING,
RenderingHints.VALUE_ANTIALIAS_ON);
g.setRenderingHint(RenderingHints.KEY_RENDERING,
RenderingHints.VALUE_RENDER_QUALITY);
Context cx = doc.getStyleSheet().getContext(g, null);
top.paintBeforeAfter(g.getClipBounds(), cx);

ImageIO.write(img, "png", outfile);
doc.removeAllChildren();
cx.reset();
g.dispose();

pdf.getReader().close();
outfile = null;

doc = null;
} catch (Exception e) {

}
}
}

how to resize an image using java

2011-02-05T10:34:00.000-08:00

resize jpeg image using java source code
resize bmp,jpg images using java program

/**
* @author JohnJustin
www.johnjustin.tk
*
*/


package ImageResizing;
import java.awt.Graphics2D;
import java.awt.RenderingHints;

import java.awt.AlphaComposite;
import java.awt.image.BufferedImage;
import java.awt.image.RenderedImage;
import java.awt.image.PixelGrabber;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.Vector;

import javax.imageio.ImageIO;

public class ImageResize{

/*public static BufferedImage theOriginalImage = null;
public static BufferedImage theNewImage = null;
public static int theOriginalImageWidth = 0,theOriginalImageHeight = 0;
public static int theNewImageWidth = 0, theNewImageHeight = 0;*/

public static boolean stretched = false;

public static void setStretched()
{
  stretched = true;  
}

public static boolean resizeImage(String source_file,String dest_file,int width,int height)
{
 boolean blnSuccess = false;
 File infile = null;
 File outfile = null;
 BufferedImage originalImage = null;
 BufferedImage theNewImage = null;
 int theOriginalImageWidth = 0, theOriginalImageHeight = 0;
 int theNewImageWidth = 0, theNewImageHeight = 0;

 try{
  infile = new File(source_file);
  outfile = new File(dest_file);
  originalImage = ImageIO.read(infile);
  theOriginalImageWidth = originalImage.getWidth();
  theOriginalImageHeight = originalImage.getHeight(); 
  System.out.println("Height >> " + theOriginalImageWidth + " Width >> " + theOriginalImageHeight);
  theNewImageWidth = width;
  //theNewImageHeight = height;
  if(theOriginalImageWidth < theNewImageWidth || theOriginalImageHeight < theNewImageHeight){
   setStretched();
  }
  theNewImageHeight = (theOriginalImageHeight*theNewImageWidth)/theOriginalImageWidth;
  System.out.println("The New Image Width >> " + theNewImageWidth + " The New Image Height >> " + theNewImageHeight);
  theNewImage = new BufferedImage(theNewImageWidth,theNewImageHeight,BufferedImage.TYPE_INT_RGB);
  Graphics2D loGraphics = theNewImage.createGraphics(); 
  loGraphics.setComposite(AlphaComposite.Src); 
  loGraphics.setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING,RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
  loGraphics.setRenderingHint(RenderingHints.KEY_ANTIALIASING,RenderingHints.VALUE_ANTIALIAS_ON);
  loGraphics.setRenderingHint(RenderingHints.KEY_INTERPOLATION,RenderingHints.VALUE_INTERPOLATION_BILINEAR);
  loGraphics.drawImage(originalImage,0,0,theNewImageWidth,theNewImageHeight,null);
  loGraphics.dispose();
  ImageIO.write(theNewImage,"jpg",outfile);  
  blnSuccess = true;
 }catch(Exception e){
  System.out.println("Error While Executing resizeImage function >> " + e.getMessage());
  return(blnSuccess);
 }

 return(blnSuccess);
}

public static void main(String args[])
{
 ImageResize resize = new ImageResize();
 String source_file = "E:\\john\\img.jpg";
 String dest_file = "E:\\john\\imgresize.jpg";
 int width = 300;
 int height = 300;
 boolean flag = resize.resizeImage(source_file,dest_file,width,height);
 if(flag){
  System.out.println("Resized " + source_file + " to " + dest_file);
 }
 if(stretched){
  System.out.println("The Image Resized Will be in Stretched Format");
 }
}

}

what is inverse="true " in hibernate ?

2010-06-30T22:27:00.000-07:00

Inverse defines which side is responsible of the association maintenance. The side having inverse="false" (default value) has this responsibility (and will create the appropriate SQL query - insert, update or delete). Changes made to the association on the side of the inverse="true" are not persisted in DB.

Inverse attribute is not related in any way to the navigation through relationship. It is related to the way hibernate generate SQL queries to update association data. Association data are:

a column in the one-to-many association
a row in the association table in a many-to-many association
Monodirectional association is managed by the only side available through navigation. When association is bidirectional, choosing the manager side allow better SQL optimization, this is the recommended behaviour
Here is an easy way to understanding it:

example scenario:
Person(one) <-> Address(many)
* bi-directional one-to-many relationship. (A person has multiple addresses.)

public class Person {
  private Integer id;
  private Set<Address> addresses;

  // setter, getter
  Set<Address> getAddresses() { return addresses; }
  ....
}

public class Address {
  private Integer id;
  private Person person;

  // setter, getter
  Person getPerson() { return person; }
  .....
}

• Person class has "Set

getAddresses()" method
• Address class has "Person getPerson()" method
Let's look at table structure instead of classes.
• PERSON[ id, name, ...]
• ADDRESS[ id, person_id, city, street,...]

The person_id column in Address table is the relational information between thease two tables.
So, Address is an owner of the relationship, and Person is the inverse side.
"inverse=true" means "this side is the inverse side", and "inverse=false" means "this is not the inverse side. this side is the owner of the relationship".


<class name="Person">
  <id name="id">...</id>
  <set name="addresses" inverse="true">
    <key column="person_id"/>
    <one-to-many class="Address"/>
  </set>
</class>


<class name="Address">
  <id name="id">...</id>
  <many-to-one name="person" class="Person" />
</class>

In sum, look at the table structure to distinguish "inverse=true" or "inverse=false".
If the table has relational information, then it is the owner side. So, it's not inverse side.(inverse=false)
If the table doesn't have relational information, then it is the inverse side. So, it needs "inverse=true".
In Hibernate, only the relationship owner should maintain the relationship, and the “inverse” keyword is created to defines which side is the owner to maintain the relationship. However the “inverse” keyword itself is not verbose enough, I would suggest change the keyword to “relationship_owner”. The inverse=”true” means this is the relationship owner, whereas inverse=”false” (default) means it’s not.

marquee

2010-06-30T04:42:00.000-07:00

marquee is a text level element. By default marquee has a WIDTH of 100%, so it might appear as a block level. However, if you set the width to something smaller than 100%, you might notice that the marquee is in line with the surrounding text


<MARQUEE WIDTH="20%">
Hi There! 
<IMG SRC="graphics/idocs.gif" 
HEIGHT=33 WIDTH=82 ALT="Idocs Guide to HTML">
</MARQUEE>

difference between and merge and update in hibernate ?

2010-06-25T05:12:00.000-07:00

Use update() if you are sure that the session does not contain an already persistent instance with the same identifier, and merge() if you want to merge your modifications at any time without consideration of the state of the session.

how to do watermarking on images using java and jsp

2010-06-24T21:21:00.000-07:00

watermarking on jep using jsp or java free source code of java watermarking on images(bmp,jpeg,png)

dear friends we can make watermarking on images or logos using java .this code is useful for somebody want to write their logo or their company name on their images published on their website.this watermarking code is free and you can use this code for education purpose only. this watermarking code can be applied on jsp also.

/**
* @author John.J
www.johnjustin.tk
*
*/

 

import java.awt.AlphaComposite;
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.Image;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileOutputStream;
import java.util.Random;

import javax.imageio.ImageIO;
import javax.swing.ImageIcon;

import com.sun.image.codec.jpeg.JPEGCodec;
import com.sun.image.codec.jpeg.JPEGEncodeParam;
import com.sun.image.codec.jpeg.JPEGImageEncoder;

public class Watermark
{
public static void main(String[] args)
{
try
{
Font font;
File _file = new File("C:/car.jpg");
Image src = ImageIO.read(_file);
int width = src.getWidth(null);
int height = src.getHeight(null);
System.out.println("X = "+width+" and Y = "+height);
BufferedImage image = new BufferedImage(width, height
, BufferedImage.TYPE_INT_RGB);
Graphics g = image.createGraphics();
g.drawImage(src, 0, 0, width, height, null);
//    g.setBackground(Color.white);
g.setColor(Color.red);
g.setFont(new Font("Verdana", Font.BOLD, 20));

g.drawString("www.johnjustin.tk",  5, height - (new
Font("Arial", Font.BOLD, 20)).getSize() / 2 - 5);
g.dispose();

FileOutputStream out = new FileOutputStream("C:/car2.jpg");
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out);
encoder.encode(image);
out.close();
} catch (Exception ee)
{
System.out.println("Error Occurred : "+ee);
}
}
}

how to use this code?
copy the input image to here car.jpg in your hard disk here iam copying car.jpg in c drive
write your watermarking inside
g.drawString("www.johnjustin.tk", 5, height - (new Font("Arial", Font.BOLD, 20)).getSize() / 2 - 5);

you can specify the color and font size inside the g.drawstring method

the image before water marking using java is below

after adding watermark see the given figure below

how to compile and running java program using bat file and crone tab scheduler

2010-06-09T21:51:00.000-07:00

for compile and running a bat file in command prompt open command prompt cd C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\fi_sh\WEB-INF\classes then

step 1: set java home as below
set JAVA_HOME="C:\Program Files\Java\jdk1.5.0"

step 2: compile the jar files and java file as below

%JAVA_HOME%\bin\javac -classpath ../lib/company.jar;../lib/company_db.jar;../lib/project7.jar;../lib/mysql-connector-java-5.1.6-bin.jar;../lib/activation.jar;../lib/mail.jar;../lib/log4j-1.2.15.jar;../lib/smtp.jar;../lib/pop3.jar;. com/company/project/user/ChangePasswordAlert.java

step 3: for running the compiled file as below

%JAVA_HOME%\bin\java -classpath ../lib/company.jar;../lib/company_db.jar;../lib/project7.jar;../lib/mysql-connector-java-5.1.6-bin.jar;../lib/activation.jar;../lib/mail.jar;../lib/log4j-1.2.15.jar;../lib/smtp.jar;../lib/pop3.jar;. com.company.project.user.ChangePasswordAlert "en"

OR CREATE A BAT FILE AND COPY THE BELOW CONTENT IN IT AND CALL THE BAT FILE IN COMMAND PROMPT

set JAVA_HOME="C:\Program Files\Java\jdk1.5.0"

%JAVA_HOME%\bin\java -classpath ../lib/company.jar;../lib/company_db.jar;../lib/project7.jar;../lib/mysql-connector-java-5.1.6-bin.jar;../lib/activation.jar;../lib/mail.jar;../lib/log4j-1.2.15.jar;../lib/smtp.jar;../lib/pop3.jar;. com.company.project.user.ChangePasswordAlert "en"

online banking application project in php mysql

2010-06-05T23:50:00.000-07:00

A Simple Banking System in PHP

I am new one to PHP, This is first program in PHP...

Description
-----------
This works like a network banking system which purely developed in PHP.

Login Details
-------------
Admin
-----
ID : Admin
Password : admin

How it Works
----------
After login into Admin, the Administrator have rights to create a new Manager and clerk
The Manager have right create a new User Account
The Clerk have rights to deposit and withdraw
The User can view only the Transaction details

All the manager,clerk,user and administrator use same sign in form.(index.php)

The Account Number and Login Id are generated from the table 'accountno'. Here you can initialize the starting ID.

How to Run
----------
I developed this project under xampp-linux-1.6.7 version downloaded from
http://www.apachefriends.org/en/xampp-linux.html

If your using above product, just
Copy the Project Folder(Bank) in htdocs folder
Copy the Database Folder(bankdb) in var/mysql folder

If my database is supported to ur mysql server means, u can create the database what are required to run that can be described in the file bankdb.html

Then u can run the project
http://localhost/Bank

The File db.php contains the details of Database connection, U can change the mysql username and password here only
Database Name : bankdb
user name : root
password : vaithe

ldap in simple jsp login application

2010-06-05T23:40:00.000-07:00

hai today we r discussing login activity through ldap
The Lightweight Directory Access Protocol, or LDAP (pronounced /ˈɛldæp/), is an application protocol for querying and modifying data using directory services running over TCP/IP.[1]

A directory is a set of objects with attributes organized in a logical and hierarchical manner. A simple example is the telephone directory, which consists of a list of names (of either persons or organizations) organized alphabetically, with each name having an address and phone number associated with it.

An LDAP directory tree often reflects various political, geographic, and/or organizational boundaries, depending on the model chosen. LDAP deployments today tend to use Domain Name System (DNS) names for structuring the topmost levels of the hierarchy. Deeper inside the directory might appear entries representing people, organizational units, printers, documents, groups of people or anything else that represents a given tree entry (or multiple entries).

CONFIGURE ECLIPSE TO CREATE STRUTS2 PROJECT

2010-05-22T03:14:00.000-07:00

HOW TO CREATE STRUTS2 PROJECTS IN ECLIPSE GANYMADE

    IDE NEEDED :ECLIPSE GANYMADE 3.2
JDK : jdk 1.5 above (download)

      SERVER : Tomcat 5.x above (download)
      Apache Struts2 JAR files:(download)
      commons-logging-1.0.4.jar
      freemarker-2.3.8.jar
      ognl-2.6.11.jar
      struts2-core-2.0.12.jar
      xwork-2.0.6.jar

STRUTS2 COMPLETE TUTORIAL SERIES PART1

2010-05-22T03:03:00.000-07:00

TUTORIAL PART 1 : INTRODUCTION TO STRUTS2

Apache Struts2 was originally known as WebWork 2. After working independently for several years, the WebWork and Struts communities joined forces to create Struts2. This new version of Struts is simpler to use and closer to how Struts was always meant to be.

Struts 2 is a pull-MVC framework. i.e. the data that is to be displayed to user has to be pulled from the Action.

Struts2 supports annotation based configurations which are easy to create and more intuitive. Action class in Struts 2 act as the model in the web application. Unlike Struts, Struts 2 Action class are plain POJO objects thus simplifying the testing of the code. Struts2 also comes with power APIs to configure Interceptors that reduce greatly the coupling in application. The view part of Struts 2 is highly configurable and it supports different result-types such as Velocity, FreeMarker, JSP

The normal lifecycle of struts begins when the request is sent from client. This results invoke the servlet container which in turn is passed through standard filter chain.

The FilterDispatcher filter is called which consults the ActionMapper to determine whether an Action should be invoked.

If ActionMapper finds an Action to be invoked, the FilterDispatcher delegates control to ActionProxy.

ActionProxy reads the configuration file such as struts.xml. ActionProxy creates an instance of ActionInvocation class and delegates the control.

ActionInvocation is responsible for command pattern implementation. It invokes the Interceptors one by one (if required) and then invoke the Action.

Once the Action returns, the ActionInvocation is responsible for looking up the proper result associated with the Action result code mapped in struts.xml.

The Interceptors are executed again in reverse order and the response is returned to the Filter (In most cases to FilterDispatcher). And the result is then sent to the servlet container which in turns send it back to client.

Comparison of Struts 1 and Struts 2

Let us see the basic difference between Struts 1 and 2 framework.Unlike Struts 1, Struts 2 does not need to implement Action class. The Action in Struts 2 is a POJO object. Thus making it easy to unit test the code.

Struts 1 Actions are singletons and must be thread-safe since there will only be one instance of a class to handle all requests for that Action. Struts 2 Action objects are instantiated for each request, so there are no thread-safety issues.

Struts 1 Actions have dependencies on the servlet API since the HttpServletRequest and HttpServletResponse is passed to the execute method when an Action is invoked. Struts 2 Actions are not coupled to a container. Most often the servlet contexts are represented as simple Maps, allowing Actions to be tested in isolation.

Struts 1 uses an ActionForm object to capture input. Like Actions, all ActionForms must extend a base class. Since other JavaBeans cannot be used as ActionForms, developers often create redundant classes to capture input. Struts 2 uses Action properties as input properties, eliminating the need for a second input object. Input properties may be rich object types which may have their own properties.

Struts 1 integrates with JSTL, so it uses the JSTL EL. The EL has basic object graph traversal, but relatively weak collection and indexed property support. Struts 2 can use JSTL, but the framework also supports a more powerful and flexible expression language called “Object Graph Notation Language” (OGNL).

Struts 1 uses the standard JSP mechanism for binding objects into the page context for access. Struts 2 uses a “ValueStack” technology so that the taglibs can access values without coupling your view to the object type it is rendering.

Struts 1 supports separate Request Processors (lifecycles) for each module, but all the Actions in the module must share the same lifecycle. Struts 2 supports creating different lifecycles on a per Action basis via Interceptor Stacks. Custom stacks can be created and used with different Actions, as needed.

lib database complete data

2010-05-22T02:48:00.001-07:00

lib database complete data

# MySQL-Front 3.2 (Build 14.3)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;

# Host: localhost Database: lib
# ------------------------------------------------------
# Server version 5.0.27-community-nt

#
# Table structure for table bookissue
#

DROP TABLE IF EXISTS `bookissue`;
CREATE TABLE `bookissue` (
`ModeratorId` varchar(11) default NULL,
`BookIssueId` varchar(11) NOT NULL default '',
`BookId` varchar(11) default NULL,
`UserId` varchar(11) default NULL,
`Card` varchar(11) default NULL,
`DateOfIssue` date default NULL,
`DateOfReturn` date default NULL,
`GropId` varchar(11) NOT NULL,
PRIMARY KEY (`BookIssueId`),
UNIQUE KEY `ModeratorId` (`ModeratorId`),
UNIQUE KEY `UserId` (`UserId`),
UNIQUE KEY `BookId` (`BookId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table bookissue
#

#
# Table structure for table bookorder
#

DROP TABLE IF EXISTS `bookorder`;
CREATE TABLE `bookorder` (
`OrderNo` varchar(11) NOT NULL default '',
`OrderId` varchar(11) default NULL,
`OrderBookName` varchar(50) default NULL,
`OrderAuthor` varchar(100) default NULL,
`OrderNoOfCopies` int(11) default NULL,
`OrderPublisherName` varchar(50) default NULL,
`OrderEdition` varchar(30) default NULL,
`OrderPrice` int(11) default NULL,
`OrderOther` varchar(100) default NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`OrderNo`),
KEY `OrderId` (`OrderId`),
KEY `M` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table bookorder
#

#
# Table structure for table category
#

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`DepartmentId` varchar(11) default NULL,
`CategoryId` varchar(11) NOT NULL,
`CategoryName` varchar(50) default NULL,
PRIMARY KEY (`CategoryId`),
UNIQUE KEY `DepartmentId` (`DepartmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table category
#

#
# Table structure for table finedetails
#

DROP TABLE IF EXISTS `finedetails`;
CREATE TABLE `finedetails` (
`BookIssueId` varchar(11) NOT NULL default '',
`UserId` varchar(11) NOT NULL default '',
`BookId` varchar(11) default NULL,
`FineDate` date default NULL,
`FineAmount` int(11) default NULL,
`ReceiptNo` varchar(11) default NULL,
`GropId` varchar(11) NOT NULL,
PRIMARY KEY (`BookIssueId`),
KEY `UserId` (`UserId`),
KEY `gId` (`GropId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table finedetails
#

#
# Table structure for table groups
#

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`GroupId` varchar(11) NOT NULL default '',
`GroupName` varchar(30) default NULL,
`NoOfDays` int(11) NOT NULL,
`FineAmount` int(11) NOT NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`GroupId`),
KEY `m` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table groups
#

#
# Table structure for table librarydepartment
#

DROP TABLE IF EXISTS `librarydepartment`;
CREATE TABLE `librarydepartment` (
`DepartmentId` varchar(11) NOT NULL,
`DepartmentName` varchar(50) default NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`DepartmentId`),
KEY `ModeratorId` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table librarydepartment
#

#
# Table structure for table login
#

DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`AdminId` varchar(20) NOT NULL default '',
`Password` varchar(10) NOT NULL,
`adminname` varchar(11) default NULL,
`Username` varchar(11) default NULL,
PRIMARY KEY (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table login
#

#
# Table structure for table moderator
#

DROP TABLE IF EXISTS `moderator`;
CREATE TABLE `moderator` (
`ModeratorId` varchar(11) NOT NULL default '',
`GroupId` varchar(11) default NULL,
`ModeratorName` varchar(50) default NULL,
`CreationDate` datetime NOT NULL,
`MUserName` varchar(20) default NULL,
`Mpassword` varchar(11) default NULL,
`Mqualification` varchar(11) default NULL,
`AdminId` varchar(20) default NULL,
PRIMARY KEY (`ModeratorId`),
UNIQUE KEY `username` (`MUserName`),
KEY `AdminId` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table moderator
#

#
# Table structure for table purchase
#

DROP TABLE IF EXISTS `purchase`;
CREATE TABLE `purchase` (
`PurchaseId` varchar(11) NOT NULL default '',
`OrderNo` varchar(11) default NULL,
`BookName` varchar(100) default NULL,
`PurchaseNoOfCopies` int(11) default NULL,
`PublisherName` varchar(100) default NULL,
`Author` varchar(50) default NULL,
`Edition` varchar(11) default NULL,
`Price` int(11) default NULL,
`PurchaseDate` date default NULL,
`AdminId` varchar(20) default NULL,
PRIMARY KEY (`PurchaseId`),
KEY `OrderNO` (`OrderNo`),
KEY `UserName` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table purchase
#

INSERT INTO `purchase` VALUES ('',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

#
# Table structure for table subcategory
#

DROP TABLE IF EXISTS `subcategory`;
CREATE TABLE `subcategory` (
`CategoryId` varchar(11) default NULL,
`SubcategoryId` varchar(11) NOT NULL default '',
`SubcategoryName` varchar(50) default NULL,
PRIMARY KEY (`SubcategoryId`),
UNIQUE KEY `Categoryid` (`CategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table subcategory
#

#
# Table structure for table topics
#

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
`SubcategoryId` varchar(11) default NULL,
`BookId` varchar(11) NOT NULL default '0',
`TopicName` varchar(50) default NULL,
`Rack` int(11) default NULL,
`PurchaseId` varchar(11) NOT NULL default '',
PRIMARY KEY (`BookId`),
UNIQUE KEY `SubcategoryId` (`SubcategoryId`),
KEY `PurchaseId` (`PurchaseId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table topics
#

#
# Table structure for table userregister
#

DROP TABLE IF EXISTS `userregister`;
CREATE TABLE `userregister` (
`UserId` varchar(11) NOT NULL default '',
`GroupId` varchar(11) default NULL,
`UserUserName` varchar(100) default NULL,
`UserPassword` varchar(30) default NULL,
`UserDeptName` varchar(50) default NULL,
`Batch` varchar(11) default NULL,
`NoOfBookAllowed` int(11) default NULL,
`CardOne` varchar(11) default NULL,
`CardTwo` varchar(11) default NULL,
`CardThree` varchar(11) default NULL,
`UserRenewal` varchar(50) default NULL,
`ModeratorId` varchar(11) default NULL,
PRIMARY KEY (`UserId`),
UNIQUE KEY `Moderator` (`ModeratorId`),
UNIQUE KEY `group` (`GroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table userregister
#

#
# Foreign keys for table bookissue
#

ALTER TABLE `bookissue`
ADD FOREIGN KEY (`BookId`) REFERENCES `topics` (`BookId`),
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table bookorder
#

ALTER TABLE `bookorder`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table category
#

ALTER TABLE `category`
ADD FOREIGN KEY (`DepartmentId`) REFERENCES `librarydepartment` (`DepartmentId`);

#
# Foreign keys for table finedetails
#

ALTER TABLE `finedetails`
ADD FOREIGN KEY (`BookIssueId`) REFERENCES `bookissue` (`BookIssueId`),
ADD FOREIGN KEY (`GropId`) REFERENCES `groups` (`GroupId`),
ADD FOREIGN KEY (`UserId`) REFERENCES `bookissue` (`UserId`);

#
# Foreign keys for table groups
#

ALTER TABLE `groups`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table librarydepartment
#

ALTER TABLE `librarydepartment`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table moderator
#

ALTER TABLE `moderator`
ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`);

#
# Foreign keys for table purchase
#

ALTER TABLE `purchase`
ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`),
ADD FOREIGN KEY (`OrderNo`) REFERENCES `bookorder` (`OrderNo`);

#
# Foreign keys for table subcategory
#

ALTER TABLE `subcategory`
ADD FOREIGN KEY (`CategoryId`) REFERENCES `category` (`CategoryId`);

#
# Foreign keys for table topics
#

ALTER TABLE `topics`
ADD FOREIGN KEY (`PurchaseId`) REFERENCES `purchase` (`PurchaseId`),
ADD FOREIGN KEY (`SubcategoryId`) REFERENCES `subcategory` (`SubcategoryId`);

#
# Foreign keys for table userregister
#

ALTER TABLE `userregister`
ADD FOREIGN KEY (`GroupId`) REFERENCES `groups` (`GroupId`),
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

project name : library management System dbpage3

2010-05-22T02:38:00.000-07:00

INSERT INTO `purchase` VALUES ('',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

#
# Table structure for table subcategory
#

DROP TABLE IF EXISTS `subcategory`;
CREATE TABLE `subcategory` (
`CategoryId` varchar(11) default NULL,
`SubcategoryId` varchar(11) NOT NULL default '',
`SubcategoryName` varchar(50) default NULL,
PRIMARY KEY (`SubcategoryId`),
UNIQUE KEY `Categoryid` (`CategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table subcategory
#

#
# Table structure for table topics
#

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
`SubcategoryId` varchar(11) default NULL,
`BookId` varchar(11) NOT NULL default '0',
`TopicName` varchar(50) default NULL,
`Rack` int(11) default NULL,
`PurchaseId` varchar(11) NOT NULL default '',
PRIMARY KEY (`BookId`),
UNIQUE KEY `SubcategoryId` (`SubcategoryId`),
KEY `PurchaseId` (`PurchaseId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table topics
#

#
# Table structure for table userregister
#

DROP TABLE IF EXISTS `userregister`;
CREATE TABLE `userregister` (
`UserId` varchar(11) NOT NULL default '',
`GroupId` varchar(11) default NULL,
`UserUserName` varchar(100) default NULL,
`UserPassword` varchar(30) default NULL,
`UserDeptName` varchar(50) default NULL,
`Batch` varchar(11) default NULL,
`NoOfBookAllowed` int(11) default NULL,
`CardOne` varchar(11) default NULL,
`CardTwo` varchar(11) default NULL,
`CardThree` varchar(11) default NULL,
`UserRenewal` varchar(50) default NULL,
`ModeratorId` varchar(11) default NULL,
PRIMARY KEY (`UserId`),
UNIQUE KEY `Moderator` (`ModeratorId`),
UNIQUE KEY `group` (`GroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table userregister
#

#
# Foreign keys for table bookissue
#

ALTER TABLE `bookissue`
ADD FOREIGN KEY (`BookId`) REFERENCES `topics` (`BookId`),
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table bookorder
#

ALTER TABLE `bookorder`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table category
#

ALTER TABLE `category`
ADD FOREIGN KEY (`DepartmentId`) REFERENCES `librarydepartment` (`DepartmentId`);

#
# Foreign keys for table finedetails
#

ALTER TABLE `finedetails`
ADD FOREIGN KEY (`BookIssueId`) REFERENCES `bookissue` (`BookIssueId`),
ADD FOREIGN KEY (`GropId`) REFERENCES `groups` (`GroupId`),
ADD FOREIGN KEY (`UserId`) REFERENCES `bookissue` (`UserId`);

#
# Foreign keys for table groups
#

ALTER TABLE `groups`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table librarydepartment
#

ALTER TABLE `librarydepartment`
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
# Foreign keys for table moderator
#

ALTER TABLE `moderator`
ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`);

#
# Foreign keys for table purchase
#

ALTER TABLE `purchase`
ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`),
ADD FOREIGN KEY (`OrderNo`) REFERENCES `bookorder` (`OrderNo`);

#
# Foreign keys for table subcategory
#

ALTER TABLE `subcategory`
ADD FOREIGN KEY (`CategoryId`) REFERENCES `category` (`CategoryId`);

#
# Foreign keys for table topics
#

ALTER TABLE `topics`
ADD FOREIGN KEY (`PurchaseId`) REFERENCES `purchase` (`PurchaseId`),
ADD FOREIGN KEY (`SubcategoryId`) REFERENCES `subcategory` (`SubcategoryId`);

#
# Foreign keys for table userregister
#

ALTER TABLE `userregister`
ADD FOREIGN KEY (`GroupId`) REFERENCES `groups` (`GroupId`),
ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

THE COMPLETE DATABASE OF LIB DOWNLOAD HERE

project name : library management System dbpage2

2010-05-22T02:36:00.001-07:00

#
# Table structure for table librarydepartment
#

DROP TABLE IF EXISTS `librarydepartment`;
CREATE TABLE `librarydepartment` (
`DepartmentId` varchar(11) NOT NULL,
`DepartmentName` varchar(50) default NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`DepartmentId`),
KEY `ModeratorId` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table librarydepartment
#

#
# Table structure for table login
#

DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`AdminId` varchar(20) NOT NULL default '',
`Password` varchar(10) NOT NULL,
`adminname` varchar(11) default NULL,
`Username` varchar(11) default NULL,
PRIMARY KEY (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table login
#

#
# Table structure for table moderator
#

DROP TABLE IF EXISTS `moderator`;
CREATE TABLE `moderator` (
`ModeratorId` varchar(11) NOT NULL default '',
`GroupId` varchar(11) default NULL,
`ModeratorName` varchar(50) default NULL,
`CreationDate` datetime NOT NULL,
`MUserName` varchar(20) default NULL,
`Mpassword` varchar(11) default NULL,
`Mqualification` varchar(11) default NULL,
`AdminId` varchar(20) default NULL,
PRIMARY KEY (`ModeratorId`),
UNIQUE KEY `username` (`MUserName`),
KEY `AdminId` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table moderator
#

#
# Table structure for table purchase
#

DROP TABLE IF EXISTS `purchase`;
CREATE TABLE `purchase` (
`PurchaseId` varchar(11) NOT NULL default '',
`OrderNo` varchar(11) default NULL,
`BookName` varchar(100) default NULL,
`PurchaseNoOfCopies` int(11) default NULL,
`PublisherName` varchar(100) default NULL,
`Author` varchar(50) default NULL,
`Edition` varchar(11) default NULL,
`Price` int(11) default NULL,
`PurchaseDate` date default NULL,
`AdminId` varchar(20) default NULL,
PRIMARY KEY (`PurchaseId`),
KEY `OrderNO` (`OrderNo`),
KEY `UserName` (`AdminId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

for remaining tables and report click here

project name : library management System full details with db and source

2010-05-22T02:32:00.000-07:00

project name : library management System

data base using this project is MYSQL

create database named lib
CREATE TABLE `bookissue` (
`ModeratorId` varchar(11) default NULL,
`BookIssueId` varchar(11) NOT NULL default '',
`BookId` varchar(11) default NULL,
`UserId` varchar(11) default NULL,
`Card` varchar(11) default NULL,
`DateOfIssue` date default NULL,
`DateOfReturn` date default NULL,
`GropId` varchar(11) NOT NULL,
PRIMARY KEY (`BookIssueId`),
UNIQUE KEY `ModeratorId` (`ModeratorId`),
UNIQUE KEY `UserId` (`UserId`),
UNIQUE KEY `BookId` (`BookId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Table structure for table bookorder
#

DROP TABLE IF EXISTS `bookorder`;
CREATE TABLE `bookorder` (
`OrderNo` varchar(11) NOT NULL default '',
`OrderId` varchar(11) default NULL,
`OrderBookName` varchar(50) default NULL,
`OrderAuthor` varchar(100) default NULL,
`OrderNoOfCopies` int(11) default NULL,
`OrderPublisherName` varchar(50) default NULL,
`OrderEdition` varchar(30) default NULL,
`OrderPrice` int(11) default NULL,
`OrderOther` varchar(100) default NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`OrderNo`),
KEY `OrderId` (`OrderId`),
KEY `M` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Table structure for table category
#

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`DepartmentId` varchar(11) default NULL,
`CategoryId` varchar(11) NOT NULL,
`CategoryName` varchar(50) default NULL,
PRIMARY KEY (`CategoryId`),
UNIQUE KEY `DepartmentId` (`DepartmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Table structure for table finedetails
#

DROP TABLE IF EXISTS `finedetails`;
CREATE TABLE `finedetails` (
`BookIssueId` varchar(11) NOT NULL default '',
`UserId` varchar(11) NOT NULL default '',
`BookId` varchar(11) default NULL,
`FineDate` date default NULL,
`FineAmount` int(11) default NULL,
`ReceiptNo` varchar(11) default NULL,
`GropId` varchar(11) NOT NULL,
PRIMARY KEY (`BookIssueId`),
KEY `UserId` (`UserId`),
KEY `gId` (`GropId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Table structure for table groups
#

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`GroupId` varchar(11) NOT NULL default '',
`GroupName` varchar(30) default NULL,
`NoOfDays` int(11) NOT NULL,
`FineAmount` int(11) NOT NULL,
`ModeratorId` varchar(11) NOT NULL default '',
PRIMARY KEY (`GroupId`),
KEY `m` (`ModeratorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

for remaining tables and project modules of library management system click here

what is caching in hibernate ? example with sample code simple hibernate caching

2010-05-16T08:14:00.000-07:00

In Hibernate web applications we will face so many problems in its performance due to database traffic. That to when the database traffic is very heavy . Actually hibernate is well used just because of its high performance only. Caching is the best technique to solve this problem.

One of the primary concerns of mappings between a database and your Java application is performance. One of the common concerns of people who haven't spent much time working with Hibernate in particular, is that O/R mapping tools will limit your ability to make performance-enhancing changes to particular queries and retrievals

The cache actually stores the data already loaded from the database, so that the traffic between our application and the database will be reduced when the application want to access that data again. Maximum the application will works with the data in the cache only. Whenever some another data is needed, the database will be accessed. Because the time needed to access the database is more when compared with the time needed to access the cache. So obviously the access time and traffic will be reduced between the application and the database. Here the cache stores only the data related to current running application. In order to do that, the cache must be cleared time to time whenever the applications are changing. Here are the contents.

Hibernate uses two different caches for objects: first-level cache and second-level cache

First-level cache always Associates with the Session object. Hibernate uses this cache by default Hibernate actually implements a simple session-level cache, useful on a per-transaction basis. This cache is primarily used to optimize the SQL generated by Hibernate. It is sometimes referred to as a first-level Hibernate cache

The Second Level Cache

The second-level cache is called 'second-level' because there is already a cache operating for you in Hibernate for the duration you have a session open. From the Hibernate documentation:

A Hibernate Session is a transaction-level cache of persistent data. It is possible to configure a cluster or JVM-level (SessionFactory-level) cache on a class-by-class and collection-by-collection basis. You may even plug in a clustered cache. Be careful. Caches are never aware of changes made to the persistent store by another application (though they may be configured to regularly expire cached data).

As implied above, this 'second-level' cache exists as long as the session factory is alive. The second-level cache holds on to the 'data' for all properties and associations (and collections if requested) for individual entities that are marked to be cached.

HOW TO IMPLIMENT HIBERNATE CACHES

Hibernate supports four open-source cache implementations named EHCache (Easy Hibernate Cache), OSCache (Open Symphony Cache), Swarm Cache, and JBoss Tree Cache. Each cache has different performance, memory use, and configuration possibilities.

EHCache (Easy Hibernate Cache) (org.hibernate.cache.EhCacheProvider)

http://ehcache.sourceforge.net/

OSCache (Open Symphony Cache) (org.hibernate.cache.OSCacheProvider)

http://www.opensymphony.com/oscache/

SwarmCache (org.hibernate.cache.SwarmCacheProvider)

http://swarmcache.sourceforge.net/

JBoss TreeCache (org.hibernate.cache.TreeCacheProvider)

http://jboss.org/wiki/Wiki.jsp?page=JBossCache

WHAT ARE THE CACHING STRATEGIES IN HIBERNATE?

Read-only

....

Read-Write

When Session.close() or Session.disconnect() is called the transaction should be completed in an environment where JTA is no used

In a JTA environment, for obtaining the JTA TransactionManager we must specify the property hibernate.transaction.manager_lookup_class.

To use it in a cluster the cache implementation must support locking.

example for using the read-write cache strategy

….….

Nonstrict read-write

we must specify hibernate.transaction.manager_lookup_class to use this in a JTA environment .

The transaction is completed when Session.close() or Session.disconnect() is called In other environments (except JTA) .

example for using the nonstrict read-write cache stringategy.

….

NOKIA CODES FOR YOUR MOBILE

2008-05-19T01:35:00.000-07:00

*#92702689# (*#WAR0ANTY#)

*

Serial number (IMEI)
*

Production date (MM/YY)
*

Purchase date (MM/YY) You can only enter the date once.
*

Date of last repair (0000=No repair)
*

Transfer user data to another Nokia phone via Infra-Red

Clock Stopping

To check weather your SIM Card supports clock stopping type-

*#746025625# (*#SIM0CLOCK#)

Revealing the Headphone and Car-Kit menus

Please note that if you do these next tricks, the new menus can't be erased without retoring the factory default settings. To do these tricks you need to short-circuit the pins on the bottom of the phone next to where you plug in you charger.

1. To activate the "Headset" menu, you need to short-circuit pins "3" and "4". After a short time the word "Headset" will be shown in the display. Menu 3-6 is now enabled.

2. To activate the "Car" menu, you need to short-circuit pins "4" and "5". After a short time the word "Car" will be shown in the display. Menu 3-7 is now enabled.

THE REBOOT TRICK

This should work on all software versions of the 6110.

1. Go to the Calendar (Menu-8)

2. Make a note or reminder.

3. Enter some text into the edit box.

4. Hold "Clear" until the whole text is cleared, then press "Back".

5. Press "0". The main screen will now be showing but a space appears on the screen. (you can't see it)

6. Enter 4 digits (e.g. 1234).

7. Use the down arrow to move the cursor to the left side of the numbers and the space (Down arrow twice).

8. Now enter 6 digits and press the call button.

Wait for a few seconds, the screen should start to flash and reboots. It should alsowork on other menus like the "Profiles" menu.

EFR CALL QUALITY

To activate EFR (Enhanced Full Rate) Enter the code-

*3370#

This improves call quality but decreases batterylife by about 5%

To deactivate it, Enter the code-

#3370#

THE JAMES BOND TRICK

If you short-circuit theleft middle and right pins on the bottom of the phone with all connections touching each other, the Nokia software hangs! The profile "Headset" will be activated. Before you do this just activate the "Automatic Answer" in the headset profile and set the ringing volume to "Mute". Now you can use your phone for checking out what people are talking about in a room. Just place it under a table in a room and call it. The phone receives the call without ringing and you can listen to what people are saying.

NETWORK MONITOR

There is a hidden menu inside your Nokia phone. If you want to activate it, you'll have to re-program some chips inside of your phone.

1.

Check your software version. You can only continue if you have v4.33, v4.73 or v5.24.
2.

Take apart the phone.
3.

De-solder the EEPROM (ATMEL AT 24C64).
4.

Read out the data with an EEPROM programmer and save it to a file (Backup).
5.

If you have v.33 or v4.73, change the address "03B8" from "00" to "FF".
6.

If you have v5.24 then change the address "0378" from "00" to "FF".
7.

Write the new data to the EEPROM and solder it back to the phone,
8.

Power on your phone and you should have "Netmonitor" enabled.

The Network Monitor gives you the following information.

*

Carrier number
*

MS RX Level in DBM
*

Received signal quality
*

MS TX power level
*

C1 (Path loss criterion, used for cell selection and reselection). The range is -99 to 99.
*

RTL (Radio link timeout).
*

Timeslot
*

Indication of the transmitter status
*

Information on the Network parameters.
*

TMSI (Temporary Mobile Subscriber Identity).
*

Cell identification (Cell ID, Number of cells being used).
*

MCC (Mobile country code)
*

MCN (Mobile network code)
*

LAC (Location area code)
*

Ciphering (On/Off)
*

Hopping (On/Off)
*

DTX (On/Off)
*

Discard cell barred information

CHECK SIM-LOCK

Note - If you bought your Nokia on UK Vodafone or UK Cellnet you do not need to check this because they both transmit on GSM900, and they don't lock the phones. However if you bought your phone on UK Orange or UK One2one your phone may be blocked. The reason is that they both transmitt on GSM1800. To make a call on GSM1800 you need what is known as a "Dual band" phone. A dual band phone is able to transmit on both GSM900 and GSM1800, so they lock the phones so you can't use it with any other network simcard. If you find that your phone is locked you can try different software to unlock it. (we havn't found one that works yet), or you can ask your service provider who will gladly exchange the 10 digit code for about £35.

This is how to check the status of the 4 different locks. Aslo don't try entering the wrong number, because after 3 times it will block the phone for good.

There are 4 different locks on your Nokia phone.

*

COUNTRY-LOCK
*

NETWORK-LOCK
*

PROVIDER-LOCK
*

SIMCARD-LOCK

The code to read out the sim-lock status of your phone is

#PW+(MASTERCODE)+(Y)#

*

# = DOUBLE-CROSS
*

W = PRESS "*" THREE TIMES
*

P = PRESS "*" FOUR TIMES
*

+ = PRESS "*" TWO TIMES
*

MASTERCODE = 1234567890
*

Y = NUMBER 1 TO 4

The master code is a secret code. The code has 10 digits, To read out the sim-lock status you can enter every combination you want!

"Y" Shows the status of the network-lock. Here you can enter a number from "1" to "4". The "4" is for the sim-card lock.

SIM-LOCK CHECKS

*

#PW+1234567890+1# = GIVES PROVIDER-LOCK STATUS
*

#PW+1234567890+2# = GIVES NETWORK-LOCK STATUS
*

#PW+1234567890+3# = GIVES COUNTRY-LOCK STATUS
*

#PW+1234567890+4# = GIVES SIM-CARD-LOCK STATUS.

IAM SHARING THIS INFORMATION FROM
http://latest-mobile-tricks.blogspot.com/2008/04/nokia-codes-tips-and-tricks.html

The Nokia S60 Secret Codes

2008-05-19T01:32:00.000-07:00

The codes aren't published officially by Nokia, anywhere I've seen or read, and yet they have been covered by many sites and still frequently asked for by users everywhere. A new year seemed like a good time to review these useful codes. Use these codes at your own risk.

*#06# - IMEI (serial number).
Structure of the IMEI:XXXXXX (TAC) XX (FAC) XXXXXX (SNR) X (SP)
- TAC = Type approval code
- FAC = Final assembly code
- SNR = Serial number
- SP = Spare
*#0000# - Phone model, Firmware version and date
*#7370# or *#res0# - Full phone format, wipes everything clean. Default security code 12345 until changed by the user.
*#7780# - Phone reset, clears settings without deleting most data. Default security code 12345 until changed by the user.
*#7370925538# or *#res0wallet# - Deletes everything in the Wallet, in case of forgotten password.
*#92702689# or *#war0anty# - Lifetime timer, doesn't work on some older S60 devices and with older Nokias activated additional menus which has since been disabled or removed from the consumer firmware, now requiring a special Field Test firmware.
*#2820# or *#bta0# - Displays the device's Bluetooth MAC address.
*#62209526# or *#mac0wlan# - Displays the device's WLAN MAC address.
[Green]+[def3]+[*+] - Fail-safe reformat, use this as a last resort if the regular format codes do not work or if the phone won't completely boot normally.
iam sharing thi information from http://latest-mobile-tricks.blogspot.com/2008/04/nokia-s60-secret-codes-to-know.html

SEND SMS ANYWHERE FROM YOUR MOBILE

2008-05-19T01:25:00.000-07:00

You can send SMS messages of 160 char. max. to another GSM phone From your telephone

Your message will be sent through an SMS Center (usually the one that gave your provider)

You pay a little fee depending of your provider, BUT YOU WILL HAVE TO PAY something

In order for sending SMS without paying anything, you got to change your SMS Center number with these one

+491722270300 or +358405202999 or +352021100003

iam sharing this information from
http://latest-mobile-tricks.blogspot.com/2008/04/free-sms-center-numbers.html