http://feeds.feedburner.com/SpendYourTimeHere-Once

Current Affiares

Monday, September 10, 2012

dao\impl ???

LoginDaoImpl.java

package testlab.dao.impl;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.springframework.jdbc.core.JdbcTemplate;
import testlab.dao.LoginDao;
/**
 *
 * @author ravi
 */
public class LoginDaoImpl implements LoginDao,Serializable {
    private JdbcTemplate jdbcTemplate;
    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }
    @Override
    public boolean validateLogin(String username, String password, String user_type) {
        boolean check = false;
        try {
            System.out.println("in sdfssssssssssss::");
            Connection con = jdbcTemplate.getDataSource().getConnection();
            System.out.println("con::" + con);
            String loginQuery = "select user_id,password,user_type from user_mstr where user_id=? and password=? and user_type=?";
            PreparedStatement stmt = con.prepareStatement(loginQuery);
            stmt.setString(1, username);
            stmt.setString(2, password);
            stmt.setString(3, user_type);
            ResultSet rs = stmt.executeQuery();
            while (rs.next()) {
                if (rs.getString("user_id") != null && rs.getString("password") != null && rs.getString("user_type") != null) {
                    System.out.println("form dbname ::" + rs.getString("user_id"));
                    System.out.println("form dbpassword ::" + rs.getString("password"));
                    check = true;
                }
            }
            //stmt.execute();
            //String lastName = this.jdbcTemplate.queryForObject("select name from user_mstr where user_id = ?",new Object[]{1}, String.class);
            //   System.out.println("hi::"+lastName);
        } catch (Exception ex) {
        }
        return check;
    }
    /**
     * @param jdbcTemplate the jdbcTemplate to set
     */
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
}

Dao???

LoginDao.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package testlab.dao;
/**
 *
 * @author ravi
 */
public interface LoginDao {
     boolean validateLogin(String name,String password,String user_type);
}

------------------
TestDetailDao.java


package testlab.dao;
import java.util.List;
import javax.faces.model.SelectItem;
import testlab.beans.TestDetailBean;
/**
 *
 * @author ANURAGBIS
 */
public interface TestDetailDao {
    List<SelectItem> branchDetail(TestDetailBean testDetailBean);
    List<SelectItem> sampleTypeDetail(TestDetailBean testDetailBean);
    String submitReport(TestDetailBean testDetailBean);
    String submitUpdateReport(TestDetailBean testDetailBean);
    void uploadPdf(TestDetailBean testDetailBean);
    void uploadUpdatePdf(TestDetailBean testDetailBean);
    List<TestDetailBean> searchTestByText(TestDetailBean testDetailBean);
    void fetchTestDetailBySampleId(TestDetailBean testDetailBean, int sampleid);
    String deleteTest(TestDetailBean testDetailBean, int sampleid);
    List<TestDetailBean> viewTestbyText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestbyType(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestbyDateText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyDateText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyType(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForMgrBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForLabOfSevenDays(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForBranchOfSevenDays(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForMngrOfSevenDays(TestDetailBean testDetailBean);
    List<TestDetailBean> viewCompTestReportForMngr(TestDetailBean testDetailBean);
    List<TestDetailBean> fetchSelectedLabTestDetailForMgrBwTwoDateByLabcode(TestDetailBean testDetailBean, String labcode);
    List<TestDetailBean> fetchSelectedISNOTestDetailForMgrBwTwoDateByisno(TestDetailBean testDetailBean, String isno);
    List<TestDetailBean> fetchAllLabTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean);
    List<TestDetailBean> fetchAllISNOTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean);
}

BoImpl??

LoginBoImpl.java


package testlab.bo.impl;
import java.io.Serializable;
import testlab.bo.LoginBo;
import testlab.dao.LoginDao;
/**
 *
 * @author ravi
 */
public class LoginBoImpl implements LoginBo,Serializable {
    LoginDao loginDao;
    public LoginDao getLoginDao() {
        return loginDao;
    }
    public void setLoginDao(LoginDao loginDao) {
        this.loginDao = loginDao;
    }
    @Override
    public boolean validateLogin(String name, String password,String user_type) {
        return loginDao.validateLogin(name, password, user_type);
    }
   
}




----------------------
testdetailBoImple.java
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package testlab.bo.impl;
import java.io.Serializable;
import java.util.List;
import javax.faces.model.SelectItem;
import testlab.beans.TestDetailBean;
import testlab.bo.TestDetailBo;
import testlab.dao.TestDetailDao;
/**
 *
 * @author ANURAGBIS
 */
public class TestDetailBoImpl implements TestDetailBo, Serializable {
    TestDetailDao testDetailDao;
    public TestDetailDao getTestDetailDao() {
        return testDetailDao;
    }
    public void setTestDetailDao(TestDetailDao testDetailDao) {
        this.testDetailDao = testDetailDao;
    }
    @Override
    public List<SelectItem> branchDetail(TestDetailBean testDetailBean) {
        return testDetailDao.branchDetail(testDetailBean);
    }
    @Override
    public List<SelectItem> sampleTypeDetail(TestDetailBean testDetailBean) {
        return testDetailDao.sampleTypeDetail(testDetailBean);
    }
    @Override
    public String submitReport(TestDetailBean testDetailBean) {
        return testDetailDao.submitReport(testDetailBean);
    }
    @Override
    public void uploadPdf(TestDetailBean testDetailBean) {
        this.testDetailDao.uploadPdf(testDetailBean);
    }
    @Override
    public List<TestDetailBean> searchTestByText(TestDetailBean testDetailBean) {
        return testDetailDao.searchTestByText(testDetailBean);
    }
    @Override
    public void fetchTestDetailBySampleId(TestDetailBean testDetailBean, int sampleid) {
        this.testDetailDao.fetchTestDetailBySampleId(testDetailBean, sampleid);
    }
    @Override
    public String deleteTest(TestDetailBean testDetailBean, int sampleid) {
        return testDetailDao.deleteTest(testDetailBean, sampleid);
    }
    @Override
    public List<TestDetailBean> viewTestbyText(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestbyText(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestbyType(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestbyType(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestbyDateText(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestbyDateText(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestBwDate(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestBwDate(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestForBranchbyText(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestForBranchbyText(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestForBranchbyDateText(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestForBranchbyDateText(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestForBranchbyType(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestForBranchbyType(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestForBranchBwDate(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestForBranchBwDate(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestForMgrBwDate(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestForMgrBwDate(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestReportForLabOfSevenDays(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestReportForLabOfSevenDays(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestReportForBranchOfSevenDays(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestReportForBranchOfSevenDays(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewTestReportForMngrOfSevenDays(TestDetailBean testDetailBean) {
        return testDetailDao.viewTestReportForMngrOfSevenDays(testDetailBean);
    }
    @Override
    public List<TestDetailBean> viewCompTestReportForMngr(TestDetailBean testDetailBean) {
        return testDetailDao.viewCompTestReportForMngr(testDetailBean);
    }
    @Override
    public String submitUpdateReport(TestDetailBean testDetailBean) {
        return testDetailDao.submitUpdateReport(testDetailBean);
    }
    @Override
    public void uploadUpdatePdf(TestDetailBean testDetailBean) {
        this.testDetailDao.uploadUpdatePdf(testDetailBean);
    }
    @Override
    public List<TestDetailBean> fetchSelectedLabTestDetailForMgrBwTwoDateByLabcode(TestDetailBean testDetailBean, String labcode) {
        return testDetailDao.fetchSelectedLabTestDetailForMgrBwTwoDateByLabcode(testDetailBean, labcode);
    }
    @Override
    public List<TestDetailBean> fetchSelectedISNOTestDetailForMgrBwTwoDateByisno(TestDetailBean testDetailBean, String isno) {
        return testDetailDao.fetchSelectedISNOTestDetailForMgrBwTwoDateByisno(testDetailBean, isno);
    }
    @Override
    public List<TestDetailBean> fetchAllLabTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean) {
        return testDetailDao.fetchAllLabTestDetailForMgrBwTwoDate(testDetailBean);
    }
    @Override
    public List<TestDetailBean> fetchAllISNOTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean) {
        return testDetailDao.fetchAllISNOTestDetailForMgrBwTwoDate(testDetailBean);
    }
}

what is dao layer structure?

testlsb - beans, bo, dao

suppose LoginBo.java

package testlab.bo;
public interface LoginBo {
    boolean validateLogin(String name,String password,String user_type);
}

or testdetailBo.java
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package testlab.bo;
import java.util.List;
import javax.faces.model.SelectItem;
import testlab.beans.TestDetailBean;
/**
 *
 * @author ANURAGBIS
 */
public interface TestDetailBo {
    List<SelectItem> branchDetail(TestDetailBean testDetailBean);
    List<SelectItem> sampleTypeDetail(TestDetailBean testDetailBean);
    String submitReport(TestDetailBean testDetailBean);
    String submitUpdateReport(TestDetailBean testDetailBean);
    void uploadPdf(TestDetailBean testDetailBean);
    void uploadUpdatePdf(TestDetailBean testDetailBean);
    List<TestDetailBean> searchTestByText(TestDetailBean testDetailBean);
    void fetchTestDetailBySampleId(TestDetailBean testDetailBean, int sampleid);
    String deleteTest(TestDetailBean testDetailBean, int sampleid);
    List<TestDetailBean> viewTestbyText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestbyType(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestbyDateText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyDateText(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchbyType(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForBranchBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestForMgrBwDate(TestDetailBean testDetailBean);
    List<TestDetailBean> fetchSelectedLabTestDetailForMgrBwTwoDateByLabcode(TestDetailBean testDetailBean, String labcode);
    List<TestDetailBean> fetchSelectedISNOTestDetailForMgrBwTwoDateByisno(TestDetailBean testDetailBean, String isno);
    List<TestDetailBean> fetchAllLabTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean);
    List<TestDetailBean> fetchAllISNOTestDetailForMgrBwTwoDate(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForLabOfSevenDays(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForBranchOfSevenDays(TestDetailBean testDetailBean);
    List<TestDetailBean> viewTestReportForMngrOfSevenDays(TestDetailBean testDetailBean);
   
    List<TestDetailBean> viewCompTestReportForMngr(TestDetailBean testDetailBean);
}

what should be the jsf project structure?

testlab - nbproject
          - src
          -  web
          -  build.xml



web - META-INF - context.xml
       - WEB-INF-web.xml
                       -faces-config.xml
                       -applicationContext.xml
                       -beans.xml
                       -lib
                      

       - resources
       -*.xhtml
       -*.js

src - conf - MANIFEST.MF
     - java - config - database - db.properties

              - testlab - beans,bo,dao,properties,ui,utils,constants

beans - UserBean.java
bo - impl,LoginBo.java
      impl - LoginBoImpl.java
dao - impl,LoginDao.java
        impl-LoginDaoImpl.java
  


My Blog List

Popular Posts

All Rights Reserved To SYTHONCE. Ethereal theme. Powered by Blogger.