回复 2楼 疯狂的小a
代码如下，想实现的功能是增加用户，或者删除用户，，下面的显示框会实时更新，不需要重进界面才会刷新出刚才增加或删除之后的内容，我尝试过把显示内容那部分定义成一个方法，但好像也不是很好，而且麻烦，
import java.awt.*;
import java.awt.event.*;
import *;
import *;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class Conn {
public void Myframe(){
JFrame qj=new JFrame("QQ2017");
qj.setLayout(null);
qj.setBounds(0,0,200,500);
Container con=qj.getContentPane();
qj.setVisible(true);
JButton user=new JButton("管理用户");
user.setBounds(30,60,100,21);
user.setForeground(Color.red);
con.add(user);
user.setVisible(true);
user.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e){
JFrame zjadmin=new JFrame("用户");
zjadmin.setLayout(null);
zjadmin.setBounds(0,0,300,300);
zjadmin.setVisible(true);
Container con1=zjadmin.getContentPane();
//用户框内的面板显示
Connection con;
ResultSet res;
DefaultTableModel model=new DefaultTableModel();//创建一个表格模型
model.setColumnIdentifiers(new Object[]{"账号","密码",});//创建表头
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("驱动加载成功");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
System.out.println("数据库连接成功");
String sql="select * from USERINTO";
PreparedStatement stmt=con.prepareStatement(sql);
res=stmt.executeQuery();
while(res.next()){
String id=res.getString("userid");
String password=res.getString("password");
model.addRow(new Object[]{id,password});
}
final JTable table=new JTable(model);
JScrollPane scrollPanne=new JScrollPane(table);
scrollPanne.setBounds(0,80,300,200);
con1.add(scrollPanne);
scrollPanne.setVisible(true);
JButton addadminer=new JButton("增加用户");
addadminer.setBounds(10,10,100,21);
con1.add(addadminer);
addadminer.setVisible(true);
addadminer.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
JFrame zjadmin=new JFrame("增加用户");
zjadmin.setBounds(0,0,300,200);
Container con1=zjadmin.getContentPane();
zjadmin.setVisible(true);
final JLabel zh=new JLabel("账号");
zh.setBounds(0, 20, 100, 21);
con1.add(zh);
final JTextField zhangh=new JTextField();
zhangh.setBounds(30,20,100,20);
zhangh.setBackground(Color.yellow);
con1.add(zhangh);
zhangh.setVisible(true);
final JLabel zcjl=new JLabel("密码");
zcjl.setBounds(0, 40, 100, 21);
con1.add(zcjl);
final JTextField zcmima=new JTextField("",20);
zcmima.setBounds(30,40,100,20);
zcmima.setBackground(Color.yellow);
con1.add(zcmima);
zcmima.setVisible(true);
final JButton zcau=new JButton("注册");
zcau.setBounds(40,70,60,20);
con1.add(zcau);
zcau.setVisible(true);
final JLabel zcview=new JLabel();
zcview.setBounds(150, 70, 100,21);
con1.add(zcview);
zcau.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
Connection con;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//System.out.println("驱动加载成功");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
//System.out.println("数据库连接成功");
String sql="insert into USERINTO (userid,password) values (?,?)";
PreparedStatement stmt=con.prepareStatement(sql);//执行sql语句
stmt.setString(1, zhangh.getText());
stmt.setString(2, zcmima.getText());
stmt.executeUpdate();
zcview.setText("注册成功");
con.close();
System.out.println("添加成功");
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
}
});
JButton deleteadmin=new JButton("删除用户");
deleteadmin.setBounds(120,10,100,21);
con1.add(deleteadmin);
deleteadmin.setVisible(true);
deleteadmin.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
int rowcount=table.getSelectedRow();
System.out.print(rowcount);
System.out.print(table.getValueAt(rowcount,0 ));
Connection con;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//System.out.println("驱动加载成功");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
//System.out.println("数据库连接成功");
String sql="delete
from USERINTO "+"where userid=?";
PreparedStatement stmt=con.prepareStatement(sql);//执行sql语句
stmt.setString(1, (String) table.getValueAt(rowcount,0 ));
stmt.executeUpdate();
System.out.println("删除成功");
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
res.close();
con.close();
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//addadminer.setForeground(Color.red);
}
});
}
public static void main(String args[]){
Conn main=new Conn();
main.Myframe();
}
}
2018-03-19 13:38
