This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Newbie Java MySql question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Newbie Java MySql question" Watch "Newbie Java MySql question" New topic

Newbie Java MySql question

Scott Matthews
Ranch Hand

Joined: Jun 28, 2001
Posts: 36
I am new to java (about 6 months). I downloaded the MySql and am running the Server (MySqlD) on my Win98 computer. I can run MySql and all works fine when I input commands by hand. I want to now create a java program that will open an existing database and insert some records.
Can anyone provide a quick source code snippet that would handle opening a database and "sending" the database a SQL statement?

Thanks for your time.
Dorj Galaa
Ranch Hand

Joined: May 29, 2001
Posts: 113
import java.sql.*;
public class MySQL
public static void main(String args[])
Connection mysql=DriverManager.getConnection("jdbc:mysql://");
catch(Exception e)
download MySQL jdbc driver

Senior software engineer
I agree. Here's the link:
subject: Newbie Java MySql question