老同学信息整理小工具

package 老同学信息管理;import java.awt.FlowLayout;import java.awt.TextField;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing.BorderFactory;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;public class OldFriends extends JFrame implements ActionListener {private static final long serialVersionUID = 3L;static Connection connection;static Statement statement;static String DataUrl = "jdbc:odbc:jokersdata";static String DataUserName = "Jokers";static String UserPassword = "";static String TableName = "OldFriends";private final static int LENGTH = 40;static TextField nameField = new TextField(LENGTH);static TextField universityField = new TextField(LENGTH);static TextField majorField = new TextField(LENGTH);static TextField locationField = new TextField(LENGTH);static TextField cellphoneField = new TextField(LENGTH);static TextField qqField = new TextField(LENGTH);public static void main(String[] args) {InitialDatabase();new OldFriends();}OldFriends() {super("老同学信息管理方法");setLocationRelativeTo(null);setLocation(1366/2-200, 768/2-180);setSize(400, 360);setVisible(true);setResizable(false);setAlwaysOnTop(true);setDefaultCloseOperation(EXIT_ON_CLOSE);JPanel infoPanel = new JPanel();infoPanel.setLayout(new FlowLayout(FlowLayout.CENTER, 13, 20));JLabel nameJLabel = new JLabel("姓名");JLabel univerjJLabel = new JLabel("学校");JLabel majorJLabel = new JLabel("专业");JLabel locatJLabel = new JLabel("地址");JLabel celLabel = new JLabel("手机");JLabel qqJLabel = new JLabel("ＱＱ");infoPanel.add(nameJLabel);infoPanel.add(nameField);infoPanel.add(univerjJLabel);infoPanel.add(universityField);infoPanel.add(majorJLabel);infoPanel.add(majorField);infoPanel.add(locatJLabel);infoPanel.add(locationField);infoPanel.add(celLabel);infoPanel.add(cellphoneField);infoPanel.add(qqJLabel);infoPanel.add(qqField);JButton saveButton = new JButton("　　　保存　　　");JButton resetButton = new JButton("　　　重置　　　");saveButton.setActionCommand("save");resetButton.setActionCommand("reset");saveButton.setBorder(BorderFactory.createRaisedBevelBorder());resetButton.setBorder(BorderFactory.createRaisedBevelBorder());saveButton.addActionListener(this);resetButton.addActionListener(this);infoPanel.add(saveButton);infoPanel.add(resetButton);infoPanel.setBorder(BorderFactory.createRaisedBevelBorder());getContentPane().add(infoPanel);}private static boolean InitialDatabase() {try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");} catch (Exception e) {System.out.println("驱动异常！");return false;}try {connection = DriverManager.getConnection(DataUrl, DataUserName,UserPassword);statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);System.out.print("成功连接数据库/n");} catch (Exception e) {System.out.print(e);return false;}return true;}void insertData(String name, String university, String major,String location, String cellphone, String qq) {try {int qqn = 0;try {qqn = Integer.parseInt(qq.trim());} catch (NumberFormatException e) {qqn = 0;}System.out.print("insert into OldFriends values('" + name + "','"+ university + "','" + major + "','" + location + "','"+ cellphone.trim() + "'," + qq + ")/n");statement.execute("insert into OldFriends values('" + name.trim()+ "','" + university.trim() + "','" + major.trim() + "','"+ location.trim() + "','" + cellphone.trim() + "'," + qqn+ ")");} catch (SQLException e) {e.printStackTrace();}}void resetInfoPage() {nameField.setText("");universityField.setText("");majorField.setText("");locationField.setText("");cellphoneField.setText("");qqField.setText("");}public void actionPerformed(ActionEvent e) {if (e.getActionCommand().equals("save")) {insertData(nameField.getText(), universityField.getText(),majorField.getText(), locationField.getText(),cellphoneField.getText(), qqField.getText());resetInfoPage();} else {resetInfoPage();}}}