sql与mysql可视化增删改查.docVIP

MYSQL与SQL可视化增，删，改 建立表格： 属性: public JTable table; public DefaultTableModel dftm; public String[] columnNames = new String[] { 序号, 用户名, 密码 }; // 定义数组表示表格标题 dftm = new DefaultTableModel(null, columnNames); /*for (int i = 0; i 10; i++) { Object[] content = { 1, 2, 3 }; dftm.addRow(content);// 增加行 }*/ initTable(dftm); JTable table = new JTable(dftm);// 根据TableModel显示内容 JScrollPane src = new JScrollPane(table); //给表格增加滚动条 src.setBounds(50, 150, 500, 200); //设置滚动条位置与大小 contentPane.add(src); 2.“修改用户”按钮的代码： JButton rewamp = new JButton(\u4FEE\u6539\u7528\u6237); rewamp.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int id=Integer.parseInt(txtId.getText()); String name=txtName.getText();//取得用户名文本框的值 String pwd=txtPwd.getText();//取得用户密码文本框的值 String sqlUpdate=UPDATE userlist set name= + name+, password=+pwd+ where Id=+id; DBComm dbco=new DBComm(); dbco.openConnection(); try { dbco.executeUpdate(sqlUpdate); dbco.closeConnection(); initTable(dftm); } catch (SQLException e1) { e1.printStackTrace(); } } }); rewamp.setBounds(338, 24, 116, 28); contentPane.add(rewamp); 3.“删除用户”按钮的代码： JButton delete = new JButton(\u5220\u9664\u7528\u6237); delete.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if (JOptionPane.showConfirmDialog(null,您确定要删除ID为 + txtId.getText() + 的用户吗?,,0) == 0) { int id = Integer.parseInt(txtId.getText()); String sqldel = delete from userlist where id= + id; try { DBComm dbco = new DBComm(); dbco.openConnection(); dbco.executeUpdate(sqldel); dbco.closeConnection(); initTable(dftm); } catch (SQLException e1) { e1.printStackTrace(); } } } }); delete.setBounds(198, 24, 116, 28); contentPane.add(delete);