java實(shí)驗(yàn)五報(bào)告格式

1、1 / 6 文檔可自由編輯打印任課教師：宋瑾鈺任課教師：宋瑾鈺JAVA 程序設(shè)計(jì)程序設(shè)計(jì)（2011-2012 學(xué)年第學(xué)年第 2 學(xué)期）學(xué)期）實(shí)實(shí)驗(yàn)驗(yàn)報(bào)報(bào)告告學(xué)號(hào)：學(xué)號(hào)：E10700217姓名：廖遠(yuǎn)東姓名：廖遠(yuǎn)東2 / 6 文檔可自由編輯打印班級(jí)：數(shù)字媒體班級(jí)：數(shù)字媒體 2 班班浙江理工大學(xué)信息學(xué)院實(shí)驗(yàn)指導(dǎo)書(shū)實(shí)驗(yàn)名稱：JDBC 數(shù)據(jù)庫(kù)基本操作 學(xué)時(shí)安排：2實(shí)驗(yàn)類別：綜合設(shè)計(jì)型實(shí)驗(yàn) 實(shí)驗(yàn)要求：1 人 1 組 一、實(shí)驗(yàn)?zāi)康恼莆?JDBC 數(shù)據(jù)庫(kù)基本操作二、實(shí)驗(yàn)內(nèi)容1.編寫(xiě)程序創(chuàng)建一職工數(shù)據(jù)表職工號(hào)姓名性別工資職稱1002張小華男1600助工1007李力女3000工程師1001丁衛(wèi)國(guó)男1800助工10

2、05黃菊女4200工程師1003寧淘男5500高工 2.從數(shù)據(jù)庫(kù)中讀出相關(guān)記錄顯示在屏幕上.并將每個(gè)人工資加 500 元后存入原表. 3.按職工號(hào)從小到大排序顯示到屏幕上，再存入另一新表中. 按排序結(jié)果插入新表 sql=insert into emp2 select * from emp order by num ; 4.在新表中刪除 1001 和 1005 記錄.并輸出刪除后的表.5.要求實(shí)驗(yàn)報(bào)告寫(xiě)出數(shù)據(jù)庫(kù)操作基本步驟。 按排序結(jié)果插入新表sql=insert into emp2 select * from emp order by num ;3 / 6 文檔可自由編輯打印三、程序代碼或操作

3、步驟：import java.sql.*;public class Main public static void main(String args) try Class.forName(sun.jdbc.odbc.JdbcOdDriver); catch(ClassNotFoundException ce) System.out.println(errorMessage : +ce.getMessage(); / /* String userName = friddlelocalhost; String userPassword = 88636311; String driverName =

4、 com.mysql.jdbc.Driver; String url = jdbc:mysql:localhost:3306/friddle; */ /* try Class.forName(driverName); catch(ClassNotFoundException ce) System.out.println(errorMessage:+ce.getMessage(); */ try Connection teacher= DriverManager.getConnection(jdbc:odbc:Friddle);4 / 6 文檔可自由編輯打印 /Connection teache

5、r= DriverManager.getConnection(url,userName,userPassword); Statement stmt=teacher.createStatement(); ResultSet rs =stmt.executeQuery(select * from Teacher); System.out.println(the table onet); while(rs.next() System.out.println( JobNum: +rs.getString(1)+t+ Name: +rs.getString(2)+t+ Sex: +rs.getStrin

6、g(3)+t+ Pay: +rs.getString(4)+t+ Job: +rs.getString(5) ); String sqlCreateTable=create table Teacher(JobNum int,Name char(10),sex char(4),Pay int,Job cha + r(10); String sqlUpdate=update teacher set pay=pay+500; String sqlCreate=create table teacher2(JobNum int,Name char(10), + Sex char(10),Pay int,

7、Job char(10); String sqlDrop =drop table teacher2; String sqlSelect=insert into teacher2 select * from teacher order by jobNum; String sqlDel=delete from teacher2 where jobNum in(1001,1005); /String sqlDrop=drop table teacher2; stmt.executeUpdate(sqlUpdate); stmt.executeUpdate(sqlCreate); stmt.execu

8、teUpdate(sqlSelect); stmt.executeUpdate(sqlDel); rs =stmt.executeQuery(select * from Teacher2 ); System.out.println(the table two:t); while(rs.next() System.out.println(5 / 6 文檔可自由編輯打印 JobNum: +rs.getString(1)+t+ Name: +rs.getString(2)+t+ Sex: +rs.getString(3)+t+ Pay: +rs.getString(4)+t+ Job: +rs.getString(5) ); rs.close(); stmt.close(); teacher.close(); catch(SQLException e) System.out.pr