1、e.printStackTrace（; catch （SQLException e return conn;2. 生成get set方法public class Country private String name;private String region;private String area;private String population;private String gdp;public String getName（ return name;public void setName（String name this.name = name;public String getReg
2、ion（ return region;public void setRegion（String region this.region = region;public String getArea（ return area;public void setArea（String area this.area = area;public String getPopulation（ return population;public void setPopulation（String population this.population = population;public String getGdp
3、（ return gdp;public void setGdp（String gdp this.gdp = gdp;3实现方法import java.awt.Rectangle;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.util.List;import javax.swing.JButton;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JLabel;import jav
4、ax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.SwingUtilities;public class CountryInfoGui implements ActionListener private JFrame jFrame;private JPanel jContentPane;private JLabel lblName = nul
5、l;private JTextField tfName = null;private JLabel lblRegion = null;private JComboBox cbRegion = null;private JLabel lblArea = null;private JTextField tfArea = null;private JLabel lblPopu = null;private JTextField tfPopu = null;private JLabel lblGdp = null;private JTextField tfGDP = null;private JBut
6、ton btnAdd = null;private JButton btnDel = null;private JButton btnModify = null;private JButton btnQuery = null;private JButton btnUpPage = null;private JButton btnDownPage = null;private JTable table = null;TableModel tm = null;JScrollPane jsp = null;private JTextField getTfName（ if （tfName = null
7、 tfName = new JTextField（;tfName.setBounds（new Rectangle（89, 17, 173, 27;return tfName;private JComboBox getCbRegion（ if （cbRegion = null String str = 请选择, 亚洲欧洲非洲北美洲南美洲大洋洲,南极洲 ;cbRegion = new JComboBox（str;cbRegion.setBounds（new Rectangle（360, 17, 229, 28;return cbRegion;private JTextField getTfArea
8、（ if （tfArea = null tfArea = new JTextField（;tfArea.setBounds（new Rectangle（89, 61, 173, 27;return tfArea;private JTextField getTfPopu（ if （tfPopu = null tfPopu = new JTextField（;tfPopu.setBounds（new Rectangle（360, 61, 229, 28;return tfPopu;private JTextField getTfGDP（ if （tfGDP = null tfGDP = new J
9、TextField（;tfGDP.setBounds（new Rectangle（89, 105, 173, 27;return tfGDP;private JButton getBtnAdd（ if （btnAdd = null btnAdd = new JButton（;btnAdd.setBounds（new Rectangle（46, 152, 71, 30;btnAdd.addActionListener（this;btnAdd.setText（添加return btnAdd;private JButton getBtnUpPage（ if （btnUpPage = null btn
10、UpPage = new JButton（上一页btnUpPage.addActionListener（this;btnUpPage.setBounds（200, 390, 80, 30;return btnUpPage;private JButton getBtnDownPage（ if （btnDownPage = null btnDownPage = new JButton（下一页btnDownPage.addActionListener（this;btnDownPage.setBounds（300, 390, 80, 30;return btnDownPage;private JBut
11、ton getBtnDel（ if （btnDel = null btnDel = new JButton（;btnDel.setBounds（new Rectangle（189, 152, 71, 30;btnDel.addActionListener（this;btnDel.setText（删除return btnDel;private JButton getBtnModify（ if （btnModify = null btnModify = new JButton（;btnModify.setBounds（new Rectangle（342, 152, 71, 30;btnModify
12、.addActionListener（this;btnModify.setText（更新return btnModify;private JButton getBtnQuery（ if （btnQuery = null btnQuery = new JButton（;btnQuery.setBounds（new Rectangle（484, 152, 71, 30;btnQuery.addActionListener（this;btnQuery.setText（查找return btnQuery;public static void main（String args SwingUtilitie
13、s.invokeLater（new Runnable（ public void run（ CountryInfoGui application = new CountryInfoGui（;application.getJFrame（.setVisible（true;private JFrame getJFrame（ if （jFrame = null jFrame = new JFrame（;jFrame.setDefaultCloseOperation（JFrame.EXIT_ON_CLOSE;jFrame.setBounds（new Rectangle（450, 250, 610, 454
14、;jFrame.setContentPane（getJContentPane（;jFrame.setTitle（国家信息管理return jFrame;private JPanel getJContentPane（ if （jContentPane = null lblGdp = new JLabel（;lblGdp.setBounds（new Rectangle（15, 106, 63, 27;lblGdp.setText（国家GDPlblPopu = new JLabel（;lblPopu.setBounds（new Rectangle（285, 61, 63, 27;lblPopu.se
15、tText（人口数量lblArea = new JLabel（;lblArea.setBounds（new Rectangle（15, 61, 63, 27;lblArea.setText（国家面积lblRegion = new JLabel（;lblRegion.setBounds（new Rectangle（285, 17, 63, 27;lblRegion.setText（所属地区lblName = new JLabel（;lblName.setBounds（new Rectangle（15, 17, 63, 27;lblName.setText（国家名称jContentPane = n
16、ew JPanel（;jContentPane.setLayout（null;jContentPane.add（lblName, null;jContentPane.add（getTfName（, null;jContentPane.add（lblRegion, null;jContentPane.add（getCbRegion（, null;jContentPane.add（lblArea, null;jContentPane.add（getTfArea（, null;jContentPane.add（lblPopu, null;jContentPane.add（getTfPopu（, nu
17、ll;jContentPane.add（lblGdp, null;jContentPane.add（getTfGDP（, null;jContentPane.add（getBtnAdd（, null;jContentPane.add（getBtnDel（, null;jContentPane.add（getBtnModify（, null;jContentPane.add（getBtnQuery（, null;jContentPane.add（getBtnUpPage（, null;jContentPane.add（getBtnDownPage（, null;return jContentPa
18、ne;public void actionPerformed（ActionEvent e if （e.getActionCommand（.equals（ selectAll（; else if （e.getActionCommand（.equals（selectDownPage（;selectUpPage（;if （tfName.getText（.equals（| cbRegion.getSelectedItem（.equals（| tfArea.getText（.equals（| tfPopu.getText（.equals（| tfGDP.getText（.equals（JOptionPa
19、ne.showMessageDialog（jFrame, 请填写相关信息else Country co = new Country（;co.setName（tfName.getText（;co.setRegion（String cbRegion.getSelectedItem（;co.setArea（tfArea.getText（;co.setPopulation（tfPopu.getText（;co.setGdp（tfGDP.getText（;boolean flag = CountryOperate.add（co;if （flag 添加成功 else 添加失败if（!tfName.getT
20、ext（.equals（String key = tfName.getText（;boolean flag = CountryOperate.del（key;删除成功删除失败请填写一个国家名字if （!& !cbRegion.getSelectedItem（.equals（tfArea.getText（.equals（tfPopu.getText（.equals（tfGDP.getText（.equals（Country cou = new Country（;cou.setName（tfName.getText（;cou.setRegion（StringcbRegion.getSelected
21、Item（;cou.setPopulation（tfPopu.getText（;cou.setArea（tfArea.getText（;cou.setGdp（tfGDP.getText（;boolean flag = CountryOperate.modify（cou;if（flag更新成功更新失败请填写相应的信息public void setValues（Object obj this.tm.setDatavalues（obj;public void selectAll（ List list = CountryOperate. queryFirst（;Object datavalues =
22、new Objectlist.size（5;for （int i = 0; i list.size（; i+ Country co = list.get（i;datavaluesi0 = co.getName（;datavaluesi1 = co.getRegion（;datavaluesi2 = co.getArea（;datavaluesi3 = co.getRegion（;datavaluesi4 = co.getGdp（;tm = new TableModel（;this.setValues（datavalues;table = new JTable（tm;table.updateUI
23、（;JScrollPane jsp = new JScrollPane（table;jsp.setBounds（0, 200, 600, 182;jContentPane.add（jsp;public void selectDownPage（ List list = CountryOperate. downPage（;if （list != null 已经是最后一页public void selectUpPage（ List list = CountryOperate. upPage（;已经是第一页4操作方法import javax.swing.table.AbstractTableModel;public class TableModel extends AbstractTableModel public final static String columnHeaders = ,国家面
