#Java - Code Snippets for '#Java.sql'

#Java - Code Snippets for '#Java.sql' - 8 code snippet(s) found

Sample 1. Code Sample / Example / Snippet of java.sql.ResultSetMetaData

  private void output(ResultSet resultSet, PrintStream out)

      throws SQLException {

    final ResultSetMetaData metaData = resultSet.getMetaData();

    final int columnCount = metaData.getColumnCount();

    while (resultSet.next()) {

      for (int i = 1;; i++) {

        out.print(resultSet.getString(i));

        if (i < columnCount) {

          out.print(", ");

        } else {

          out.println();

          break;

        }

      }

    }

  }

_{Like Feedback java.sql.ResultSetMetaData}

Sample 2. Database Api using java.sql classes

package BuggyBread;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;



public class DatabaseAPI {



   // JDBC driver name and database URL

   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

   static final String DB_URL = "";



   // Database credentials

   static final String USER = "";

   static final String PASS = "";



   Connection conn = null;

   

   public void initializeConnection(){

      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);



         conn.close();

      } catch (SQLException se) {

         // Handle errors for JDBC

         se.printStackTrace();

      } catch (Exception e) {

         // Handle errors for Class.forName

         e.printStackTrace();

      } finally {

          

         try {

            if (conn != null)

               conn.close();

         } catch (SQLException se) {

            se.printStackTrace();

         }// end finally try

      }// end try

   

   }

}

_{Like Feedback database api java.sql}

Sample 3. Code Sample / Example / Snippet of java.sql.Connection

  public String prepareBindExecute(HrConnection state) throws SQLException {

    Connection con = state.con;

    Statement st = null;

    ResultSet rs = null;

    String ename = null;

    try {

      final PreparedStatement ps =

          con.prepareStatement("select name from emps where empid = ?");

      st = ps;

      ps.setInt(1, state.id);

      rs = ps.executeQuery();

      rs.next();

      ename = rs.getString(1);

    } finally {

      close(rs, st);

    }

    return ename;

  }

_{Like Feedback java.sql.Connection}

Sample 4. Code Sample / Example / Snippet of java.sql.ResultSet

  public String prepareBindExecute(HrConnection state) throws SQLException {

    Connection con = state.con;

    Statement st = null;

    ResultSet rs = null;

    String ename = null;

    try {

      final PreparedStatement ps =

          con.prepareStatement("select name from emps where empid = ?");

      st = ps;

      ps.setInt(1, state.id);

      rs = ps.executeQuery();

      rs.next();

      ename = rs.getString(1);

    } finally {

      close(rs, st);

    }

    return ename;

  }

_{Like Feedback java.sql.ResultSet}

Sample 5. Code Sample / Example / Snippet of java.sql.Statement

  public ForStatement(List<DeclarationStatement> declarations,

      Expression condition, Expression post, Statement body) {

    super(ExpressionType.For, Void.TYPE);

    assert declarations != null;

    assert body != null;

    this.declarations = declarations; // may be empty, not null

    this.condition = condition; // may be null

    this.post = post; // may be null

    this.body = body; // may be empty block, not null

  }



  @Override public ForStatement accept(Visitor visitor) {

    visitor = visitor.preVisit(this);

    List<DeclarationStatement> decls1 =

        Expressions.acceptDeclarations(declarations, visitor);

    final Expression condition1 =

        condition == null ? null : condition.accept(visitor);

    final Expression post1 = post == null ? null : post.accept(visitor);

    final Statement body1 = body.accept(visitor);

    return visitor.visit(this, decls1, condition1, post1, body1);

  }

_{Like Feedback java.sql.Statement}

Sample 6. Code Sample / Example / Snippet of java.sql.PreparedStatement

  public String prepareBindExecute(HrConnection state) throws SQLException {

    Connection con = state.con;

    Statement st = null;

    ResultSet rs = null;

    String ename = null;

    try {

      final PreparedStatement ps =

          con.prepareStatement("select name from emps where empid = ?");

      st = ps;

      ps.setInt(1, state.id);

      rs = ps.executeQuery();

      rs.next();

      ename = rs.getString(1);

    } finally {

      close(rs, st);

    }

    return ename;

  }

_{Like Feedback java.sql.PreparedStatement}

Sample 7. Code Sample / Example / Snippet of java.sql.Array

  private void dumpColumn(ResultSet resultSet, int i) throws SQLException {

    final int t = resultSet.getMetaData().getColumnType(i);

    switch (t) {

    case Types.ARRAY:

      final Array array = resultSet.getArray(i);

      writer.print("{");

      dump(array.getResultSet(), false);

      writer.print("}");

      return;

    case Types.REAL:

      writer.print(resultSet.getString(i));

      writer.print("F");

      return;

    default:

      writer.print(resultSet.getString(i));

    }

  }

_{Like Feedback java.sql.Array}

Sample 8. Code Sample / Example / Snippet of java.sql.DatabaseMetaData

  private String mm(int majorVersion, int minorVersion) {

    return majorVersion + "." + minorVersion;

  }



  @Test public void testMetaDataColumns()

      throws ClassNotFoundException, SQLException {

    Connection connection = CalciteAssert

        .that(CalciteAssert.Config.REGULAR).connect();

    DatabaseMetaData metaData = connection.getMetaData();

    ResultSet resultSet = metaData.getColumns(null, null, null, null);

    assertTrue(resultSet.next()); // there's something

    String name = resultSet.getString(4);

    int type = resultSet.getInt(5);

    String typeName = resultSet.getString(6);

    int columnSize = resultSet.getInt(7);

    int decimalDigits = resultSet.getInt(9);

    int numPrecRadix = resultSet.getInt(10);

    int charOctetLength = resultSet.getInt(16);

    String isNullable = resultSet.getString(18);

    resultSet.close();

    connection.close();

  }

_{Like Feedback java.sql.DatabaseMetaData}

Search Java Code Snippets