Java代码：
package com.edu.imau;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Font;
import java.awt.GridLayout;
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.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.text.BadLocationException;
public class StudentInfoManager extends JFrame {
private static final long serialVersionUID = 1L;
private JPanel panel;
private JButton button1, button2, button3;
private JTextArea text1, text2, text3;
private String[] top={"id","name","age"};
private static String[][] data=new String[20][3];
JTable table = new JTable(data, top);
JScrollPane scrollPane = new JScrollPane(table);
//table.setFillsViewportHeight(true);
public StudentInfoManager() throws BadLocationException, SQLException {
super("学生信息");
this.setSize(500, 340);
findInfo();
this.add(scrollPane, BorderLayout.CENTER);
this.add(getJPanel(), BorderLayout.SOUTH);
this.setResizable(true);
this.setLocation(300, 300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
private JPanel getJPanel() {
if (panel == null) {
panel = new JPanel();
panel.setLayout(new GridLayout(2, 3));
text1 = new JTextArea();
text2 = new JTextArea();
text3 = new JTextArea();
button1 = new JButton("add");
button2 = new JButton("delete");
button3 = new JButton("update");
button1.addActionListener(new insert());
button2.addActionListener(new delete());
button3.addActionListener(new update());
text1.setBorder(BorderFactory.createLineBorder(Color.gray, 2));
text2.setBorder(BorderFactory.createLineBorder(Color.gray, 2));
text3.setBorder(BorderFactory.createLineBorder(Color.gray, 2));
text1.setFont(new Font("宋体", Font.BOLD, 16));
text2.setFont(new Font("宋体", Font.BOLD, 16));
text3.setFont(new Font("宋体", Font.BOLD, 16));
text1.setText("id");
text2.setText("name");
text3.setText("age");
panel.add(text1);
panel.add(text2);
panel.add(text3);
panel.add(button1);
panel.add(button2);
panel.add(button3);
}
return panel;
}
class insert implements ActionListener{
public void actionPerformed(ActionEvent e) {
if(text1.getText().equals(" ")||text2.getText().equals(" ")||text3.getText().equals(" "))
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "输入数据不完整！");
}
else{
Connection con =null;
Statement stmt=null;
int rs=0;
try{
con=getCurrentConnection();
stmt=con.createStatement();
rs=stmt.executeUpdate("INSERT INTO stu(id,name,age)" + "VALUES('" +Integer.parseInt(text1.getText()) + "','" +text2.getText() + "','"
+ Integer.parseInt(text3.getText()) + "')");
if(rs != 0)
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "插入了"+rs+"条数据!");
}
//rs.close();
stmt.close();
con.close();
}catch(Exception e1){
System.out.println(e1.toString());
}
}
}
}
class delete implements ActionListener{
public void actionPerformed(ActionEvent e) {
if(text1.getText().equals(" ")||text2.getText().equals(" ")||text3.getText().equals(" "))
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "请输入要删除的id");
}
else{
Connection con =null;
Statement stmt=null;
int rs=0;
try{
con=getCurrentConnection();
stmt=con.createStatement();
rs=stmt.executeUpdate("DELETE FROM stu WHERE id = '" +text1.getText() + "'");
if(rs != 0)
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "删除了"+rs+"条数据！");
}
//rs.close();
stmt.close();
con.close();
}catch(Exception e1){
System.out.println(e1.toString());
}
}
}
}
class update implements ActionListener{
public void actionPerformed(ActionEvent e) {
if(text1.getText().equals(" ") || text2.getText().equals(" ") || text3.getText().equals(" "))
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "输入数据不完整");
}
else{
//System.out.print(text1.getText());
Connection con =null;
Statement stmt=null;
int rs=0;
try{
con=getCurrentConnection();
stmt=con.createStatement();
rs=stmt.executeUpdate("UPDATE stu SET name='" + text2.getText()+ "',age= '" + text3.getText()+ "'WHERE id = '" + text1.getText() + "'");
if(rs != 0)
{
JOptionPane.showMessageDialog(StudentInfoManager.this, "更新了"+rs+"条数据！");
}
//rs.close();
stmt.close();
con.close();
}catch(Exception e1){
System.out.println(e1.toString());
}
}
}
}
public static Connection getCurrentConnection(){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/student";
String user="root";
String password="123456";
Connection con =null;
try {
Class.forName(driver);
con=DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public static void findInfo(){
Connection con =null;
Statement stmt=null;
ResultSet rs=null;
try{
con=getCurrentConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from stu");
int i=0;
while(rs.next()){
data[i][0]=rs.getString(1);
data[i][1]=rs.getString(2);
data[i][2]=rs.getString(3);
i++;
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
System.out.println(e.toString());
}
}
public static void main(String[] args) throws BadLocationException, SQLException {
new StudentInfoManager().setVisible(true);
}}
数据库文件:
DROP TABLE IF EXISTS `stu`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `stu` ( `id` int(11) NOT NULL auto_increment, `name` varchar(40) default NULL, `age` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
LOCK TABLES `stu` WRITE;
/*!40000 ALTER TABLE `stu` DISABLE KEYS */;
INSERT INTO `stu` VALUES (1,'zhangsan',25),(2,'zhangsan',25),(3,'wangwu ',56),(4,'ll',24),(5,'zhangsi',30),(6,'ggh',12),(7,'ko',26);
-- Dump completed on 2017-04-07 3:40:07
完事。
附上源代码
京公网安备 11010502036488号