package bdproject;

import java.sql.*;

public class prog {

	public static void main(String[] args) {
		Connection connect;
		try {
			String driverName="com.mysql.jdbc.Driver";
			Class.forName(driverName);
			String serverName="localhost";
			String mybase="java2";
			String url_="jdbc:mysql://"+serverName+"/"+mybase;
			String username="root";
			String password="";
			connect=DriverManager.getConnection(url_,username,password);

			String query="SELECT * FROM goods";
			Statement stmt=connect.createStatement();
			ResultSet rs=stmt.executeQuery(query);

			while (rs.next()) {
				System.out.println(""+rs.getString("id")+" "+rs.getString("name"));
			}
			connect.close();

		}
		catch(Exception ex) {}

	}

}