eclipse mysql使用_如何在Eclipse中使用MySql数据库

I am very new to programming, so please bear with me, and apologies in advance if at first I dont make sense...!

I am doing an undergrad programming project, and need to make some databases within a Java program. I am using eclipse (galilo) to write my program. I have downloaded a connector/J, but havent the foggiest how i should use it!

Anyone out there able to give me a step by step approach?!

Many thanks!

解决方案

If you need a data explorer of some sort inside your eclipse, you can look at the links provided above or more specifically the plugin's documentation.

OTOH, if you want to know how you connect to a mysql database using JDBC, the below code sample explains it.

Connection connection = null;

try {

//Loading the JDBC driver for MySql

Class.forName("com.mysql.jdbc.Driver");

//Getting a connection to the database. Change the URL parameters

connection = DriverManager.getConnection("jdbc:mysql://Server/Schema", "username", "password");

//Creating a statement object

Statement stmt = connection.createStatement();

//Executing the query and getting the result set

ResultSet rs = stmt.executeQuery("select * from item");

//Iterating the resultset and printing the 3rd column

while (rs.next()) {

System.out.println(rs.getString(3));

}

//close the resultset, statement and connection.

rs.close();

stmt.close();

connection.close();

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}