java怎么将选中的多行数据插入表中

java 连接数据库时，往数据库一次添加多条数据，可以在 DAO 层，使用

executeBatch0批量插入数据，如下代

码：

conn = DBToolkit .getConnection0

Statement stmt =

conn . createStatementO j /／连续添加多条 SQL

stmt . addBatch (" insert into testdb . book ( kind , name ) values ( java ', java in j

aciton )＂)

stmt . addBatc (" insert into testdb . book ( kind , name ) values ( c ＇,’ c in aciton )＂)/／执行批量执行

stmt .executeBatch0)

import javax.swing.*

import javax.swing.event.TreeSelectionEvent

import javax.swing.event.TreeSelectionListener

import javax.swing.table.DefaultTableModel

import javax.swing.tree.DefaultMutableTreeNode

import java.awt.*

import java.util.*

import java.util.List

public class StudentManage extends JFrame{

    public final static String[] CH_NUM = {"一","二","三","四","五","六","七","八","九","十"}

    public final static String ROOT = "班级管理"

    public final static int GRADE_NUM = 3

    public final static int CLASS_NUM = 3

    private Map<String, List<Student>> classes

    public StudentManage() {

        setTitle("学生管理系统")

        setSize(300, 300)

        setLayout(new BorderLayout())

        if(classes == null) classes = new HashMap<>()

        DefaultMutableTreeNode top = new DefaultMutableTreeNode(ROOT)

        DefaultMutableTreeNode[] gradeNodes = new DefaultMutableTreeNode[GRADE_NUM]

        for (int i = 0 i < GRADE_NUM i++) {

            gradeNodes[i] = new DefaultMutableTreeNode(CH_NUM[i] + "年级")

            for (int j = 0 j < CLASS_NUM j++) {

                gradeNodes[i].add(new DefaultMutableTreeNode(CH_NUM[j] + "班"))

            }

            top.add(gradeNodes[i])

        }

        final JTree tree = new JTree(top)

        String title[] = {"ID","姓名","性别","年龄","地址"}

        final DefaultTableModel model = new DefaultTableModel(title, 0)

        JTable table=new JTable(model)

        tree.addTreeSelectionListener(new TreeSelectionListener() {

            @Override

            public void valueChanged(TreeSelectionEvent e) {

                DefaultMutableTreeNode node = (DefaultMutableTreeNode) tree .getLastSelectedPathComponent()

                if (node == null) return

                Object object = node.getUserObject()

                if (node.isLeaf()) {

                    List<Student> stdList = classes.get(getFullPath(node))

                    Object[][] data = new Object[stdList.size()][5]

                    for (int i = 0 i < stdList.size() i++) {

                        data[i][0] = stdList.get(i).getId()

                        data[i][1] = stdList.get(i).getName()

                        data[i][2] = stdList.get(i).getSex()

                        data[i][3] = stdList.get(i).getAge()

                        data[i][4] = stdList.get(i).getAddress()

                    }

                    while(model.getRowCount()>0){

                        model.removeRow(model.getRowCount()-1)

                    }

                    for (int i = 0 i < stdList.size() i++) {

                        model.addRow(data[i])

                    }

                    model.fireTableDataChanged()

                }

            }

        })

        add(tree, BorderLayout.WEST)

        add(new JScrollPane(table), BorderLayout.CENTER)

        setVisible(true)

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)

    }

    private String getFullPath(DefaultMutableTreeNode defaultMutableTreeNode){

        StringBuilder sb = new StringBuilder()

        Object[] objs = defaultMutableTreeNode.getUserObjectPath()

        for (int i = 0 i < objs.length i++) {

            sb.append(objs[i])

        }

        return sb.toString().replace(ROOT,"")

    }

    public void init(){

        for (int i = 0 i < GRADE_NUM i++) {

            for (int j = 0 j < CLASS_NUM j++) {

                int n = new Random().nextInt(30)+1

                List<Student> stdList = new ArrayList<>(n)

                for (int k = 0 k < n k++) {

                    stdList.add(new Student(k,"学生"+k,"男",

                            12,“”))

                }

                classes.put(CH_NUM[i] + "年级"+ CH_NUM[j] +"班", stdList)

            }

        }

    }

    public static void main(String[] args) {

        StudentManage studentManage = new StudentManage()

        studentManage.init()

    }

}

class Student {

    private int id

    private String name

    private String sex

    private int age

    private String address

    public Student(int id, String name, String sex, int age, String address) {

        this.id = id

        this.name = name

        this.sex = sex

        this.age = age

        this.address = address

    }

    public Student() {

    }

    public int getId() {

        return id

    }

    public String getName() {

        return name

    }

    public String getSex() {

        return sex

    }

    public int getAge() {

        return age

    }

    public String getAddress() {

        return address

    }

    @Override

    public String toString() {

        return "Student{" +

                "id=" + id +

                ", name='" + name + '\'' +

                ", sex='" + sex + '\'' +

                ", age=" + age +

                ", address='" + address + '\'' +

                '}'

    }

}

---