How to manipulate a MaxDB Database using JDBC - Part 2

[Former Member]

How to manipulate a MaxDB Database using JDBC - Part 2

In my previous weblog a simple MaxDB database access using the JDBC Interface was discussed. This weblog discusses the same but shows how more than one query can be used in a JDBC code, creating tables in MaxDB using JDBC, inserting values into tables, executing queries on them to produce desirable output and finally deleting tables.

The below links will be useful to learn more about the JDBC and MaxDB
MaxDB Documentation
JDBC Technology

Creating a Table and Inserting values into them

The command executeUpdate() can be used to perform the manipulation tasks like Create, Insert, Drop etc. The below code explains how we can create a table, insert values into it. Then as discussed before a Select query is executed to show the data present in the table.

import java.io.*;import java.sql.*;public class MaxDBJDBC2{ public static void main(java.lang.String[] args)  { try  {  // This is where we load the driver  Class.forName("com.sap.dbtech.jdbc.DriverSapDB");  System.out.println("The Driver has been loaded"); }  catch (ClassNotFoundException e)  {  System.out.println("Unable to load Driver Class");  return; } try  {     // All database access is within a try/catch block. Connect to database,  // specifying particular database, username, and password  // required connection parameters  String  Server = "localhost",Database="KATHIR",User="DBA",Password="maxdb";      // get connection  Connection con = DriverManager.getConnection ("jdbc:sapdb://" + Server + "/" +  Database, User, Password);    // Create and execute an SQL Statement  Statement stmt = con.createStatement(  );  System.out.println("The con value is:" + con);  ResultSet rs = null;  //Creating a table   stmt.executeUpdate("create table access( id fixed(4), name char(10), per boolean)");  System.out.println("The Table Access is created!");  //Inserting a record into the table   stmt.executeUpdate("insert into access values ('1' , 'Anand' , true)");  System.out.println("One record successfully inserted into table Access!");    //Inserting a record into the table  stmt.executeUpdate("insert into access values ('2' , 'Ashok' , false)");  System.out.println("One record successfully inserted into table Access!");  // Display the contents available in the table  System.out.println("\n\n Displaying the contents of the table Access!");  stmt.executeQuery("select * from access");  rs = stmt.getResultSet();  // Looping through the ResultSet and printing  while(rs.next(  ))   {   System.out.println(rs.getString (1) +"\t"+ rs.getString(2)+"\t"+ rs.getString(3));  }   // Make sure our database resources are released  rs.close(  );  stmt.close(  );  con.close(  );      }      catch (SQLException se)  {       // Inform user of any SQL errors       System.out.println("Error in establishing the connection");       System.out.println(se);      }     } }

Creating, Inserting, and Deleting tables

The next task is to delete a table that is present in the database. As discussed before the same can be achieved using the executeUpdate() method. The below program is one full cycle from a table creation, inserting values, quering on the same and finally deleting the database table.

import java.io.*;import java.sql.*;public class MaxDBJDBC2{ public static void main(java.lang.String[] args)  { try  {  // This is where we load the driver  Class.forName("com.sap.dbtech.jdbc.DriverSapDB");  System.out.println("The Driver has been loaded"); }  catch (ClassNotFoundException e)  {  System.out.println("Unable to load Driver Class");  return; } try  {     // All database access is within a try/catch block. Connect to database,  // specifying particular database, username, and password  // required connection parameters  String  Server = "localhost",Database="KATHIR",User="DBA",Password="maxdb";      // get connection  Connection con = DriverManager.getConnection ("jdbc:sapdb://" + Server + "/" +  Database, User, Password);    // Create and execute an SQL Statement  Statement stmt = con.createStatement(  );  System.out.println("The con value is:" + con);  ResultSet rs = null;  //Creating a table   stmt.executeUpdate("create table access( id fixed(4), name char(10), per boolean)");  System.out.println("The Table Access is created!");  //Inserting a record into the table   stmt.executeUpdate("insert into access values ('1' , 'Anand' , true)");  System.out.println("One record successfully inserted into table Access!");    //Inserting a record into the table  stmt.executeUpdate("insert into access values ('2' , 'Ashok' , false)");  System.out.println("One record successfully inserted into table Access!");  // Display the contents available in the table  System.out.println("\n\n Displaying the contents of the table Access!");  stmt.executeQuery("select * from access");  rs = stmt.getResultSet();  // Looping through the ResultSet and printing  while(rs.next(  ))   {   System.out.println(rs.getString (1) +"\t"+ rs.getString(2)+"\t"+ rs.getString(3));  }   // Deleting a created database  stmt.executeUpdate("drop table access");  System.out.println("The table Access has been deleted");  // Make sure our database resources are released  rs.close(  );  stmt.close(  );  con.close(  );      }      catch (SQLException se)  {       // Inform user of any SQL errors       System.out.println("Error in establishing the connection");       System.out.println(se);      }     } }