Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


meena n
create dao
1 Answer(s)      2 years and 5 months ago
Posted in : Java Interview Questions


code 1
package com.dao;
import java.sql.*;
import com.beans.*;

public class DbAccess {

    public void createStudent(SampleBean sampleBean) throws SQLException
    {
        Connection con=null;

        try
        {
            con=DbConnect.createConnection();
            PreparedStatement ps=con.prepareStatement("insert into dinstudent values(?,?,?,?,?)");
            ps.setString(1, sampleBean.getFname());
            ps.setString(2, sampleBean.getLname());
            ps.setInt(3, sampleBean.getAge());
            ps.setString(4, sampleBean.getGender());
            ps.setString(5, sampleBean.getPhone());
            ps.executeUpdate();
            System.out.println("Addition Success");

        }
        catch(Exception e)
        {
            System.out.println("Error in create access");
        }
    }
    public SampleBean viewStudent(String fname) throws SQLException
    {

        SampleBean samView=new SampleBean();
        Connection con=null;
        ResultSet rs=null;
        try
        {
            con=DbConnect.createConnection();
            PreparedStatement ps=con.prepareStatement("select * from dinstudent where fname=?");
            ps.setString(1,fname);

            rs=ps.executeQuery();
            while(rs.next())
            {
                String a=rs.getString(1);

                samView.setFname(a);
                samView.setLname(rs.getString(2));
                samView.setAge(rs.getInt(3));
                samView.setGender(rs.getString(4));
                samView.setPhone(rs.getString(5));
                System.out.println("View Success");
            }
        }
        catch(Exception e)
        {
            System.out.println("Error in student view access");
        }
        return samView;
    }
    public void updateStudent(SampleBean sample,String firstname) throws SQLException
    {
        Connection con=null;
        try
        {

            con=DbConnect.createConnection();
            PreparedStatement ps=con.prepareStatement("update dinstudent set fname=?,lname=?,age=?,gender=?,phone=? where fname=?");
            ps.setString(1,sample.getFname());
            ps.setString(2,sample.getLname());
            ps.setInt(3,sample.getAge());
            ps.setString(4,sample.getGender());
            ps.setString(5,sample.getPhone());
            ps.setString(6,firstname);
            ps.executeQuery();
            System.out.println("updated");
        }
        catch(Exception e)
        {
            System.out.println("Error in student update access");
        }
    }
    public void deleteStudent(String deleteName) throws SQLException
    {
        Connection con=null;
        try
        {
            con=DbConnect.createConnection();
            PreparedStatement ps=con.prepareStatement("delete dinstudent where fname=?");
            ps.setString(1,deleteName);
            ps.executeQuery();
            System.out.println("deleted");
        }
        catch(Exception e)
        {
            System.out.println("Error in access Delete");
        }
    }
}


code 2:


package com.dao;
import java.sql.*;

public class DbConnect {


    public static Connection createConnection()
    {
        Connection con=null;
    try
    {
        Class.forName("oracle.jdbc.OracleDriver");
        con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr", "hr");

        System.out.println("Connected");
    }
    catch(Exception e)
    {
        System.out.println("Not Connected");
        e.printStackTrace();
    }
    return con;
    }

}

Advertisement
View Answers

April 2, 2012 at 7:59 AM


public class ConnectionOracle { public Connection OraConn() {

    Connection conn=null;
    try 
    {
        // load the JDBC-ODBC Bridge driver         
        Class.forName(Constants.DRIVERNAME);
        conn =DriverManager.getConnection( Constants.URL,Constants.USERNAME,Constants.PASSWORD );


    }

    catch ( ClassNotFoundException cnfex ) 
    {
        System.out.println("Class not found !! " +cnfex);           
    }
    catch ( SQLException sqlex ) 
    {
        System.out.println("SQL Exception !! " +sqlex);         
        sqlex.printStackTrace();
    }
    catch (Exception ex)
    {
        System.out.println("Exception has occured "+ex);
    }
    return conn;
}

}



Related Tutorials/Questions & Answers:
create dao
create dao  code 1 package com.dao; import java.sql.*; import com.beans.*; public class DbAccess { public void createStudent(SampleBean...) { System.out.println("Error in create access"); } } public SampleBean
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...) { System.out.println("Error in create access"); } } public SampleBean
Advertisements
doubt on DAO's
doubt on DAO's  hai frnds.... can anyoneexplain about how to integrate struts with hibernate,any predifined plugin is available or we need to create our own plugin????? and please help me. how to use dao s while integrating
doubt on DAO's
doubt on DAO's  hai frnds.... can anyoneexplain about how to integrate struts with hibernate,any predifined plugin is available or we need to create our own plugin????? and please help me. how to use dao s while integrating
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
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
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
This tutorial shows, how to create the source code of Dao and DaoImpl class..., 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
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
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
Creating Data Access Object (DAO) Design Pattern
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...Creating Data Access Object (DAO) Design Pattern Data Access Object
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
create
create  how to create an excel file using java
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
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
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
How create csv format in jsf ?
How create csv format in jsf ?  Dear Friends , Good morning to all of you? I have a problem to create .CSV format in jsf. Actully I have.... I have created a BO for fields of jasper report,and crate a seprate dao
create frames
create frames  How do I create frames? What is a frameset
create folder
create folder  what code we should write as a web application that it create an empty folder on client's desktop
create a class
create a class  plz provide any example related to class
create webservice
create webservice  Hi Can anyone help me to create a webservice which access another webservice results and display it. thanks
create a button
create a button  i have created button inhtml but my jsp is not working,so can u guide me
Create Array ??
Create Array ??   Question in e-clips program: Part 1. Array Implementation -Create a class called ‚??PhoneEntry‚?? which can be used to store the name and number of ONE client. -Create a class called ‚??MyArrayList‚?? which
create jsp
create jsp  <%@ page language="java" contentType="text/html...; charset=ISO-8859-1"> <title>Create New Student</title> </head> <body> <form name="create" method="post" action="<
syntax for create a table
syntax for create a table  syntax for create a table
how to create frame in swings
how to create frame in swings  how to create frame in swings
How to create arrays in JavaScript?
How to create arrays in JavaScript?  How to create arrays in JavaScript
create arrays in JavaScript
create arrays in JavaScript  How to create arrays in JavaScript
Create toolbars for IE
Create toolbars for IE  how to create a ie toolbar in java script
how to create notepad in java
how to create notepad in java  how to create notepad in java
php create pages automatically
php create pages automatically  How to create pages automatically in PHP
create dynamic array in javascript
create dynamic array in javascript  How to create dynamic array in javascript
program to create nested tables
program to create nested tables  program to create nested tables
How to create a confirmation box?
How to create a confirmation box?  How to create a confirmation box
 

 

 

DMCA.com