Posts

Showing posts from May, 2013

JDBCExample

//STEP 1. Import required packages import java.sql.*; public class JDBCExample {     // JDBC driver name and database URL     static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";     static final String DB_URL = "jdbc:mysql://localhost:3306/students";     //  Database credentials     static final String USER = "root";     static final String PASS = "asdf";     public static void main(String[] args) {         Connection con = null;         Statement stmt = null;         try {             //STEP 2: Register JDBC driver             Class.forName(JDBC_DRIVER);             //STEP 3: Open a connection             System.out.println("Connecting to a selected database ... ");             con = DriverManager.getConnection(DB_URL, USER, PASS);             System.out.println("Connected database successfully.");             //STEP 4: Execute a query             System.out.println("Creating statement.");             stmt =