create dao

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

}

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

}