任务说明:
demo1:创建java project,把所有city改成user,包括文件名、类名、方法名、变量名都要改
demo2:创建dynamic java project,把所有user改成movie,包括文件名、类名、方法名、变量名都要改
操作步骤:
1 导入数据库
1)把mysql-connector-java-5.1.44-bin.jar拷贝到C:\Program Files\MySQL\MySQL Server 5.0\bin
2)把db_movie.sql拷贝到C:\Program Files\MySQL\MySQL Server 5.0\bin
3)打开mysql命令行窗口,依次执行create database db_movie; use db_movie; source
db_movie.sql; show tables; desc tables; 查看库表结构
2 eclipse导入驱动包
1)项目右键,building path, 导入mysql-connector-java-5.1.44-bin.jar包
2)把mysql-connector-java-5.1.44-bin.jar拷贝到C:\Program Files\Java\jre1.8.0_161\lib\ext