ojdbc

/**
 * Created by jalal on 7/6/2016.
 */
import java.sql.*;
import java.util.Calendar;

/**
 * A Java MySQL PreparedStatement INSERT example.
 * Demonstrates the use of a SQL INSERT statement against a
 * MySQL database, called from a Java program, using a
 * Java PreparedStatement.
 *
 * Created by Alvin Alexander, http://devdaily.com
 */
public class TestPhpMyAdmin
{

    public static void main(String[] args)
    {
        try
        {
            //static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
            // create a mysql database connection
            //String myDriver = "org.gjt.mm.mysql.Driver";
            Driver myDriver = new oracle.jdbc.driver.OracleDriver();
            String DB_URL = "jdbc:mysql://localhost/vidya";
            //String myUrl = "jdbc:mysql://localhost/test";
            Class.forName(myDriver);

            //  Database credentials
            final String USER = "root";
            final String PASS = "newpass";

            Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

            // create a sql date object so we can use it in our INSERT statement
            Calendar calendar = Calendar.getInstance();
            java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());

            // the mysql insert statement
            String query = " insert into students (ID, last_name, first_name, birthday, hometown)"
                    + " values (?, ?, ?, ?, ?)";

            // create the mysql insert preparedstatement
            PreparedStatement preparedStmt = conn.prepareStatement(query);
            preparedStmt.setInt(1, 808027);
            preparedStmt.setString(2, "Davis");
            preparedStmt.setString(3, "Felicita");
            preparedStmt.setDate(4, startDate);
            preparedStmt.setString(5, "Venice");

            // execute the preparedstatement
            preparedStmt.execute();

            conn.close();
        }
        catch (Exception e)
        {
            System.err.println("Got an exception!");
            System.err.println(e.getMessage());
        }
    }
}