Share on Google+Share on Google+

puvi
dao
0 Answer(s)      4 years and 11 months ago
Posted in : JSP-Servlet
package com.ilp.tsi.um.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.ilp.tsi.um.constant.BankConstant;
public class BankDao {
    public static Connection createconnection() {
        Connection conn = null;
        try 
        {
            Class.forName(BankConstant.DRIVER).newInstance();
            conn = DriverManager.getConnection(BankConstant.DBURL,BankConstant.DBUSER, BankConstant.DBPASS);

        } 
        catch (ClassNotFoundException ce) 
        {
            ce.printStackTrace();
        } 
        catch (SQLException e) 
        {
            e.printStackTrace();
        } 
        catch (InstantiationException e)
        {
            e.printStackTrace();
        } 
        catch (IllegalAccessException e) 
        {
            e.printStackTrace();
        }
        return conn;
    }

}

//bean:

package com.ilp.tsi.um.bean;

public class BankBean {

private String userName;
private String password;

public String getUsername(){
    return userName;

}
public void setUsername(String username){
    userName=username;
}
public String getPassword(){
    return password;

}
public void setPassword(String password){
    this.password=password;
}
}

//service:

package com.ilp.tsi.um.service;


    import java.sql.Connection;

    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;

    import com.ilp.tsi.um.bean.BankBean;

    public class BankService {
         //To Perform login authentication of Administrator
        public boolean authenticate(BankBean loginBean, Connection connection)
                throws SQLException {

            try {
                String Username = loginBean.getUsername();
                String Password = loginBean.getPassword();

                Statement statement = connection.createStatement();
                // Executing required select query using Statement
                ResultSet rs = statement.executeQuery("select * from adminlogin  where username='"+Username+"' and  password='"+Password+"'");
                // Iterating resultset for the data from table
                if (rs.next()) {
                    return true;
                    // end if 
                } else {
                    return false;
                } // end else

            } catch (SQLException sqle) {
                sqle.printStackTrace();
                connection.close();

            } // end catch 
            catch (Exception e) {
                e.printStackTrace();
                connection.close();
            }// end catch 
            finally
            {
            connection.close();}
            return false;
        }// end finally


    }

Ads

View Answers









Related Tutorials/Questions & Answers:
DAO Classes
DAO Classes  login page code for Dao classes
DAO Example
DAO Example  Dear Friends Could any one please give me any example of DAO application in struts? Thanks & Regards Rajesh
Advertisements
DAO - JDBC
DAO  what is dao ? and how to use it?  Hi Friend, The DAO is a pattern that provides a technique for separating object persistence and data access logic from any particular persistence mechanism or API. Thanks
DAO in Struts
DAO in Struts  Can Roseindia provide a simple tutorial for implementation of DAO with struts 1.2? I a link already exits plz do tell me. Thank you
doubt on DAO's
doubt on DAO's  hai frnds.... can anyoneexplain about how... our own plugin????? and please help me. how to use dao s while integrating struts with hibernate..??? actually what is the purpose of dao's ????? please help
doubt on DAO's
doubt on DAO's  hai frnds.... can anyoneexplain about how... our own plugin????? and please help me. how to use dao s while integrating struts with hibernate..??? actually what is the purpose of dao's ????? please help
dao pack
dao pack  package com.tsi.dao; import java.sql.*; import com.tsi.constants.*; public class DaoPack { public static Connection conn = null; public static Connection createConnection() { try
dao pack
dao pack  package com.tsi.dao; import java.sql.*; import com.tsi.constants.*; public class DaoPack { public static Connection conn = null; public static Connection createConnection() { try
dao
CRUD DAO
CRUD DAO  how to create dao for create,read,update and delete?   /* *ConnectionManager * * *Version:1.0 * *Date:25-Nov-2011 * */ package com.student.dao; import java.sql.*; import org.apache.log4j.Logger
spring DAO module turorial
spring DAO module turorial  how to integrate springDAO and spring webMVC
implementing DAO - Struts
, exam in 3 days, and just now i found out our lecturer post a demo on DAO... divided into DAO factory Impl,employeeDAOImpl,DAOFactory,EmployeeDAO. "I strongly... writing DAO Implementation classes." This is her advice. But as a beginner who just
What is the DAO Layer in any application?
What is the DAO Layer in any application?  Hi, What is the use of the DAO layer in any application and how to develop it. Explain with the example code. Thanks   The DAO layer is also known as data access layer
DAO DTO design pattern
DAO DTO design pattern  Hi,using dao and dto i want to perform insert,update and delete operation.and the data should navigate from 1 frame 2 another.that page should b smthng like this: <%@ page language="java" import
DAO DTO design pattern
DAO DTO design pattern  Hi,using dao and dto i want to perform insert,update and delete operation.and the data should navigate from 1 frame 2 another.that page should b smthng like this: <%@ page language="java" import
DAO DTO design pattern
DAO DTO design pattern  Hi,using dao and dto i want to perform insert,update and delete operation.and the data should navigate from 1 frame 2 another.that page should b smthng like this: <%@ page language="java" import
DAO DTO design pattern
DAO DTO design pattern  Hi,using dao and dto i want to perform insert,update and delete operation.and the data should navigate from 1 frame 2 another.that page should b smthng like this: <%@ page language="java" import
how to create dao
how to create dao   code1: package com.dao; import java.sql.*; import com.beans.*; public class DbAccess { public void createStudent(SampleBean sampleBean) throws SQLException { Connection con=null; try
DAO,DTO,VO Design patterns
DAO,DTO,VO Design patterns  explain dao,dto,vo design patterns in strut 1.3?   Data Access Object (DAO) pattern is the most popular design patterns. It is used when you want to separate your presentation code from
DAO Layer explained
DAO Layer explained       In this section we will explain you the DAO Layer of our application.   DAO Layer Explained   DAO stand for Data
how to login form through spring dao module
how to login form through spring dao module  here i want to chek user details in database through form by using spring dao module.please give me some reference example to me
What is Spring Struts Hibernate DAO Layer?
What is Spring Struts Hibernate DAO Layer?  Hi, explain me the difference in between Spring Struts Hibernate DAO Layer? Thanks   Hi... Spring Struts Hibernate DAO Layer. Thanks
Creating Data Access Object (DAO) Design Pattern
Creating Data Access Object (DAO) Design Pattern Data Access Object... code contains in  DAO and it provides a simple interface to access the data. In DAO you need to create the Connection factory class. This class contains
Problem to get connection from DAO class to JDBC
Problem to get connection from DAO class to JDBC  package controller; import java.sql.Connection; import java.sql.DriverManager; public class ConnectionProvider { private static Connection con=null; //static Connection
login dao file for referece (source code for reference)
login dao file for referece (source code for reference)  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <
How to display data in jsp from dao using java beans?
How to display data in jsp from dao using java beans?  Hi I need to display data in jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated
How to connect to dao n bean classes with jsp
How to connect to dao n bean classes with jsp  I have made this edao pkg package edao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import
Understanding Spring Struts Hibernate DAO Layer
Understanding Spring Struts Hibernate DAO Layer... Hibernate DAO Layer   The Data Access Object for this application is written... access object. The Hibernate DAO consists applicationContext-hibernate.xml
How sql Queries possible in DAO without creating Database connections - Java Beginners
How sql Queries possible in DAO without creating Database connections  In DAO we are writting sql queries , how it is possible without creating and closing database connections
Data Access object (DAO) Design Pattern
. The DAO design pattern completely  hides the data access implementation... the DAO to adopt different access scheme without affecting to business logic or its.... The DAO design pattern consists of some factory classes, DAO interfaces
Tutorials   
Java Spring Hibernate Struts Training fat image from db fat image from db fat image from db fat image from db unable to get value returned from javascript variable in page How to change image size before adding to mysql using jsp Design a registration.jsp page with input for user registration details Cart Quantity jsp servlet coding issue servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? image pdf marking pdf marking Multiple image upload using JSP Read code from excel sheet and upload into database using JSP Student java about search engine Convert BLOB to PDF and save it to a location how to copy files from remote to local machine using SFTP SSL in java? Like Team viewer Socket and Servert -Jsp how to copy files from remote location to local using java? How To Store Multilple Images In MySQL database dynamically with image uploader and then retrieve them in image gallery using java how to create SOAP based web service in java? how to fetch data from mysql database table and draw a bar chart on that data using in jsp how to create users in LDAP using java? how to authenticate user using TIVOLI api in java? how to create users using IBM Tivoi API in jsp/servelet? Java/J2ee Please explain this code as many packages and classes are unknown to me .! how to download the uploaded folder files using jsp Login Query image is display from path of mysql database please reply the code to store dynamic fields in database? Reloading issue in jsp How to get Button Id ? calling one jap page from another jsp page login login Problem to get connection from DAO class to JDBC Page Loading Time Fix table's column's name row(1st row of the table) so that it does not move up when the table is scrolled up to view more rows below Sending hidden values

Ads

 
Advertisement null

Ads