201711671132《java实用教程》第十一章学习总结

201711671132《java实用教程》第十一章学习总结

一、教材学习内容总结

（1）教材学习中的问题和解决过程

（2）代码调试内容总结(课后习题)，无问题

1.同时用到了例子2中的GetDBConnection类。

import java.sql.*;

import java.sql.*;

public class BianCheng1 {

public static void main(String args[]) {

Connection con;

Statement sql;

ResultSet rs;

con = GetDBConnection.connectDB("students","root","");

if(con == null ) return;

String sqlStr =

"select * from mess order by birthday";

try {

sql=con.createStatement();

rs = sql.executeQuery(sqlStr);

while(rs.next()) {

String number=rs.getString(1);

String name=rs.getString(2);

Date date=rs.getDate(3);

float height=rs.getFloat(4);

System.out.printf("%s\t",number);

System.out.printf("%s\t",name);

System.out.printf("%s\t",date);

System.out.printf("%.2f\n",height);

}

con.close();

}

catch(SQLException e) {

System.out.println(e);

}

}

}

2.同时用到了例子6中的Query类。

import javax.swing.*;

public class BianCheng2 {

public static void main(String args[]) {

String [] tableHead;

String [][] content;

JTable table ;

JFrame win= new JFrame();

Query findRecord = new Query();

findRecord.setDatabaseName(args[0]);

findRecord.setSQL("select * from "+args[1]);

content = findRecord.getRecord();

tableHead=findRecord.getColumnName();

table = new JTable(content,tableHead);

win.add(new JScrollPane(table));

win.setBounds(12,100,400,200);

win.setVisible(true);

win.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

}

（3）无疑问