WeMo Connect

Setup Menus in Admin Panel

First Java Database Program

//STEP 1. Import required packages

import java.sql.*;

public class FirstJavaDB {

   // JDBC driver name and database URL

   static final String JDBC_DRIVER = “com.mysql.jdbc.Driver”

   static final String DB_URL = “jdbc:mysql://localhost:3306/connect”;   // find it in your MAMP

   //  Database credentials

   static final String USER = “techie”;  // get it from MAMP

   static final String PASS = “techie”;

   

   public static void main(String[] args) {

   Connection conn = null;

   Statement stmt = null;

   try{

      //STEP 2: Register JDBC driver

      Class.forName(“com.mysql.jdbc.Driver”);

      //STEP 3: Open a connection

      System.out.println(“Connecting to database…”);

      conn = DriverManager.getConnection(DB_URL,USER,PASS);

      //STEP 4: Execute a query

      System.out.println(“Creating statement…”);

      stmt = conn.createStatement();

      String sql;

      sql = “SELECT id, name, phone, email, skype FROM students”;

      ResultSet rs = stmt.executeQuery(sql);

      System.out.println(” ———————————– “);

      System.out.println(” STUDENTS “);

      System.out.println(” ———————————– “);

      //STEP 5: Extract data from result set

      while(rs.next()){

         //Retrieve by column name

         int id  = rs.getInt(“id”);

         String name = rs.getString(“name”);

         String email = rs.getString(“email”);

         String phone = rs.getString(“phone”);

         String skype = rs.getString(“skype”);

         //Display values

         System.out.printf(“\nID: “ + id +   + name + ” Info: “ + email +   + phone +   + skype);

      }

      //STEP 6: Clean-up environment

      rs.close();

      stmt.close();

      conn.close();

   }catch(SQLException se){

      //Handle errors for JDBC

      se.printStackTrace();

   }catch(Exception e){

      //Handle errors for Class.forName

      e.printStackTrace();

   }finally{

      //finally block used to close resources

      try{

         if(stmt!=null)

            stmt.close();

      }catch(SQLException se2){

      }// nothing we can do

      try{

         if(conn!=null)

            conn.close();

      }catch(SQLException se){

         se.printStackTrace();

      }//end finally try

   }//end try

   System.out.println(“\n\n ———————————– \n\n Thats all folks!”);

}//end main

}//end FirstExample

February 1, 2015

0 Responses on First Java Database Program"

    Leave a Message

    Your email address will not be published. Required fields are marked *