Thursday, January 26, 2017

How to install the Sqljdbc4 for use Sql server with hibernate, spring, maven and eclipse

If we want to use sql server with a maven project that uses hibernate and spring we need the jdbc for sql server, but the maven has not integrate this jar, for this reason we have install it manually, for get it we can follow these steps.

First we must download the jar jdbc for sql server, we can download it from this link
https://mvnrepository.com/artifact/com.microsoft.sqlserver

In this example i have downloaded the Sqljdbc4 and i saved in the D:\jdbc\

Later Right click on the project, click on Run As ->Maven Build...

In the field goal you must put the code

 install:install-file -Dfile="D:\jdbc\sqljdbc4.jar" -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0 -Dpackaging=jar  


Click on Apply -> Click on Run

The next step is put in the pom.xml file the next code

 <!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->  
 <dependency>  
   <groupId>com.microsoft.sqlserver</groupId>  
   <artifactId>sqljdbc4</artifactId>  
   <version>4.0</version>  
 </dependency>  


With these steps you will have the jdbc for sql server ready in the maven project

Wednesday, January 25, 2017

Java Create a Barcode using BarCode4J And Maven

If we want to create a barcode we can use the Barcode4J library.


If we are using Maven the dependency that we can use is this:

 <!-- https://mvnrepository.com/artifact/net.sf.barcode4j/barcode4j -->  
 <dependency>  
   <groupId>net.sf.barcode4j</groupId>  
   <artifactId>barcode4j</artifactId>  
   <version>2.1</version>  
 </dependency>  
Ref: https://mvnrepository.com/artifact/net.sf.barcode4j/barcode4j/2.1


 If we are using Gradle the dependency that we can use is this:

 // https://mvnrepository.com/artifact/net.sf.barcode4j/barcode4j  
 compile group: 'net.sf.barcode4j', name: 'barcode4j', version: '2.1'  
Ref: https://mvnrepository.com/artifact/net.sf.barcode4j/barcode4j/2.1


The code in Java that we can use for create a barcode using Barcode4J is the next:

 import java.awt.image.BufferedImage;   
  import java.io.File;   
  import java.io.FileNotFoundException;   
  import java.io.FileOutputStream;   
  import java.io.OutputStream;   
  import org.krysalis.barcode4j.impl.code39.Code39Bean;   
  import org.krysalis.barcode4j.output.bitmap.BitmapCanvasProvider;   
  import org.krysalis.barcode4j.tools.UnitConv;   
  public class CodeBarServicesImpl implements CodeBarServices{   
    public void generateCodeBar(String codeBarValue) throws Exception {   
       String fullPath = null;   
       try {   
         Code39Bean bean = new Code39Bean();   
         final int dpi = 150;   
         String path = "D:\\";   
         String extension = ".jpg";   
         fullPath = path + codeBarValue + extension;   
         // Configure the barcode generator   
         bean.setModuleWidth(UnitConv.in2mm(1.0f / dpi)); // makes the narrow   
         bean.setWideFactor(3);   
         bean.doQuietZone(false);           
         File outputFile = new File(fullPath);   
         OutputStream out = new FileOutputStream(outputFile);   
         try {             
            BitmapCanvasProvider canvas = new BitmapCanvasProvider(out,   
            "image/jpeg", dpi, BufferedImage.TYPE_BYTE_BINARY,   
            false, 0);             
            // We Generate the barcode   
            bean.generateBarcode(canvas, codeBarValue);   
            canvas.finish();   
         } finally {   
            out.close();   
         }    
       } catch (Exception e) {           
         e.printStackTrace();   
         throw new Exception(e);   
       }    
    }      
  }