A simple Java application showing how to query a table in a database i.e performing a create query using JDBC
Steps for querying a Database using JDBC -
1. Download the driver jar from Internet and place it in classpath of your Java application. Here I am using MySql as Database so I have downloaded the jar with name as : "mysql-connector-java-5.1.20-bin.jar"
2. Create a Database (am using MySql as backend) name as "javaee".
3. Create a Java Class. It will perform necessary select query and output it to browser. The code for Java class is shown below -
package com.hubberspot.jdbc; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class CreateJdbcQuery { Connection connection = null; ResultSet resultSet = null; Statement statement = null; String query = null; String url = null; String username = null; String password = null; public static void main(String[] args) { CreateJdbcQuery cjq = new CreateJdbcQuery(); cjq.createConnection(); cjq.executeQuery(); } private void createConnection() { url = "jdbc:mysql://localhost:3306/javaee"; username = "root"; password = "root"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(url, username , password); } catch (Exception e) { e.printStackTrace(); } } private void executeQuery() { query = "create table user " + "(First_Name varchar(20) NOT NULL,"+ "Last_Name varchar(30) NOT NULL,"+ "Email varchar(50) NOT NULL,"+ "City varchar(30) NOT NULL,"+ "password varchar(30) NOT NULL PRIMARY KEY "+ ");"; try { statement = connection.createStatement(); statement.execute(query); } catch (SQLException e) { e.printStackTrace(); } finally { try { statement.close(); connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } }