File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Make it so: Java DB Connections & Transactions this week in the JDBC 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
It's not a secret anymore!