package org.kodejava.sample.java.sql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.SQLException;
public class SelectStatementSample
{
public static void main(String[] args) throws Exception
{
Connection connection = null;
try
{
// Register MySQL JDBC driver to be known by
// the DriverManager object.
Class.forName("com.mysql.jdbc.Driver");
// Get a connection to database. We prepare the
// connection information here such as database
// url, user and password.
String url = "jdbc:mysql://localhost/testdb";
String user = "root";
String password = "";
connection = DriverManager.getConnection(url,
user, password);
// Create a statement object instance from the
// connection
Statement stmt = connection.createStatement();
// We are going to execute an insert statement.
// First you have to create a table that has an
// ID, NAME and ADDRESS field. For ID you can use
// an auto number, while NAME and ADDRESS are
// VARCHAR fields.
String sql = "INSERT INTO users (name, address) " +
"VALUES ('Foo Bar', 'Some Street')";
// Call an execute method in the statement object
// and passed the sql or query string to it.
stmt.execute(sql);
// After this statement is executed you'll have a
// record in your users table.
} catch (ClassNotFoundException e)
{
System.err.println("Could not load database driver!");
} catch (SQLException e)
{
e.printStackTrace();
} finally
{
if (connection != null)
{
connection.close();
}
}
}
}
|
