CREATE VIEW cstudent_course AS SELECT sc.sno, s.sname, c.cname FROM student s JOIN student_course sc ON s.sno = sc.sno JOIN course c ON sc.cno = c.cno WHERE s.spec = ‘计算机’;
BasicOperation
Create table
Drop tavble
Describe table
Select
Insert
Delete
Update
Connection
Loading Drivers
Establishing Connection
Creating and Executing satatements
Processing ResultSet
Example
