Monday, June 17, 2013

Get Connected with DERBY database (Network Server Mode).

Connect with Apache Derby Network Server

Apache Derby, an is an open source relational database implemented entirely in Java. 
Refer http://db.apache.org/derby/

  • Start Apache Derby Network Server
Run "startNetworkServer" Batch file to start Apache Derby Network Server.
(You can find this batch file at "C:\Program Files\Java\jdk1.7.0_21\db\bin\")
cmd prompt appears like this
(Server runs on port 1527 and  i created database in E: drive refer DerbyTest.java)
Tue Jun 18 11:16:47 IST 2013 : Security manager installed using the Basic server

security policy.

Tue Jun 18 11:16:59 IST 2013 : Apache Derby Network Server - 10.8.2.2 - (1181258

) started and ready to accept connections on port 1527

  • create a java class to connect to database and get records

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class DerbyTest {
  private Connection connect = null;
  private Statement statement = null;
  private ResultSet resultSet = null;

  public DerbyTest() throws Exception {
    try {

      Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
      connect = DriverManager
          .getConnection("jdbc:derby:e:/mydb");
      PreparedStatement statement = connect
          .prepareStatement("SELECT * FROM MYTABLE");

      resultSet = statement.executeQuery();
      while (resultSet.next()) {
        String id = resultSet.getString("ID");
        String name = resultSet.getString("NAME");
        System.out.println("ID: " + id);
        System.out.println("NAME: " + name);
      }
    } catch (Exception e) {
      throw e;
    } finally {
      close();
    }

  }

  private void close() {
    try {
      if (resultSet != null) {
        resultSet.close();
      }
      if (statement != null) {
        statement.close();
      }
      if (connect != null) {
        connect.close();
      }
    } catch (Exception e) {

    }
  }

  public static void main(String[] args) throws Exception {
    DerbyTest dao = new DerbyTest();
  }

} 



  • Compile  DerbyTest.java

  •  E:/>javac DerbyTest.java



  • Run

  •  E:/>java DerbyTest



  • You will Get output as

  • table ctreated.....
    records inserted sucessfully ......ID: 10
    NAME: java
    ID: 20
    NAME: derby
    ID: 30
    NAME: oracle
    

    Saturday, June 15, 2013

    Get Connected with DERBY database(Embedded Mode).

    First crate a Database in Derby

    Derby

    Apache Derby, an is an open source relational database implemented entirely in Java. 
    Refer http://db.apache.org/derby/
                  
    (I used windows as operating system and created database in my "E" drive)
    Open Command Prompt(Run => cmd)
    • Run Derby ij Toll
     E:\>java -jar "C:\Program Files\Java\jdk1.7.0_21\db\lib\derbyrun.jar" ij
    
    • Create a Data Base (I named it as 'mydb')
    ij> CONNECT 'jdbc:derby:mydb;create=true';





  • Create table 'mytable'

  • ij> create table mytable (
    > ID int,
    > NAME varchar(15));
    0 rows inserted/updated/deleted





  • Insert Records into 'mytable'

  • ij>INSERT INTO MYTABLE VALUES 
    (001 , 'JAVA'), (002, 'Derby'), (003, 'Database');
    3 rows inserted/updated/deleted





  • Create a java class to Connect to Database and Get records

  • import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.Statement;
    
    public class DerbyTest {
      private Connection connect = null;
      private Statement statement = null;
      private ResultSet resultSet = null;
    
      public DerbyTest() throws Exception {
        try {
    
          Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
          connect = DriverManager
              .getConnection("jdbc:derby:e:/mydb");
          PreparedStatement statement = connect
              .prepareStatement("SELECT * FROM MYTABLE");
    
          resultSet = statement.executeQuery();
          while (resultSet.next()) {
            String id = resultSet.getString("ID");
            String name = resultSet.getString("NAME");
            System.out.println("ID: " + id);
            System.out.println("NAME: " + name);
          }
        } catch (Exception e) {
          throw e;
        } finally {
          close();
        }
    
      }
    
      private void close() {
        try {
          if (resultSet != null) {
            resultSet.close();
          }
          if (statement != null) {
            statement.close();
          }
          if (connect != null) {
            connect.close();
          }
        } catch (Exception e) {
    
        }
      }
    
      public static void main(String[] args) throws Exception {
        DerbyTest dao = new DerbyTest();
      }
    
    } 

  • Compile  DerbyTest.java
  •  E:/>javac DerbyTest.java

  • Run
  •  E:/>java DerbyTest

  • You will Get output as

  • ID: 1
    NAME: JAVA
    ID: 2
    NAME: Derby
    ID: 3
    NAME: Database
    

    Thursday, June 13, 2013

    Getting Started with Struts 2 framework with very few steps in eclipse.

    With Apache Structs 2 frame work you can develop flexible web applications faster and easier.  you can start learning by creating a simple Struts 2 Hello world example project in eclipse and hence can understand how struts 2 framework works. To start learning Struts 2 you need little knowledge on basic Java programming, XML and JSP. Then you can follow very simple baby steps to start playing with struts 2 frame work. 

    Prerequirements.
    Struts 2 requires Servlet API 2.4 or higher, JSP 2.0 or higher, and Java 5 or higher.


    Step 1

    Download latest version of Struts 2 full distribution package  from Apache Struts web site 
    Extract the archive after downloading. 

    Step 2 

    Open eclipse 
    I reccomend to use latest version of  Eclipse for Java EE developers 


    Step 3

    Import A Blank Struts 2 Project into eclipse workplace.
    File>Import>war file
    In downloaded struts 2 package open apps folder there you find some thing like Struts2-blank.war
    import it into eclipse. 

    Step 4 

    Important:       (Assumed that you have configured a web server in eclipse)
    right click on project
    Run>Run on Server. 

    Now you have run your first Struts 2 application in eclipse. now let us know how it works and make some Hello World Program our self.