frame1.java

学生信息管理

				return;
			} else {
				String id = jTextField1.getText();
				rSet = statement.executeQuery("select id from table1");
				while (rSet.next() != false) {
					if (id.equals(rSet.getString("id"))) {
						jTextPane1.setText("已存在此学生信息。");
						return;
					}
				}

				if (jTextField2.getText().length() == 0
						|| jTextField3.getText().length() == 0
						|| jTextField4.getText().length() == 0) {
					jTextPane1.setText("请填写完整信息。");
					return;
				}

				// table1表中添加记录
				statement.executeUpdate(sql1);
				jTextPane1.setText("记录添加成功!");
				// 清空信息框
				jTextField1.setText("");
				jTextField2.setText("");
				jTextField3.setText("");
				jTextField4.setText("");
				return;
			}
		} catch (SQLException ex) {
			jTextPane1.setText(ex.getMessage());
			System.out.println("\nERROR:----- SQLException -----\n");
			while (ex != null) {
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
				ex = ex.getNextException();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			try {
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException ex) {
				System.out.println("\nERROR:----- SQLException -----\n");
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
			}
		}
	}

	// 处理删除按钮的ActionEvent
	void jButton3_actionPerformed(ActionEvent e) {
		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			connection = DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/studentINFO", "root",
					"551061123");
			// 创建Statement接口对象
			statement = connection
					.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
							ResultSet.CONCUR_UPDATABLE);
			rSet = statement.executeQuery("select id from table1 ");
			if (rSet.next() == false) // 判断数据库中是否有要删除的记录，如没有则显示提示框
			{
				jTextPane1.setText("数据库中没有您要删除的学号!");
				return;
			} else {
				String dID = jTextField1.getText();
				do {
					if (dID.equals(rSet.getString("id")))
						break;
					jTextPane1.setText("数据库中没有您要删除的学号!");
					return;
				} while (rSet.next() != false);

				String sql2 = "delete from table1 where id='" + dID + "'";
				// 删除talbe1表中对应学号的数据记录
				statement.executeUpdate(sql2);
				// 清空信息框
				jTextField1.setText("");
				jTextField2.setText("");
				jTextField3.setText("");
				jTextField4.setText("");
				jTextPane1.setText("记录已成功删除!");
				return;
			}
		} catch (SQLException ex) {
			System.out.println("\nERROR:----- SQLException -----\n");
			while (ex != null) {
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
				ex = ex.getNextException();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			try {
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException ex) {
				System.out.println("\nERROR:----- SQLException -----\n");
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
			}
		}
	}

	void jButton4_actionPerformed(ActionEvent e) {
		jTextField1.setText("");
		jTextField2.setText("");
		jTextField3.setText("");
		jTextField4.setText("");
		jTextPane1.setText("");
		return;
	}

	/**
	 * @param e
	 */

	// 处理查询按钮的ActionEvent
	void jButton5_actionPerformed(ActionEvent e) {
		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			connection = DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/studentINFO", "root",
					"551061123");
			// 创建Statement接口对象
			statement = connection.createStatement();
			rSet = statement.executeQuery("select * from table1");
			if (jTextField1.getText().length() == 0) {
				jTextPane1.setText("请输入要查询的信息!");
				return;
			}
			// 判断数据库中是否有要查询的记录，如没有则显示提示框
			if (rSet.next() == false) {
				jTextPane1.setText("数据库空，没有您查询的学号!");
				return;
			} /*
				 * else { if ((rSet.getString(1)).equals(jTextField1.getText())) {
				 * jTextPane1.setText("查询信息如下:"); // 显示数据
				 * jTextField1.setText(rSet.getString(1));
				 * jTextField2.setText(rSet.getString(2));
				 * jTextField3.setText(rSet.getString(3));
				 * jTextField4.setText(rSet.getString(4)); } else {
				 * jTextPane1.setText("数据库中没有您查询的学号!"); } }
				 */
			else {

				do {
					System.out.println(rSet.getString(1));
					if (!(rSet.getString(1)).equals(jTextField1.getText())) {
						System.out.println("continue");
						continue;						
					} else {
						jTextPane1.setText("得到查询信息: \n学号 " + rSet.getString(1)
								+ "\t姓名 " + rSet.getString(2) + "\t所在院系 "
								+ rSet.getString(3) + "\t\t所在班级"
								+ rSet.getString(4));
						return;
					}
				} while (rSet.next() != false);
				jTextPane1.setText("数据库中没有您查询的学号!");
				return;

			}
		}

		catch (SQLException ex) {
			System.out.println("\nERROR:----- SQLException -----\n");
			while (ex != null) {
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
				ex = ex.getNextException();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			try {
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException ex) {
				System.out.println("\nERROR:----- SQLException -----\n");
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
			}
		}
	}

	void jButton6_actionPerformed(ActionEvent e) {
		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			connection = DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/studentINFO", "root",
					"551061123");
			// 创建Statement接口对象
			statement = connection.createStatement();
			rSet = statement.executeQuery("select * from table1");

			CreateXML creater = new CreateXML();
			Element root = creater.doc.createElement("学生");
			creater.doc.appendChild(root);

			while (rSet.next() != false) {
				StudentBean stu = new StudentBean();
				stu.setID(rSet.getString(1));
				stu.setName(rSet.getString(2));
				stu.setMajor(rSet.getString(3));
				stu.setCla(rSet.getString(4));

				Element s = creater.createStuElement(stu);
				creater.insertSon(root, s);
			}

			FileOutputStream out = new FileOutputStream("c:\\stuINFO.txt");
			OutputStreamWriter writer = new OutputStreamWriter(out);
			((XmlDocument) creater.getDoc()).write(writer, "utf8");
			
			jTextPane1.setText("已在\nc:\\stuINFO.txt\n生成了XMl树");

		} catch (SQLException ex) {
			System.out.println("\nERROR:----- SQLException -----\n");
			while (ex != null) {
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
				ex = ex.getNextException();
				jTextPane1.setText("生成XMl树失败");
			}
		} catch (Exception ex) {
			jTextPane1.setText("生成XMl树失败");
			ex.printStackTrace();
		} finally {
			try {
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException ex) {
				System.out.println("\nERROR:----- SQLException -----\n");
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
			}
		}
	}

	void jButton7_actionPerformed(ActionEvent e) {
		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
			connection = DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/studentINFO", "root",
					"551061123");
			// 创建Statement接口对象
			statement = connection.createStatement();

			if(jTextField1.getText().length() == 0){
				jTextPane1.setText("请输入待查询学生的学号：");
				return;
			}
			if (jTextField1.getText().length() != 0) {
				rSet = statement.executeQuery("select * from table1 where id='"
						+ jTextField1.getText() + "'");
				if (rSet.next() == false) {
					jTextPane1.setText("未找到该学生，请确认后再次输入");
					return;
				} else {
					String info = rSet.getString(1) + " " + rSet.getString(2)
							+ " " + rSet.getString(3) + " " + rSet.getString(4);
					SearchOnTheNet s = new SearchOnTheNet();
					s.infomation(info);
					jTextPane1.setText(s.getInfo());
					return;
				}
			}
		} catch (SQLException ex) {
			System.out.println("\nERROR:----- SQLException -----\n");
			while (ex != null) {
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
				ex = ex.getNextException();
				jTextPane1.setText("查询失败");
			}
		} catch (Exception ex) {
			jTextPane1.setText("查询失败");
			ex.printStackTrace();
		} finally {
			try {
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException ex) {
				System.out.println("\nERROR:----- SQLException -----\n");
				System.out.println("Message:   " + ex.getMessage());
				System.out.println("SQLState:  " + ex.getSQLState());
				System.out.println("ErrorCode: " + ex.getErrorCode());
			}
		}
	}
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton1_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton1_actionPerformed(e);
	}
}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton2_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton2_actionPerformed(e);
	}
}

class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton3_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton3_actionPerformed(e);
	}
}

class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton4_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton4_actionPerformed(e);
	}
}

class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton5_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton5_actionPerformed(e);
	}
}

class Frame1_jButton6_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton6_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton6_actionPerformed(e);
	}
}

class Frame1_jButton7_actionAdapter implements java.awt.event.ActionListener {
	Frame1 adaptee;

	Frame1_jButton7_actionAdapter(Frame1 adaptee) {
		this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
		adaptee.jButton7_actionPerformed(e);
	}
}