how to create dao

Ads

 
 

Share on Google+Share on Google+

meena n
how to create dao
0 Answer(s)      5 years and 7 months ago
Posted in : Java Interview Questions

code1: 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");
    }
}

}

code2 :

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;
}

}

print("code sample");
Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
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
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
Advertisements
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
How to create an input box?
How to create an input box?  How to create an input box
How to create arrays in JavaScript?
How to create arrays in JavaScript?  How to create arrays in JavaScript
How to create a confirmation box?
How to create a confirmation box?  How to create a confirmation box
how to create frame in swings
how to create frame in swings  how to create frame in swings
how to create notepad in java
how to create notepad in java  how to create notepad in java
how to create session for login
how to create session for login  how to create session for login? how to display uploaded resume and images in the profile
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 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
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... = totalvillagearea; } } **how to connect with this edao and ebean pkg with my jsp
How to create a class in java
How to create a class in java  I am a beginner in programming and tried to learn how to do programming in Java. Friends please explain how can I create a class in Java
How to create form in Swings
How to create form in Swings  How to create registration, login and question form in Java Swing?   Creating different forms in Java Swing - Examples how to create registration form in swing swing login form example
how to create web aplli
how to create web aplli  how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
how to create web aplli
how to create web aplli  how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
how to create a queue - JMS
how to create a queue  Can u please tell me how to create q queue in JMS and also tell me how to write a program to Send a Static Message for JMS Queue ....please i need it urgently
How to Create Keyboard in JAVA
How to Create Keyboard in JAVA  please help me to create On-Screen Keyboard with java and please give me an another idia to make it ..............iam waiting for your help ,think u so much
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
how to create ipa file
how to create ipa file  Hi, How to .ipa file? Thanks   Hi, Please check the thread Resources have been modified iPhone. Thanks
how to create a table
how to create a table  create table tablename (name varchar(10),name.... Use the following query: create table tablename (name varchar(10),address varchar(10)); For more information, visit the following link: Java Create
how to create uiwebview programmatically
how to create uiwebview programmatically  How to create uiwebview programmatically in iPhone application?   Given is the code that will create the WebView programmatically in iPhone.. CGRect webFrame = CGRectMake(0.0
How To Create a Table.
How To Create a Table.  How To Create a Table?   Hi friends, If you want to create a table, you can run the CREATE TABLE statement..._config.php"; $sql = "CREATE TABLE user_info(" . " id INTEGER NOT NULL" . ", name
How to create charts in Java?
How to create charts in Java?  Is there any example of creating charts and graphs in Java? thanks   Hi, check the tutorial: Chart & Graphs Tutorials in Java Thanks
how to create array in r
how to create array in r  Hi, In R Programming how array is created? how to create array in r? Explain me the process of array creation using.... You can create an array with the help of array keyword. Following is an example
How to create options in HTML
How to create options in HTML  How to create options in HTML? Please guide me.   Create options in HTML Code <tr> <td width="30" valign="middle">Gender:</td> <td><select
how to create vector in r
how to create vector in r  Hi, What is vector in R programming and how to create vector in r? Provide me some of the example code. Thanks   Hi, Vector in R is created using the key c(). Vector contains data of only
how to create interfaces in java
how to create interfaces in java  HI, Here is my code public interface validateInfo { public void validate(String empcode, String password); } class updateInfo implements validateInfo { public void update() { //code
how to create web page on jsp?
how to create web page on jsp?  how to create web page on jsp
how to create reports in swing java?
how to create reports in swing java?  how to create reports in swing java