As you can see, constructing a simple SELECT statement in Java is almost as simple as constructing a simple SELECT statement in SQL. The more features you want to use, the more complicated it gets.

I came across an error，cause an exception when I use "java/sql/Statement" in jdk 11，but jdk 8 doesn t have this problem. I was very confused for this. //this my exception log. Exception in thread ...

If you're interested, here's the whole set of 24 SQL statements that we used - the above create statement and 23 inserts. You could even use this dataset to recreate the films table on your favourite ...