java basics

java basics

Sir i want to searching through name and id in java. and i want to show all the record(like father`s name, date of joining, maid add and mobile no. etc) of particular employee by choosing id and name

View Answers

November 3, 2011 at 12:15 PM

import java.sql.*;
import java.util.*;

class RetrieveData 
{
    public static void main(String[] args) throws Exception
    {
        Scanner input=new Scanner(System.in);
        System.out.print("Enter id: ");
        int id=input.nextInt();

        System.out.print("Enter Name: ");
        String name=input.next();

        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
        Statement st=conn.createStatement();
        ResultSet rs=st.executeQuery("select * from data where id="+id+" and name='"+name+"'");

        if(rs.next()){
            String fname=rs.getString("fatherName");
            String date=rs.getString("dateOfJoining");
            String address=rs.getString("address");
            String mobile=rs.getString("mobile");
            System.out.println("Father's Name: "+fname); 
            System.out.println("Date of joining: "+date);
            System.out.println("Address: "+address);
            System.out.println("Mobile No: "+mobile);
        }
    }
}









Related Tutorials/Questions & Answers:
Java basics
Java basics  Which is not Object in Java
java basics
java basics  Is there any difference between Execution Engine and the JIT in java
Advertisements
Java basics
Java basics  Why Java is not purely object oriented
java basics
java basics  What is composition
java basics
java basics  What is a package
java basics
java basics  What is Locale
java basics
java basics  What do you mean by a Classloader?  The Java Classloader is a part of the Java Runtime Environment that dynamically loads Java classes into the Java Virtual Machine
java basics
java basics  What is the use of prepared-statement
java basics
java basics  Can an Interface be final
Java basics
Java basics  What is the difference between this() and super
Java basics
Java basics  What is the preferred size of a component
java-basics
java-basics  What are methods and how are they defined
Java basics
Java basics  Differences between applications and applets
java basics
java basics  What is a void return type
java basics
java basics  What is skeleton and stub
Java basics
Java basics  Explain about Initialization Blocks
Java basics
Java basics  When is static variable loaded
Java basics
Java basics  Why only one Class is public in one file
java basics
java basics  What is a local, member and a class variable
Java basics
Java basics  Can we create an object for an interface
Java basics
Java basics  What do you mean by Legacy class
java basics
java basics  how to show all the decimal places in a double value
java-basics
java-basics  please tell me, what is the Difference between JRE,JVM and JDK?  hi, JDK or the Java Development Kit is a set tools include compiler (javac.exe), Java application launcher (java.exe), Appletviewer
java basics
java basics  Write a java program to calculate the sum of the series as given below: 1 - 2 + 3 - 4 + 5 - 6 + 7 - 8 + 9
java basics
java basics  What is a native method?  The Java native method is a great way to gain and merge the power of C or C++ programming into Java. To use Java as a scientific and high performance language, when efficient
JAVA Basics
JAVA Basics  What is byte code?  Java programs are compiled and compiler generate a class files which contain byte codes. These byte codes can be run in any platform which makes java platform independent language
java basics
java basics  What is a hashCode?  Objects in Java have hashcodes associated with them. Object's hashcode is a signed number that identifies the object, but it is not unique for every object
java basics
java basics  What is an applet?  An applet is a program written in the Java programming language that can be included in an HTML page, much in the same way an image is included in a page. When you use a Java
java basics
java basics  What are the different driver types available in JDBC... Java driver, also called Type 2. JDBC-Net, pure Java driver, also called Type 3. Native-protocol, pure Java driver, also called Type 4
java basics
java basics  What are the implicit packages that need not get imported into a class file
java-basics
java-basics  hi anybody tell me, JVM is a compiler or an interpreter?  JVM is not a compiler, it is a interpreter
java basics
java basics  What is finalize() method ?  The java run time calls that method whenever it is about to recycle an object of that class. The intent is for finalize() to release system resources such as open files
java basics
java basics  difference between an argument and a parameter?  parameters are passed to the method at the time of defining the method but arguments are passed at the time of calling that method
JAVA Basics
JAVA Basics  What is the byte range?  We can find the range as 2^8=256, so The range of the byte is -128 to 127
java basics
java basics  null is a keyword or not in java?  null might seem like keywords, but they are actually literals; you cannot use them as identifiers in your programs.null keyword in java programming language is a reserved
java-basics
java-basics  dear sir, What is the range of the char type?   The range of the char is calculated as 2^16-1. according this the range of char is 0 to 65536
java basics
java basics  What is garbage collection?  garbage collection is a process by which jvm implicitly or we can call the method explicitly garbageCollector() which deallocate the declared object when there reference becomes
java-basics
java-basics  hi,tell me what is the JIT and usage of it?  The just-in-time compiler compiles byte code into native machine language.Java programs compiled by a JIT generally run much faster than when the bytecode
java-basics
java-basics  hi,anybody tell me What is the use of bin and lib in JDK?  Lib contains all packages and variables.Data types,Variables and Arrays.and Bin contains all tools such as javac, applet viewer, awt tool etc
java basics
java basics  What is an Object and how to allocate memory?  Object is an instance of a class and it is a software unit that combines a structured set of data with a set of operations for inspecting and manipulating
java basics
java basics  What is the use of transient keyword?  The transient keyword is applicable to the member variables of a class. The transient keyword is used to indicate that the member variable should not be serialized
java basics
java basics  What is the difference between Assignment and Initialization?  Initialization means whenever we initialize any var. at declaration time. int i = 0; is an initialization Assignment means whenever we
java-basics
java-basics  hi, tell me the difference between Procedural and OOPs?  The focus of procedural programming is to creates a step by step program that guides the application through a sequence of instructions. whereas
java basics
java basics  What are wrapper classes?  When we need to store primitive datatypes as objects, we use wrapper classes. Wrapper class... as a Boolean class instance. All of the primitive wrapper classes in Java
java basics
java basics  What is Class.forName() does and how it is useful?  Class.forName()- It is mainly used to load the classes at run time when you are not able to decide which class to load, which may depend on some
java basics
java basics  What is inner class?  Inner classes are essentially classes defined inside other classes and act like members of the enclosing class. There are two varieties of inner classes, static inner classes and non
java basics
java basics  What is meant by Inheritance and what are its advantages?  Inheritance is the relationship among classes, in which one class can use the structure or behavior of one or more classes. The class which inherit
java basics
java basics  What is the difference between superclass and subclass?  The class which inherit the property of another class is known as "subclass" and the class who shares it's structure and behavior is called as "super
java basics
java basics  Sir i want to searching through name and id in java. and i want to show all the record(like father`s name, date of joining, maid add and mobile no. etc) of particular employee by choosing id and name   
java basics
java basics  What is the difference between interface and abstract class?  Interface- Interfaces are syntactically similar to classes but they don't have instance variables and methods are declared without any body

Ads