Techalert

Best Java Web Development Framework for 2015

<div dir="ltr" style="text-align: left;" trbidi="on">
Java programming language was originally developed by Sun Microsystems which was initiated by James Gosling and released in 1995 as core component of Sun Microsystems’ Java platform (Java 1.0 [J2SE]). 
 
Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. 
 
Sun Microsystems has renamed the new J2 versions as Java SE, Java EE and Java ME respectively. Java is guaranteed to be Write Once, Run Anywhere. 
 
Java is: Object Oriented, Platform independent, Simple, Secure, Architectural-neutral, Portable, Robust, Multithreaded, Interpreted, High Performance, Distributed and Dynamic. 
 
There are a majority of enterprises running Java applications and working on Java web development framework. What remains to be seen is that a number of companies are tied to the conventional webdevelopment framework and haven’t actually started to anticipate what could be the best Java webdevelopment framework. Even the JavaOne might hold no unified voice for what web framework is best. 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-dLCpjQnm22rQFvWDbSNjQngaB3kTXGAI3xXPtswIDMOZUkgHTJSM1okRk_-g74tcnD0nRwTZSAmn2dckQmhmyXng4RjHsGhfxw3xdRTh0J4Bse4vaiMU05RzKGYa-WxY88sBi-6u7Q/s1600/java-framework.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="java framework" border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-dLCpjQnm22rQFvWDbSNjQngaB3kTXGAI3xXPtswIDMOZUkgHTJSM1okRk_-g74tcnD0nRwTZSAmn2dckQmhmyXng4RjHsGhfxw3xdRTh0J4Bse4vaiMU05RzKGYa-WxY88sBi-6u7Q/s1600/java-framework.jpg" title="java framework" width="550" /></a></div>
 
There are several easy to use Java web frameworks that are out now a days, and they are too many. Essentially choosing the best web development framework has become more intricate, specifically due to three reasons. On a broader perspective, the web technology landscape has undergone a sea change; far more choice of technology; and changing requirements for modern web applications. 
 
No framework is perfect, they all have their merits and they all have their breaking points. There is not a single web framework out there that will work for all requirements out there, still there could be found arguments why one framework is better than others and for what types of applications. 
<div>
 
So let’s have a look at most viable Java web frameworks: 
<ul>
<li>Struts 2</li>
<li>JavaServer Faces (JSF)</li>
<li>Spring MVC</li>
<li>Wicket</li>
<li>Stripes</li>
<li>Tapestry</li>
<li>RIFE</li>
<li>Seam</li>
<li>Google Web Toolkit (GWT)</li>
<li>OpenXava</li>
<li>Play Framework</li>
</ul>
 
Hope this article useful for you. Are you favorite Frameworks not in the list? Feel free to mention it in comments below.</div>
</div>

Best Java Web Development Framework for 2015

Java programming language was originally developed by Sun Microsystems which was initiated by James Gosling and released in 1995 as core co...

Core Java Interview Questions and Answers for freshers

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: left;">
Java programming language was originally developed by Sun Microsystems which was initiated by James Gosling and released in 1995 as core component of Sun Microsystems' Java platform (Java 1.0 [J2SE]).</div>
<div class="separator" style="clear: both; text-align: left;">
 </div>
<div class="separator" style="clear: both; text-align: left;">
Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. </div>
<div class="separator" style="clear: both; text-align: left;">
 </div>
<div class="separator" style="clear: both; text-align: left;">
Sun Microsystems has renamed the new J2 versions as Java SE, Java EE and Java ME respectively. Java is guaranteed to be Write Once, Run Anywhere.</div>
<div class="separator" style="clear: both; text-align: left;">
 </div>
<div class="separator" style="clear: both;">
Java is:</div>
<div class="separator" style="clear: both;">
Object Oriented, Platform independent, Simple, Secure, Architectural-neutral, Portable, Robust, Multithreaded, Interpreted, High Performance, Distributed and Dynamic.</div>
<div class="separator" style="clear: both; text-align: left;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9mNg5ejB3cVnbL-DHlLOwwmDKU8gR4dkHpzg8f0B-5xreNNSLYyhHBcqNgMOmdaecVgu84qoxkvmyPjos4rtLnbZ0nUfDcqFOXALgtsWnSZyemJhw9b1hanYpsnstHx5BUfKKkkX7wQ/s1600/java-interview.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Core Java Interview Questions and Answers" border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9mNg5ejB3cVnbL-DHlLOwwmDKU8gR4dkHpzg8f0B-5xreNNSLYyhHBcqNgMOmdaecVgu84qoxkvmyPjos4rtLnbZ0nUfDcqFOXALgtsWnSZyemJhw9b1hanYpsnstHx5BUfKKkkX7wQ/s1600/java-interview.jpg" title="Core Java Interview Questions and Answers" width="550" /></a></div>
<div>
 
<h3 style="text-align: left;">
Core Java Interview Questions and Answers for Freshers and experienced are below are below ::</h3>
</div>
<div>
 </div>
Q: What do you know about Java? 
A: Java is a high-level programming language originally developed by Sun Microsystems and released in 1995. Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. 
<div>
 
Q: What are the supported platforms by Java Programming Language? 
A: Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX/Linux like HP-Unix, Sun Solaris, Redhat Linux, Ubuntu, CentOS, etc. 
 
Q: List two Java IDE’s? 
A: Netbeans, Eclipse, etc. 
 
Q: What do you mean by Object? 
A: Object is a runtime entity and it’s state is stored in fields and behavior is shown via methods. Methods operate on an object's internal state and serve as the primary mechanism for object-to-object communication.</div>
<div>
 
Q: Define class? 
A: A class is a blue print from which individual objects are created. A class can contain fields and methods to describe the behavior of an object. 
<div>
 </div>
<div>
Here listed more ques of Java Language that are ask in Java interview so read all question and their ans carefully.</div>
<div>
 
1. What is JVM? 
• JVM is the acronym stands for 'Java virtual machine'. 
• JVM provides the execution environment. 
• JVM is not platform independent.. 
• JVM is the Java run-time system. 
• JVM is an interpreter of bytecode. 
• JVM also makes the sytem secured. 
 
<div>
2. What is bytecode? 
• Bytecode is an instruction set. 
• Bytecode extends wiith .class. 
• 'javac' compiler translates the .java file into .class. 
• JVM interpretes bytecode. 
• Bytecode facility makes Java platform-independent. 
• It also confirms security tothe Java code. 
 
3.What are the principle concepts of OOPS? 
There are four principle concepts upon which object oriented design and programming rest. </div>
<div>
They are:</div>
<div>
 
Abstraction: Abstraction refers to the act of representing essential features without including the background details or explanations.</div>
<div>
 
Polymorphism: is the ability to create a variable, a function, or an object that has more than one form. 
Inheritance: Inheritance is the process by which objects of one class acquire the properties of objects of another class.</div>
<div>
 
Encapsulation: Encapsulation is a technique used for hiding the properties and behaviors of an object and allowing outside access only as appropriate. It prevents other objects from directly altering or accessing the properties or methods of the encapsulated object. 
What are the basic features of java? 
 
4. The basic features of Java are given below : 
• Java is simple. 
• Java provides immense security. 
• Java provides high portability. 
• Java provides object oriented programming features 
• Java provides robustness. 
• Java is multuthreaded. 
• Java provides architecture neutrality. 
• Java is distributed 
• Java is dynamic. 
 </div>
<div>
5. How java becomes object oriented? 
• Java follows the paradigm of OO programming. 
• Java follows modular approach. 
• Java follows the abstraction aspect. 
• Java follows the OO principle encapsultaion. 
• Java follows the OO principle polymorphism. 
• Java follows the OO principle inheritance. 
 
<div style="text-align: center;">
Also Read: <a href="http://www.itechaleart.com/2014/04/top-50-common-interview-qa.html" style="color: #999999; text-decoration: none;">Top 50 Common Job Interview Questions and answers</a></div>
 </div>
<div>
6.How java becomes robust? 
• Java provides multi-platformed environment. 
• Java provides high reliability in the design. 
• Java is a strictly typed language. 
• Java checks the code at runtime. 
• Java provides predictablity. 
• java provides various keywords. 
 </div>
<div>
7. How a Java program compiles? 
• First the source file name must be extended with .java extension. e.g. Myprog.java 
• Execute the javac compiler. 
• javac compiler creates a file called Myprog.class i.e. the bytecode version of Myprog.java. 
• The butecode is executed by the Java runtime-systems which is called Java Virtual Machine (JVM). 
• JVM is platform dependent. 
 </div>
<div>
8.What is 'public static void main ( String args[ ] ) ' signifies? 
• the access specifier is the 'public' keyword . 
• 'static' keyword allows main() to be called without instantiating a particular instance of a class. 
• 'void' affirns the compiler that no value is returned by main(). 
• 'main()' mathod is called at the beginning of a Java program. 
• 'String args()' tells a parameter named args,which is an instance array of class String 
 </div>
<div>
9. What 'System.out.println()' signifies? 
• 'System' is a predefined class . 
• System class givesacces to the system. 
• 'out' is the output stream. 
• 'println' is printing the line on the console. 
• This is a console output statement. 
 
10. What is Polymorphism? 
The Polymorphism can be referred as one name many forms. It is the ability of methods to behave differently, depending upon the object who is calling it. The key features of Polymorphism are: 
Allows using one interface for multiple implementations. 
Supports Method Overloading: Multiple methods with same name, but different formal argument. 
Supports Method Overridden: Multiple methods have the same name, same return type, and same formal argument list. 
 
<div style="text-align: center;">
Also Read: <a href="http://www.itechaleart.com/2014/05/oops-interview-qa-for-fresher.html" style="color: #999999; text-decoration: none;">OOPs Interview Questions and Answers for Fresher</a></div>
 </div>
<div>
11. What is a variable in Java program? 
• It's a memory location. 
• The memory location is given some name. 
• The memory location is being assigned some value. 
• The value may change of the variable. 
• The memory location size changes with the type of the variable.</div>
<div>
 </div>
<div>
12. What is Java applet? 
• Applet is a java program. 
• It has been designed for transmitting the Java code over the internet. 
• It is automatically executed by Java-enabled Web Browser. 
• Applet can repnse to the user input. 
• Applet is dynamically programmed. <a href="http://www.careerride.com/Career-Jobs-Interview-Updates.aspx"> </a> 
 
13. Explain garbage collection. 
The Java uses the garbage collection to free the memory. By cleaning those objects that is no longer reference by any of the program. Step involve in cleaning up the garbage collection: 
Garbage Object Collection: first step is to collection and group all those object which are no more reference with any of the program. We can use the different methods to collect the garbage object like using runtime.gc() or system.gc(). 
Run Finalize method: To free up those object which is collected by the garbage collector java must execute the Finalize method to delete all those dynamically created object 
 </div>
<div>
14. What is an immutable object? 
An immutable object is one that we cannot change once it is created. Steps involved in creation of an immutable object are: 
Make all of its data fields private. 
Methods which can perform changes in any of the data fields after the construction of object must be avoided. 
 </div>
<div>
15. How are this() and super() used with constructors?</div>
<div>
this() Constructors: is used to pointing the current class instance. 
Can be used with variables or methods. 
Used to call constructer of same class. 
Private variable cannot be accessed using this().</div>
<div>
 
super() Constructer: is used to call constructor of parent class. 
Must be the first statement in the body of constructor. 
Using this we can access private variables in the super class. 
 
<div style="text-align: center;">
Also Read: <a href="http://www.itechaleart.com/2014/06/top-25-qa-interview-qa.html" style="color: #999999; text-decoration: none;">Top 25 QA Interview Questions and Answers</a></div>
 </div>
<div>
16. What are Access Specifiers available in Java? 
Java offers four access specifiers, described below:</div>
<div>
 
Public: public classes, methods, and fields can be accessed by every class. 
Protected: protected methods and fields can only be accessed within the same class to which the methods and fields belong. 
Default (no specifier): when we do not set access to specific level, then such a class, method, or field will be accessible from inside the same package to which the class, method, or field belongs. 
Private: private methods and fields can only be accessed within the same class to which the methods and fields belong. Private methods and fields are not inherited by subclasses. 
 </div>
<div>
17. What is Constructor? 
A constructor is used to initialize a newly created object. 
It is called just after the memory is allocated for the object. 
It can be used to initialize the objects. 
It is not mandatory to write a constructor for the class. 
Name of constructor is same as the class name. 
Cannot be inherited. 
Constructor is invoked whenever an object of its associated class is created.</div>
<div>
 </div>
<div>
18. Explain the user defined Exceptions. 
User Defined Exceptions are exceptions defined by the user for specific purposed. This allows custom exceptions to be generated and caught in the same way as normal exceptions. While defining a User Defined Exception, we need to take care of the following aspects: 
It should be extend from Exception class. 
Use toString() method to display information about the exception. 
 </div>
<div>
19. Describe life cycle of thread. 
Threads follow the single flow of control. A thread is execution in a program. </div>
<div>
The life cycles of threads are listed below: 
Newborn state: After the creations of Thread instance the thread is in this state but before the start() method invocation. Thread is considered not alive in this phase. 
Runnable state: A thread starts its life from Runnable state. After the invoking of start() method thread enters Runnable state. 
Running state: A thread first enters Runnable state. 
Blocked state: A thread can enter in this state because of waiting the resources that are hold by another thread. 
Dead state: A thread can be considered dead when its run() method completes. If any thread comes on this state that means it cannot ever run again. 
 </div>
<div>
20. What is an Applets? 
Applets: These are small java programs. 
They can send from one computer to another computer over the internet using the Applet Viewer that supports java. 
Applets can runs in a Web browser as it is a java program. It can be a fully functional Java application because it has the entire Java API at its disposal. 
Applets follow the security rules given by the Web browser. 
Applet security is also known as sandbox security.</div>
<div>
 
<div style="text-align: center;">
Also Read: <a href="http://www.itechaleart.com/2014/07/jsp-interview-qa.html" style="color: #999999; text-decoration: none;">Top 20 JSP Interview Questions and Answers</a></div>
 
21. What is the Set interface? 
A Set interface is collection of element which cannot be duplicated. 
The Set interface contains methods inherited from collection. 
It provides methods to access the elements of a finite mathematical set. 
Two Set objects are equal if they contain the same elements. 
It models the mathematical set abstraction. 
 </div>
<div>
22. What is a HashSet and TreeSet? 
The HashSet is an unsorted, unordered Set. 
It is Collection set that restrict duplicate elements and also repositioning of elements. 
It implements the Set interface and extends AbstractSet. 
Uses hash code of the object being inserted. 
The TreeSet is a Set implemented when we want elements in a sorted order. 
Sorting of element is done according to the natural order of elements or by the help of comparator provided at creation time. 
 </div>
<div>
23. How do you decide when to use HashMap and when to use TreeMap and what is difference between these two? 
HashMap is used when we want to perform insertion, deletion, and locate elements in a Map. 
 
TreeMap is used when we want to traverse the elements in a sorted order. Depending upon the size of collection, adding elements to HashMap is easy. For sorted elements traversal we can convert the HashMAp into TreeMap. 
 
HashMap: 
Lets us to have null values and also one null key 
Iterator in the HashMap is Fail-Safe. 
It is Unsynchronized. 
 
HashTable: 
It does not allow null value as key and value. 
It is not synchronized. 
 </div>
<div>
24. What is the Comparable interface? 
The Comparable interface is used to sort collections and arrays of objects using the collections.sort() and java.utils. The objects of the class implementing the Comparable interface can be ordered. All classes implementing the Comparable interface must implement the compareTo() method that has the return type as an integer. The signature of the compareTo() method is as follows: 
 
int i = object1.compareTo(object2) 
If object1 < object2: The value of i returned will be negative. 
If object1 > object2: The value of i returned will be positive. 
If object1 = object2: The value of i returned will be zero. 
When should I use abstract classes and when should I use interfaces? 
 
Use Interface, when: 
Design changing frequently or when various implementations only share method signatures. 
We need some classes to use some methods which we do not want to be included in the class. 
 
Use Abstract Class, when: 
Various implementations are of the same kind and use common behavior. 
Enabling with generalized form of abstraction and leave the implementation task with the inheriting subclass. 
creating planned inheritance hierarchies 
Explain the Polymorphism principle. 
 
The Polymorphism can be referred as one name many forms. It is the ability of methods to behave differently, depending upon the object who is calling it. Polymorphism exists in three distinct forms in Java: 
Method overloading 
Method overriding through inheritance 
Method overriding through the Java interface 
 
<div style="text-align: center;">
Also Read: <a href="http://www.itechaleart.com/2014/06/ruby-language-interviews-qa.html" style="color: #999999; text-decoration: none;">Top Ruby Language Interview Questions and Answers</a></div>
 </div>
<div>
25. What are the difference between throw and throws? 
The differences are between throw and throws are: 
Throw is used to trigger an exception where as throws is used in declaration of exception. 
Without throws, Checked exception cannot be handled where as checked exception can be propagated with throws. 
Throw is used inside the method where as throws is used with the method signature. 
Throw is followed by an instance but throws is followed by class. 
 </div>
<div>
26. What is difference between preemptive scheduling and time slicing? 
Differences between preemptive and time scheduling are: 
In Preemptive scheduling the highest priority task executes until it enters the waiting or dead stated or a higher priority task comes into existence. 
Time slicing, a task executes for a predefined time period and then the pool of ready tasks. The scheduler then determines which task should execute next, based on priority and other factor. 
 </div>
<div>
27. Explain traversing through a collector using Iterator. 
Ans. We can access each element in the Collection by using Iterators irrespective of how they are organized in the collector. Iterator can be implemented a different way for every Collection. To use an iterator to traverse through the contents of a collection we do: 
Obtain an iterator by calling the collections iterator()method to the start of the collection. 
Set up a loop that makes a call to hasNext(). Have the loop iterate as long as hasNext()returns true. 
Within the loop, obtain each element by calling next(). 
remove() method is used to remove the current element in the iteration.</div>
<div>
 </div>
<div>
28. What are the List interface and its main implementation? 
The List helps in collections of objects. Lists may contain duplicate elements. The main implementations of the List interface are as follows: 
ArrayList: Resizable-array implementation of the List interface. 
Vector: Synchronized resizable-array implementation of the List. 
LinkedList: Doubly-linked list implementation of the List interface. Better performance than the ArrayList implementation when elements are inserted or deleted timely.</div>
</div>
</div>
</div>

Core Java Interview Questions and Answers for freshers

Java programming language was originally developed by Sun Microsystems which was initiated by James Gosling and released in 1995 as core ...

Java Database Connectivity – MySQL, Oracle and SQLite

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" width="319" /></a></div>
I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection setup code with the world.</div>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
You will need to download and add the appropriate JARs to your project and or your class path, as well as having a database to connect to, unless you are using SQLite in which case the database is local.</div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
MySQL</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
First up is MySQL connectivity. This first snippet will check you have loaded the JDBC driver correctly.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.*;
public class MySqlLoadDriver {
 public static void main(String [] args) {
 Connection con = null;
 try {

// Load the MySQL JDBC driver
 Class.forName("com.mysql.jdbc.Driver") ;
 System.out.println("MySQL JDBC driver loaded ok.");

} catch (Exception e) {
 System.err.println("Exception: "+e.getMessage());
 }
 }
}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
The following snippet will set up a connection to the database. Where the host in the example is set to localhost so you may change this to point to your database address or tunnel in to your database using a client like Putty. Also change username and password to your database username and password.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class SimpleConnection;
{

static public void main(String args[])
 {

Class.forName("com.mysql.jdbc.Driver") ;
 System.out.println("MySQL JDBC driver loaded ok.");
 con = DriverManager.getConnection(
 "jdbc:mysql://127.0.0.1:3306/","username", "password");
 System.out.println("Connected with host:port/database.");
 con.close();

}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
 </div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
Oracle</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Oracle has a two types of connection I have played with Oracle Call Interface and Oracle’s JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle’s SQL*Net protocol. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser. Depending on which one you want to use comment out or delete the other line. In the example I am using the OJDBC Thin Driver not the Oracle Call Interface.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

{
 Connection con = null;

try
 {
 Class.forName ("oracle.jdbc.OracleDriver");
 System.out.println("Oracle JDBC driver loaded ok.");
 con = DriverManager.getConnection(

//"jdbc:oracle:oci7:@//localhost:1521/ORCL","username", "password");
 "jdbc:oracle:thin:@//192.168.104.11:1521/ORCL","username", "password");
 System.out.println("Success!!");
 System.out.println("Connected with host:port/database.");
 con.close();
 }
 catch (Exception e)
 {
 System.err.println("Exception: "+e.getMessage());
 }
 }
}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
 </div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
SQLite</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Finally the creation and testing of an SQLite Database, adding in a few things with a simple query.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.*;

public static void main(String[] args) throws Exception {

Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
 Statement stat = conn.createStatement();
 stat.executeUpdate("drop table if exists people;");
 stat.executeUpdate("create table people (name, occupation);");
 PreparedStatement prep = conn.prepareStatement("insert into people values (?, ?);");
 prep.setString(1, "Gandhi");
 prep.setString(2, "politics");
 prep.addBatch();
 prep.setString(1, "Turing");
 prep.setString(2, "computers");
 prep.addBatch();
 prep.setString(1, "Wittgenstein");
 prep.setString(2, "smartypants");
 prep.addBatch();
 conn.setAutoCommit(false);
 prep.executeBatch();
 conn.setAutoCommit(true);
 ResultSet rs = stat.executeQuery("select * from people;");

while (rs.next()) {
 System.out.println("name = " + rs.getString("name"));
 System.out.println("job = " + rs.getString("occupation"));
 }

rs.close();
 conn.close();

Java Database Connectivity – MySQL, Oracle and SQLite

I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection s...

Top 20 J2EE Interview Questions and Answers

Best Java Web Development Framework for 2015

Top 20 JSP Interview Questions and Answers

Core Java Interview Questions and Answers for freshers

Java Database Connectivity – MySQL, Oracle and SQLite