How to simplify the work with databases in Java app?

By using the Java Database Connectivity api you can simplify Java app work with databases greatly
08 August 2017   1243

Java

Popular general-purpose programming language and computing platform

Combining database with a Java application can be a complicated task. From one side, Java does not support multi-line string constants, so developers can end up with code that looks like this:

String sql_query = "select *" + "from user_table" + "where name like 'John%

This line of code is not "very pretty" but also has errors. Did you notice the missing space between user_table and where? A further challenge when working with SQL in Java is that we often need to build the SQL dynamically.

Java Database Connectivity (JDBC), is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases. Using JDBC one can send statements to almost any relational database. Thus, JDBC is a Java API for executing the SQL statements and supports basic SQL functionality.

So, what exactly JDBC do? Here's the list:

  • Making a connection to the database.
  • Creating SQL statements.
  • Executing SQL queries in the database.
  • Viewing and Modifying the resulting records.

Learn more about JDBC. You will be using Eclipse Kepler SR2, JDK 8, MySQL Database and Maven to create JDBC Query Builder.

Sonatype to Create Vulnerability Checker Tool

New tool is called DepShield and available in the "Security" section of the GitHub Marketplace
16 August 2018   111

Sonatype has introduced a tool for developers called DepShield, which checks the code on GitHub for vulnerabilities.

The free version of the service is looking for vulnerabilities in the OSS Index database and gives recommendations on how to fix them. In the commercial version, you can configure automatic fixing of problems. Also in DepShield there are:

  • work with the Apache Maven framework;
  • View a list of known vulnerabilities in GitHub's Issue Tracker;
  • determine the range of versions for each vulnerability.

DepShield
DepShield

DepShield is available in the "Security" section of the GitHub Marketplace.

GitHub has introduced two new features that will help improve security and simplify the recovery of accounts. For this, the company recommends setting a strong password and two-factor authentication.