import java.sql.*;

public class HelloWorld11_2 
{
	public static void main(String[] args) throws Exception 
	{
		String user = "root";
		String password = "123456";
		String url = "jdbc:mysql://localhost:3306/test";
		Class.forName("com.mysql.jdbc.Driver");	//Java 6 д˾ʡԲд
		Connection conn = DriverManager.getConnection(url, user, password);
		Statement stat = conn.createStatement();
		stat.executeUpdate("CREATE TABLE Greetings (Message CHAR(20))");
		stat.executeUpdate("INSERT INTO Greetings VALUES ('Hello')");
		stat.executeUpdate("INSERT INTO Greetings VALUES ('World')");
		ResultSet rs = stat.executeQuery("SELECT * FROM Greetings");
		StringBuilder builder = new StringBuilder();
		String word = null;
		rs.next();
		word = rs.getString(1);
		builder.append(word);
		builder.append(", ");
		rs.next();
		word = rs.getString(1);
		builder.append(word);
		builder.append(" !~");
		System.out.println(builder.toString());
		stat.executeUpdate("DROP TABLE Greetings");
	}
}