SQL(snap).com

Follow SQL(snap) on Twitter

SQL(snap) is a rapid development engine that generates JDBC code with just a few clicks. SQL(snap) removes the complexity and tediousness of working with embedded SQL and speeds JDBC related development. more...

Browse and query all databases in your enterprise
Click-to-create automated query tool
Export data to CSV function
Single user
More info...

$FREE.00

Single User
Browse and query all databases in your enterprise
Click-to-create automated query tool
Export data to CSV function
1-Click JDBC code generation
More info...

$199.00

Site License for 1 server with unlimited users
Browse and query all databases in your enterprise
Click-to-create automated query tool
Export data to CSV function
1-Click JDBC code generation
More info...

$899.00

Panel 2 Panel 3 Panel 4

/*
// package com.your.code;  
// change the above to reflect your package.  
/** 
 * SQL(snap) for Java - Pinch Hitter Solutions (2008)  
 * Connecting to Database Reference: MySQL DB 
 * Database Type: MySQL 
 * SQL Statement:  
 *  SELECT T1.custnbr, T1.lname, T1.fname, T1.custaddr1, T1.custaddr2,  
 *  T1.custcity, T1.custstate, T1.custzip, T1.custphone FROM  
 *  snap.customers T1 WHERE T1.custcity= 'orlando' 
 * Java Class Name: $customers 
 * This source MUST be in a file called $customers.java 
 */ 
   
import java.sql.*; 
import java.math.BigDecimal; 
   
/** 
 * The methods below provide processing templates to be  
 * reused in your classes.  
 * Processing steps are as follows:  
 * 1. Create Connection Object - getConnection()  
 * 2. Run Insert - runInsert()  
 * 3. Run Update - runUpdate()  
 * 4. Run Delete - runDelete()  
 * 4. Run Query - runQuery()  
 */ 
public class $customers { 
   
  private Connection con; 
   
 // Global work variables for the query result-set. 
    int custnbr; 
    String lname; 
    String fname; 
    String custaddr1; 
    String custaddr2; 
    String custcity; 
    String custstate; 
    String custzip; 
    String custphone; 
   
    /** 
     * Default constructor  
     */ 
     public $customers() { 
   
    } 
   
    /** 
     * getConnection() - get the connection object for this class.  
     */ 
     public Connection getConnection() throws SQLException, ClassNotFoundException { 
   
      if (con == null) {  
        String user = ""; // Enter the user ID here. 
        String password = ""; // Enter the password here. 
        String url = "jdbc:mysql://phs2003:3306/"; 
        Class.forName("com.mysql.jdbc.Driver"); 
        con = DriverManager.getConnection(url, user, password); 
      } 
   
      return con; 
   
    } 
   
   
    /** 
     * runQuery() - run query in line (include your logic here).  
     * Build prepared statement using query from SQL(snap) client.  
     */ 
     public void runQuery() throws SQLException { 
     
      PreparedStatement prepStmt = con.prepareStatement(  
      "SELECT T1.custnbr, T1.lname, T1.fname, T1.custaddr1, T1.custaddr2, " + 
      "T1.custcity, T1.custstate, T1.custzip, T1.custphone FROM " + 
      "snap.customers T1 WHERE T1.custcity= ?"); 
   
      // Fields ending with underscore are parameter fields. 
      // Load parameter fields at runtime with your own values. 
      String custcity_ ="orlando"; 
   
      // Set parameters by relative placement of question marks. 
      prepStmt.setString(1,custcity_); 
   
      ResultSet rs = prepStmt.executeQuery(); 
   
       while(rs.next()) { 
        custnbr = rs.getInt("custnbr"); 
        lname = rs.getString("lname"); 
        fname = rs.getString("fname"); 
        custaddr1 = rs.getString("custaddr1"); 
        custaddr2 = rs.getString("custaddr2"); 
        custcity = rs.getString("custcity"); 
        custstate = rs.getString("custstate"); 
        custzip = rs.getString("custzip"); 
        custphone = rs.getString("custphone"); 
   
        // place your logic here or copy this code to another class. 
   
      } 
     
      rs.close(); 
      prepStmt.close(); 
    } 
    /** 
     * runInsert() - Use this code to insert rows.  
     * Build prepared insert statement based on table name used in query. 
     */ 
    public void runInsert() throws SQLException { 
   
      // Load your insert values here... 
      int custnbr_ =0; 
      String lname_ =""; 
      String fname_ =""; 
      String custaddr1_ =""; 
      String custaddr2_ =""; 
      String custcity_ =""; 
      String custstate_ =""; 
      String custzip_ =""; 
      String custphone_ =""; 
   
      PreparedStatement prepStmt = con.prepareStatement( 
      "INSERT INTO snap.customers(" 
      + "custnbr," 
      + "lname," 
      + "fname," 
      + "custaddr1," 
      + "custaddr2," 
      + "custcity," 
      + "custstate," 
      + "custzip," 
      + "custphone)" 
      + "VALUES(?,?,?,?,?,?,?,?,?)"); 
   
      prepStmt.setInt(1,custnbr_); 
      prepStmt.setString(2,lname_); 
      prepStmt.setString(3,fname_); 
      prepStmt.setString(4,custaddr1_); 
      prepStmt.setString(5,custaddr2_); 
      prepStmt.setString(6,custcity_); 
      prepStmt.setString(7,custstate_); 
      prepStmt.setString(8,custzip_); 
      prepStmt.setString(9,custphone_); 
   
      prepStmt.executeUpdate(); 
   
      prepStmt.close(); 
     
    } 
    /** 
     * runUpdate() - Use this code to update rows.  
     * Build prepared update statement based on table name used in query. 
     */ 
    public void runUpdate() throws SQLException { 
   
      // Load your update values here... 
      int custnbr_ =0; 
      String lname_ =""; 
      String fname_ =""; 
      String custaddr1_ =""; 
      String custaddr2_ =""; 
      String custcity_ =""; 
      String custstate_ =""; 
      String custzip_ =""; 
      String custphone_ =""; 
   
      PreparedStatement prepStmt = con.prepareStatement( 
      "UPDATE snap.customers SET" 
      + "custnbr= ?, " 
      + "lname= ?, " 
      + "fname= ?, " 
      + "custaddr1= ?, " 
      + "custaddr2= ?, " 
      + "custcity= ?, " 
      + "custstate= ?, " 
      + "custzip= ?, " 
      + "custphone = ? " 
      + "WHERE ...place where clause here.."); 
   
      prepStmt.setInt(1,custnbr_); 
      prepStmt.setString(2,lname_); 
      prepStmt.setString(3,fname_); 
      prepStmt.setString(4,custaddr1_); 
      prepStmt.setString(5,custaddr2_); 
      prepStmt.setString(6,custcity_); 
      prepStmt.setString(7,custstate_); 
      prepStmt.setString(8,custzip_); 
      prepStmt.setString(9,custphone_); 
   
      prepStmt.executeUpdate(); 
   
      prepStmt.close(); 
     
    } 
    /** 
     * runDelete() - Use this code to delete rows.  
     * Build prepared delete statement based on table name used in query. 
     */ 
    public void runDelete() throws SQLException { 
   
      PreparedStatement prepStmt = con.prepareStatement( 
      "DELETE FROM snap.customers "  
      + "WHERE ...place where clause here.."); 
   
      prepStmt.executeUpdate(); 
   
      prepStmt.close(); 
     
    } 
   
    /** 
     * main() - Use this method to test the above methods.  
     */ 
    public static void main(String args[]) { 
   
      try { 
        $customers instance = new $customers(); 
        instance.getConnection();  
        // instance.runInsert(); // uncomment to perform insert 
        // instance.runUpdate(); // uncomment to perform update 
        // instance.runDelete(); // uncomment to perform delete 
        instance.runQuery();  
       } catch (Exception e) {  
      e.printStackTrace();  
    } 
    } 
}

Can you develop this code in 5 seconds or less? We can! So can you with SQL(snap) for JDBC.

Code