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



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Http Servlet
singleton
0 Answer(s)      2 years and 5 months ago
Posted in : WebSevices


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
import java.util.Scanner;


public class New {

    private static Connection connection = null;  


    public  Connection getConnection()
    {

        try {
            // Load the JDBC driver
            String driverName = "oracle.jdbc.driver.OracleDriver";
            Class.forName(driverName);

            // Create a connection to the database

            String url = "jdbc:oracle:thin:@172.24.137.30:1521:ORA10G" ;
            String username = "e545779";
            String password = "JdyIixugi";
            connection = DriverManager.getConnection(url, username, password);
            System.out.println("hiiiiiiiii");
        } catch (ClassNotFoundException e) {
            // Could not find the database driver
        } catch (SQLException e) {
            // Could not connect to the database
        }


        return connection;


    }   


    private New() {
        super();

    }

    public static  New   empDetails(Connection connection) 
    { 
        try
        {
            String empName;

        int sal,deptId;
        Scanner sc=new Scanner(System.in);
        System.out.println("Enter EmpName");
        empName=sc.next();
        System.out.println("Enter sal");
        sal=sc.nextInt();
        System.out.println("Enter deptId");
        deptId=sc.nextInt();

        Statement st=null;

        st=connection.createStatement();
        ResultSet rs1=st.executeQuery("insert into employee values(emp_seq.nextVal, '"+empName+"',"+sal+","+deptId+")");
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }

        return null;
    } 

    public static void main(String[] args) {


        New n=new New();

        int ch;
        System.out.println("Enter ur choice(1.Add details/2.View Details");
        Scanner sc=new Scanner(System.in);
        ch=sc.nextInt();

                switch(ch)
                {

                        case 1:
                                System.out.println("enter emp details");

                                connection=n.getConnection();
                                empDetails(connection);
                                break;

                        case 2:
                                System.out.println("Enter Emp Id:");
                                break;

                        default:
                                System.out.println("no choice");

                }
        }

}

Advertisement
View Answers

Related Tutorials/Questions & Answers:
singleton class
singleton class  What is singleton class
Java singleton
Java singleton  What is singleton
Advertisements
Singleton in Flex
Singleton in Flex  hi..... please tell me about How can you implement Singleton in Flex Application? please give me the procedure so i can implement....... Thanks
singleton program
singleton program  import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; public class Emp{ public
singleton pattern - Java Beginners
singleton pattern  how i use singleton pattern in my web aplication project.plz give an example.its urgent
Singleton & Threadsafe in struts - Struts
Singleton & Threadsafe in struts  Hi, How to implement singleton and threadsafe in struts . same in jsp and servlet. Thanks in advance
What is singleton? - Java Beginners
What is singleton?   Hi, I want to know more about the singleton in Java. Please explain me what is singleton in Java? Give me example of Singleton class. Thanks   hello, Singleton is a concept in which you
Java Singleton Pattern
In this section, you will learn about singleton pattern in Java
singleton - Java Interview Questions
singleton  what is singleton class.give one example of implementation of singleton class?  hi friend, import java.io.*; public class SingletonExam implements Serializable { public static SingletonExam single
Is Singleton Default in Struts - Struts
Is Singleton Default in Struts   Hi Friend, Is Singleton default in Struts ,or should we force any technique Thanks Prakash  Hi friend, Use of singletons is normally
J2EE Singleton Pattern - Design Pattern Tutorials
J2EE Singleton Pattern Singleton Design Pattern This design pattern governs... only one instance of object is required. The Constructor in a Singleton class is private and a public static method is used to get the Object of the Singleton
singleton class in struts - Java Beginners
singleton class in struts  hi, This balakrishna, I want to retrive data from database on first hit to home page in struts frame work
singleton class in struts - Java Beginners
singleton class in struts  hi, This balakrishna, I want to retrive data from database on first hit to home page in struts frame work
singleton class in struts - Java Beginners
singleton class in struts  hi, This balakrishna, I want to retrive data from database on first hit to home page in struts frame work
singleton class in struts - Java Beginners
singleton class in struts  hi, This balakrishna, I want to retrive data from database on first hit to home page in struts frame work
Singleton class
Singleton class       Singleton Design Pattern: The singleton design pattern allows to have one... be achieved in java by making a Singleton  class Benefits:  Singleton
What is an efficient way to implement a singleton pattern in Java?
What is an efficient way to implement a singleton pattern in Java?  What is an efficient way to implement a singleton pattern in Java
What is difference between singleton and prototype bean?
What is difference between singleton and prototype bean?  Hi, What is difference between singleton and prototype bean? Thanks
How singleton in struts - Java Interview Questions
How singleton in struts  Hi, How to implement singleton and threadsafe in struts . same in jsp and servlet. Thanks Prakash
Why we use singleton class in hibernate sessionfactory?
Why we use singleton class in hibernate sessionfactory?  Hello, Please tell me why we use singleton class in hibernate sessionfactory? hibernate sessionfactory singleton example would be very helpful. Thanks
Singleton Pattern
Singleton Pattern       Singleton Pattern:  The singleton design pattern deals with one... the singleton pattern. But take care to set the variable whenever destroying during
Java singleton program - Java Interview Questions
Java singleton program  Hi All, Can you please explain me in brife with an example how the singleton program works, i did see some documents but was not able to unerstand except one object can be used. this was a java
PHP Singleton Method
PHP Singleton Method: Many application resources are exclusive like database... to a database is exclusive. The singleton pattern is exactly the same, it uses for creating single object. To get an instance of the singleton pattern we must have
where singleton class used in java - Java Interview Questions
where singleton class used in java  where singleton classes are used in j2ee web application.can we use it for connection pooling. Thanks Prakash
Implementing a Serializable Singleton
Implementing a Serializable Singleton       In Singeton classes only one instance will be created. We...;   static SerializableSingleton singleton;  
Singleton Design Pattern
Singleton Design Pattern      ... on a class in java. The Singleton design pattern ensures that only one... to the object and allow multiple instances in the future without affecting a singleton
Creational Design Patterns
Creational Design Patterns           Singleton Pattern The singleton design... of achieving this pattern. Benefits: Singleton pattern controls access
corejava - Java Interview Questions
singleton java implementation  What is Singleton? And how can it get implemented in Java program?  Singleton is used to create only one... in the whole application.Example of Singleton Class in JAVASingleton.java
Java classes
Java classes  What is singleton pattern
core java - Java Interview Questions
core java   how can make a normal class as singleton
Advertisements
 

 

 

DMCA.com