嵌入式數(shù)據(jù)庫實訓(xùn)八資料

1、嵌入式數(shù)據(jù)庫實訓(xùn)八語言擴(kuò)展 JAVA綜合練習(xí)在充分了解foods 數(shù)據(jù)庫結(jié)構(gòu)的前提下，編寫Java程序?qū)崿F(xiàn)下列操作。1、查詢飲料、肉類食品、水果（drink,meat,fruit）這三種類型食品的數(shù)量各是多少，要求查詢結(jié)果的輸出格式為：飲料類食品的數(shù)量為：*肉類食品的數(shù)量為： *水果類食品的數(shù)量為：*import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class p1 public static void main(

2、String args)tryClass.forName(org.sqlite.JDBC);Connectionconn=DriverManager.getConnection(jdbc:sqlite:foods.db);System.out.println(數(shù)據(jù)庫連接成功！ );Statement stat=conn.createStatement();ResultSet rs=stat.executeQuery(select type_id,count(*) from foods where type_id in(select id from food_types where name=D

3、rinksor name=Meat or name=Fruit) group by type_id;);while(rs.next()System.out.println(rs.getString(type_id)+ 類食品的數(shù)量為 +rs.getString(count(*);rs.close();conn.close();catch(Exception e)e.printStackTrace();2、查詢食品數(shù)量超過20 的食物類型及其數(shù)量， 要求結(jié)果按降序排列，輸出格式為：* 類食品的數(shù)量為： *importjava.sql.Connection;importjava.sql.Drive

4、rManager;importjava.sql.ResultSet;importjava.sql.Statement;publicpublicclassstaticp1 voidmain(String args) tryClass.forName( org.sqlite.JDBC);Connectionconn=DriverManager.getConnection( jdbc:sqlite:foods.db);System.out .println( 數(shù)據(jù)庫連接成功！ );Statement stat=conn.createStatement();ResultSet rs=stat.exec

5、uteQuery(select food_,count(*)fromfoods,food_typeswherefoods.type_id=food_types.idgrouphaving count(*)=20 order by count(*) desc;);while(rs.next()by type_idSystem.為 +rs.getString(out .println(rs.getString(count(*);food_)+ 類食品的數(shù)量rs.close();conn.close();catch(Exception e)e.printSta

6、ckTrace();3、在數(shù)據(jù)庫中創(chuàng)建表foodsbak ，在表中存放所有食物名稱以字母“B”開頭的食物數(shù)據(jù)。importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicpublicclassstaticp1 voidmain(String args) tryClass.forName( org.sqlite.JDBC);Connectionconn=DriverManager.getConnection( jdbc:sqlite:f

7、oods.db);System.out .println( 數(shù)據(jù)庫連接成功！ );Statement stat=conn.createStatement();stat.executeUpdate(createtablefoodsbakas select* fromfoodswherename like B%;);System.out .println( 成功創(chuàng)建數(shù)據(jù)表 );ResultSet rs=stat.executeQuery(select * from foodsbak);while(rs.next()System.out .print(id=+rs.getString(id)+ );

8、System.out .println(name=+rs.getString(name);rs.close();conn.close();catch(Exception e)e.printStackTrace();4、刪除 episodes 表中 season 值為 9 的記錄。importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicpublicclassstaticp1 voidmain(String args) tryClas

9、s.forName( org.sqlite.JDBC);Connectionconn=DriverManager.getConnection( jdbc:sqlite:foods.db);System.out .println( 數(shù)據(jù)庫連接成功！ );Statement stat=conn.createStatement();stat.executeUpdate(deletefromepisodeswhereseason=9;System.out .println( 成功刪除數(shù)據(jù)！ ););ResultSet rs=stat.executeQuery(select * from episode

10、swhile(rs.next();System.out.print(season=+rs.getString(season)+ );System.out.println(name=+rs.getString(name);rs.close();conn.close();catch(Exception e)e.printStackTrace();5、查詢輸出 food_types 表的行列信息，輸出格式參照：importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicpublicclassstaticp1 voidmain(String args) tryClass.forName( org.sqlite.JDBC);Connectionconn=DriverManager.getConnection( jdbc:sqlite:foods.db);System.out .println( 數(shù)據(jù)庫連接成功！ );Statement stat=conn.createStatement();ResultSet rs=stat.executeQuery(select id,name from food_types;