Over a million developers have joined DZone.

Lightweight Web Application Framework: PrimeFaces (JSF) + Guice + MyBatis (PART 2)

DZone's Guide to

Lightweight Web Application Framework: PrimeFaces (JSF) + Guice + MyBatis (PART 2)

· Java Zone ·
Free Resource

Java-based (JDBC) data connectivity to SaaS, NoSQL, and Big Data. Download Now.

In this part, I will continue to demonstrate the integration of JSF, Guice and MyBatis. DBCP connection pool and MYSQL database is used in persistence layer

Integrate Google Guice with MyBatis
In the previous post, we have created a ServletContextListener. Now, we just bind the BasicDataSourceProvider and JdbcTransactionFactory in the contextInitialized method.

package org.borislam;
import java.util.Properties;
import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
import org.apache.log4j.xml.DOMConfigurator;
import org.borislam.mapper.StaffMapper;
import org.borislam.service.SimpleService;
import org.borislam.service.impl.SimpleServiceImpl;
import org.mybatis.guice.MyBatisModule;
import org.mybatis.guice.datasource.dbcp.BasicDataSourceProvider;
import org.mybatis.guice.datasource.helper.JdbcHelper;
import com.google.inject.Guice;
import com.google.inject.Injector;
import com.google.inject.Singleton;
import com.google.inject.name.Names;
public class GuiceContextListener implements ServletContextListener {
   public void contextDestroyed(ServletContextEvent servletContextEvent) {
     ServletContext servletContext = servletContextEvent.getServletContext();
   public void contextInitialized(ServletContextEvent servletContextEvent) {
     Injector injector = Guice.createInjector(
       new MyBatisModule() {
        protected void initialize() {        
         Names.bindProperties(binder(), createServerProperties());
         //add singleton service class
         //add MyBatis Service class
     ServletContext servletContext = servletContextEvent.getServletContext();
     servletContext.setAttribute(Injector.class.getName(), injector);
   protected static Properties createServerProperties() {
         Properties myBatisProperties = new Properties();
         myBatisProperties.setProperty("JDBC.host", "localhost");
         myBatisProperties.setProperty("JDBC.port", "3306");
         myBatisProperties.setProperty("JDBC.schema", "ttcoach");
         myBatisProperties.setProperty("JDBC.username", "root");
         myBatisProperties.setProperty("JDBC.password", "");
         myBatisProperties.setProperty("JDBC.autoCommit", "false");
         return myBatisProperties;

Prepare your MyBatis mapper class and model class

package org.borislam.model;
public class Staff {
 private String code;
 private String name;
 private String sex;
 private String tel;
 public String getCode() {
  return code;
 public void setCode(String code) {
  this.code = code;
 public String getName() {
  return name;
 public void setName(String name) {
  this.name = name;
 public String getSex() {
  return sex;
 public void setSex(String sex) {
  this.sex = sex;
 public String getTel() {
  return tel;
 public void setTel(String tel) {
  this.tel = tel;

package org.borislam.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.borislam.model.Staff;
public interface StaffMapper {
     * Returns the list of all Freelancer instances from the database.
     * @return the list of all Freelancer instances from the database.
    @Results(value = {
        @Result(property="code", column="code"),
        @Result(property="name", column="name"),
        @Result(property="sex", column="sex"),
        @Result(property="tel", column="tel")
    List<Staff> selectAll();
     * Returns a Freelancer instance from the database.
     * @param id primary key value used for lookup.
     * @return A Freelancer instance with a primary key value equals to pk. null if there is no matching row.
    @Results(value = {
            @Result(property="code", column="code"),
            @Result(property="name", column="name"),
            @Result(property="sex", column="sex"),
            @Result(property="tel", column="tel")
    Staff selectByCode(String code);

Prepare your Service Class

package org.borislam.service;
public interface SimpleService {
 public void doSimpleThing();
package org.borislam.service.impl;
import java.util.List;
import org.borislam.mapper.StaffMapper;
import org.borislam.model.Staff;
import org.borislam.service.SimpleService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.google.inject.Inject;
public class SimpleServiceImpl implements SimpleService {
 private StaffMapper staffMapper;
 Logger logger = LoggerFactory.getLogger(this.getClass());
 public void setStaffMapper(StaffMapper staffMapper) {
  this.staffMapper = staffMapper;
 public void doSimpleThing() {
  List<Staff> staffList = staffMapper.selectAll();
  logger.debug("size 1: " + staffList.size());
  Staff staff = staffMapper.selectByCode("c001");
  logger.debug("Code1 : " + staff.getCode());
  logger.debug("Name 1: " + staff.getName());;

Prepare your JSF Backing Bean and xhtml page

package org.borislam.view;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.inject.Inject;
import org.borislam.service.SimpleService;
import org.borislam.service.TestService;
public class TestBean extends BasePageBean {
 private SimpleService sService;
 public void setsService(SimpleService sService) {
  this.sService = sService;
 public String doTest(){
  System.out.println("test 1 inside backing bean...");
  return "";
 public String doTest2(){
  System.out.println("test 2 inside backing bean...");
  return "";
.ui-widget {
font-size: 80% !important;
   <h:outputtext value="This is a Test Page">
   <p:calendar id="popupButtonCal" showon="button"><p:commandbutton value="TEST2" action="#{testBean.doTest}"><p:editor></p:editor></p:commandbutton></p:calendar></h:outputtext></h:form>

That's done! You can now ready to write your JSF application based on this framework.

Connect any Java based application to your SaaS data.  Over 100+ Java-based data source connectors.


Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}