George2: Created page with " import java.sql.*; import java.util.Calendar; /** * A Java MySQL PreparedStatement INSERT example. * Demonstrates the use of a SQL INSERT statement a..."

2016-02-24T12:50:36Z

Created page with "<source lang="java"> import java.sql.*; import java.util.Calendar; /** * A Java MySQL PreparedStatement INSERT example. * Demonstrates the use of a SQL INSERT statement a..."

New page

<source lang="java">

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, <a href="http://devdaily.com" title="http://devdaily.com">http://devdaily.com</a>
*/
public class JavaMysqlPreparedStatementInsertExample
{

public static void main(String[] args)
{
try
{
// create a mysql database connection
String myDriver = "org.gjt.mm.mysql.Driver";
String myUrl = "jdbc:mysql://localhost/test";
Class.forName(myDriver);
Connection conn = DriverManager.getConnection(myUrl, "root", "");

// 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 users (first_name, last_name, date_created, is_admin, num_points)"
+ " values (?, ?, ?, ?, ?)";

// create the mysql insert preparedstatement
PreparedStatement preparedStmt = conn.prepareStatement(query);
preparedStmt.setString (1, "Barney");
preparedStmt.setString (2, "Rubble");
preparedStmt.setDate (3, startDate);
preparedStmt.setBoolean(4, false);
preparedStmt.setInt (5, 5000);

// execute the preparedstatement
preparedStmt.execute();

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

</source>

Connecting and inserting into mysql - Revision history

George2: Created page with " import java.sql.*; import java.util.Calendar; /** * A Java MySQL PreparedStatement INSERT example. * Demonstrates the use of a SQL INSERT statement a..."