如何使用 JDBC 从插入的查询中获取主键值（自动生成的键）？

迈不过友情╰ 2023-09-29 09:14 6阅读 0赞

在这篇文章中，我们将学习如何使用 JDBC 从插入的查询中获取主键值（自动生成的键）？

**eclipse中的项目结构：**

![c2de9c90397a54642ee27df55069ab38.png][]

在 MySQL中创建**employee\_table的 SQL 查询（** **jdbcdb**模式）

<table style="margin-left:-21px;"> 
 <tbody> 
  <tr> 
   <td style="background-color:#eeeeee;text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">1</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">2</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">3</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">4</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">5</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">6</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">7</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">8</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">9</span></span> 
     </div> 
    </div> </td> 
   <td style="text-align:left;vertical-align:top;width:654.406px;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">CREATE </span><span style="color:#000000;">TABLE</span> <span style="color:#000000;">`</span><span style="color:#000000;">employee_table</span><span style="color:#000000;">`</span> <span style="color:#000000;">(</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">employee_id</span><span style="color:#000000;">`</span> <span style="color:#800080;">int</span><span style="color:#000000;">(</span><span style="color:#0828fb;">11</span><span style="color:#000000;">)</span> <span style="color:#800080;">NOT</span> <span style="color:#800080;">NULL</span> <span style="color:#000000;">auto_increment</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">employee_name</span><span style="color:#000000;">`</span> <span style="color:#000000;">varchar</span><span style="color:#000000;">(</span><span style="color:#0828fb;">60</span><span style="color:#000000;">)</span> <span style="color:#800080;">NOT</span> <span style="color:#800080;">NULL</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">email</span><span style="color:#000000;">`</span> <span style="color:#000000;">varchar</span><span style="color:#000000;">(</span><span style="color:#0828fb;">45</span><span style="color:#000000;">)</span> <span style="color:#800080;">NOT</span> <span style="color:#800080;">NULL</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">salary</span><span style="color:#000000;">`</span> <span style="color:#800080;">double</span> <span style="color:#800080;">default</span> <span style="color:#800080;">NULL</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">date_of_joining</span><span style="color:#000000;">`</span> <span style="color:#000000;">datetime </span><span style="color:#800080;">default</span> <span style="color:#800080;">NULL</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">`</span><span style="color:#000000;">bonus</span><span style="color:#000000;">`</span> <span style="color:#000000;">decimal</span><span style="color:#000000;">(</span><span style="color:#0828fb;">10</span><span style="color:#000000;">,</span><span style="color:#0828fb;">0</span><span style="color:#000000;">)</span> <span style="color:#800080;">default</span> <span style="color:#800080;">NULL</span><span style="color:#000000;">,</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;&nbsp;<span style="color:#000000;">PRIMARY </span><span style="color:#000000;">KEY</span>&nbsp;&nbsp;<span style="color:#000000;">(</span><span style="color:#000000;">`</span><span style="color:#000000;">employee_id</span><span style="color:#000000;">`</span><span style="color:#000000;">)</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">)</span> <span style="color:#000000;">;</span></span></span> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**DBUtil.java** 类，负责连接 MySQL 数据库。

模型类 **Employee.java**

<table style="margin-left:-30px;"> 
 <tbody> 
  <tr> 
   <td style="background-color:#eeeeee;text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">1</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">2</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">3</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">4</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">5</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">6</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">7</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">8</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">9</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">10</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">11</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">12</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">13</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">14</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">15</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">16</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">17</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">18</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">19</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">20</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">21</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">22</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">23</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">24</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">25</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">26</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">27</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">28</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">29</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">30</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">31</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">32</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">33</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">34</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">35</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">36</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">37</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">38</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">39</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">40</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">41</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">42</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">43</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">44</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">45</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">46</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">47</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">48</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">49</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">50</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">51</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">52</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">53</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">54</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">55</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">56</span></span></span> 
     </div> 
    </div> </td> 
   <td style="text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">package</span> <span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">model</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">math</span><span style="color:#000000;">.</span><span style="color:#000000;">BigDecimal</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">Date</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">class</span> <span style="color:#000000;">Employee</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#800080;">int</span> <span style="color:#000000;">employee_id</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#800080;">String</span> <span style="color:#000000;">employeeName</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#800080;">String</span> <span style="color:#000000;">email</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#800080;">Double</span> <span style="color:#000000;">salary</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#000000;">Date </span><span style="color:#000000;">doj</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#000000;">BigDecimal </span><span style="color:#000000;">bonus</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">int</span> <span style="color:#000000;">getEmployee_id</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">employee_id</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setEmployee_id</span><span style="color:#000000;">(</span><span style="color:#800080;">int</span> <span style="color:#000000;">employee_id</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">employee_id</span> <span style="color:#000000;">=</span> <span style="color:#000000;">employee_id</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">String</span> <span style="color:#000000;">getEmployeeName</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">employeeName</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setEmployeeName</span><span style="color:#000000;">(</span><span style="color:#800080;">String</span> <span style="color:#000000;">employeeName</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">employeeName</span> <span style="color:#000000;">=</span> <span style="color:#000000;">employeeName</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">String</span> <span style="color:#000000;">getEmail</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">email</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setEmail</span><span style="color:#000000;">(</span><span style="color:#800080;">String</span> <span style="color:#000000;">email</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">email</span> <span style="color:#000000;">=</span> <span style="color:#000000;">email</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">Double</span> <span style="color:#000000;">getSalary</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">salary</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setSalary</span><span style="color:#000000;">(</span><span style="color:#800080;">Double</span> <span style="color:#000000;">salary</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">salary</span> <span style="color:#000000;">=</span> <span style="color:#000000;">salary</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#000000;">Date </span><span style="color:#000000;">getDoj</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">doj</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setDoj</span><span style="color:#000000;">(</span><span style="color:#000000;">Date </span><span style="color:#000000;">doj</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">doj</span> <span style="color:#000000;">=</span> <span style="color:#000000;">doj</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#000000;">BigDecimal </span><span style="color:#000000;">getBonus</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">bonus</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">setBonus</span><span style="color:#000000;">(</span><span style="color:#000000;">BigDecimal </span><span style="color:#000000;">bonus</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">this</span><span style="color:#000000;">.</span><span style="color:#000000;">bonus</span> <span style="color:#000000;">=</span> <span style="color:#000000;">bonus</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">@</span><span style="color:#000000;">Override</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">String</span> <span style="color:#000000;">toString</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#0828fb;">"Employee [employee_id="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">employee_id</span> <span style="color:#000000;">+</span> <span style="color:#0828fb;">", employeeName="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">employeeName</span> <span style="color:#000000;">+</span> <span style="color:#0828fb;">", email="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">email</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">+</span> <span style="color:#0828fb;">", salary="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">salary</span> <span style="color:#000000;">+</span> <span style="color:#0828fb;">", doj="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">doj</span> <span style="color:#000000;">+</span> <span style="color:#0828fb;">", bonus="</span> <span style="color:#000000;">+</span> <span style="color:#000000;">bonus</span> <span style="color:#000000;">+</span> <span style="color:#0828fb;">"]"</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

DAO 接口及其实现

<table style="margin-left:-21px;"> 
 <tbody> 
  <tr> 
   <td style="background-color:#eeeeee;text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">1</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">2</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">3</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">4</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">5</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">6</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">7</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">8</span></span></span> 
     </div> 
    </div> </td> 
   <td style="text-align:left;vertical-align:top;width:682.188px;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">package</span> <span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">dao</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">List</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">model</span><span style="color:#000000;">.</span><span style="color:#000000;">Employee</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">interface</span> <span style="color:#000000;">EmployeeDAO</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">abstract</span> <span style="color:#800080;">void</span> <span style="color:#000000;">createEmployees</span><span style="color:#000000;">(</span><span style="color:#000000;">List</span><span style="color:#000000;">&lt;</span><span style="color:#000000;">Employee</span><span style="color:#000000;">&gt;</span> <span style="color:#000000;">employeeList</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

<table style="margin-left:-30px;"> 
 <tbody> 
  <tr> 
   <td style="background-color:#eeeeee;text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">1</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">2</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">3</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">4</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">5</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">6</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">7</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">8</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">9</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">10</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">11</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">12</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">13</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">14</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">15</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">16</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">17</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">18</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">19</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">20</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">21</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">22</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">23</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">24</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">25</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">26</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">27</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">28</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">29</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">30</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">31</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">32</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">33</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">34</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">35</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">36</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">37</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">38</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">39</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">40</span></span></span> 
     </div> 
    </div> </td> 
   <td style="text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">package</span> <span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">dao</span><span style="color:#000000;">.</span><span style="color:#000000;">impl</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">sql</span><span style="color:#000000;">.</span><span style="color:#000000;">Connection</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">sql</span><span style="color:#000000;">.</span><span style="color:#000000;">Date</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">sql</span><span style="color:#000000;">.</span><span style="color:#000000;">PreparedStatement</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">sql</span><span style="color:#000000;">.</span><span style="color:#000000;">ResultSet</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">List</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">dao</span><span style="color:#000000;">.</span><span style="color:#000000;">EmployeeDAO</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">model</span><span style="color:#000000;">.</span><span style="color:#000000;">Employee</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">DBUtil</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">mysql</span><span style="color:#000000;">.</span><span style="color:#000000;">jdbc</span><span style="color:#000000;">.</span><span style="color:#000000;">Statement</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">class</span> <span style="color:#000000;">EmployeeDAOImpl</span> <span style="color:#800080;">implements</span> <span style="color:#000000;">EmployeeDAO</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">@</span><span style="color:#000000;">Override</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">void</span> <span style="color:#000000;">createEmployees</span><span style="color:#000000;">(</span><span style="color:#000000;">List</span><span style="color:#000000;">&lt;</span><span style="color:#000000;">Employee</span><span style="color:#000000;">&gt;</span> <span style="color:#000000;">employeeList</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">String</span> <span style="color:#000000;">SQL</span> <span style="color:#000000;">=</span> <span style="color:#0828fb;">"INSERT INTO employee_table(employee_name,email,salary,date_of_joining,bonus)VALUES(?,?,?,?,?)"</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">try</span><span style="color:#000000;">(</span><span style="color:#000000;">Connection </span><span style="color:#000000;">connection</span> <span style="color:#000000;">=</span> <span style="color:#000000;">DBUtil</span><span style="color:#000000;">.</span><span style="color:#000000;">getConnection</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span><span style="color:#000000;">PreparedStatement </span><span style="color:#000000;">ps</span> <span style="color:#000000;">=</span> <span style="color:#000000;">connection</span><span style="color:#000000;">.</span><span style="color:#000000;">prepareStatement</span><span style="color:#000000;">(</span><span style="color:#000000;">SQL</span><span style="color:#000000;">,</span><span style="color:#000000;">Statement</span><span style="color:#000000;">.</span><span style="color:#000000;">RETURN_GENERATED_KEYS</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">for</span> <span style="color:#000000;">(</span><span style="color:#000000;">Employee </span><span style="color:#000000;">employee</span> <span style="color:#000000;">:</span> <span style="color:#000000;">employeeList</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">setString</span><span style="color:#000000;">(</span><span style="color:#0828fb;">1</span><span style="color:#000000;">,</span> <span style="color:#000000;">employee</span><span style="color:#000000;">.</span><span style="color:#000000;">getEmployeeName</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">setString</span><span style="color:#000000;">(</span><span style="color:#0828fb;">2</span><span style="color:#000000;">,</span> <span style="color:#000000;">employee</span><span style="color:#000000;">.</span><span style="color:#000000;">getEmail</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">setDouble</span><span style="color:#000000;">(</span><span style="color:#0828fb;">3</span><span style="color:#000000;">,</span> <span style="color:#000000;">employee</span><span style="color:#000000;">.</span><span style="color:#000000;">getSalary</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">setDate</span><span style="color:#000000;">(</span><span style="color:#0828fb;">4</span><span style="color:#000000;">,</span> <span style="color:#800080;">new</span> <span style="color:#000000;">Date</span><span style="color:#000000;">(</span><span style="color:#000000;">employee</span><span style="color:#000000;">.</span><span style="color:#000000;">getDoj</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">.</span><span style="color:#000000;">getTime</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">setBigDecimal</span><span style="color:#000000;">(</span><span style="color:#0828fb;">5</span><span style="color:#000000;">,</span> <span style="color:#000000;">employee</span><span style="color:#000000;">.</span><span style="color:#000000;">getBonus</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">addBatch</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">executeBatch</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">ResultSet </span><span style="color:#000000;">rs</span> <span style="color:#000000;">=</span> <span style="color:#000000;">ps</span><span style="color:#000000;">.</span><span style="color:#000000;">getGeneratedKeys</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">while</span> <span style="color:#000000;">(</span><span style="color:#000000;">rs</span><span style="color:#000000;">.</span><span style="color:#000000;">next</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">System</span><span style="color:#000000;">.</span><span style="color:#000000;">out</span><span style="color:#000000;">.</span><span style="color:#000000;">println</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"Generated Employee ID:"</span><span style="color:#000000;">+</span><span style="color:#000000;">rs</span><span style="color:#000000;">.</span><span style="color:#000000;">getInt</span><span style="color:#000000;">(</span><span style="color:#0828fb;">1</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span> <span style="color:#800080;">catch</span> <span style="color:#000000;">(</span><span style="color:#000000;">Exception</span> <span style="color:#000000;">e</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">e</span><span style="color:#000000;">.</span><span style="color:#000000;">printStackTrace</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

现在让我们运行我们的 **ClientTest.java** 类以从插入的查询中获取主键值 s（自动生成的键）。

<table style="margin-left:-30px;"> 
 <tbody> 
  <tr> 
   <td style="background-color:#eeeeee;text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">1</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">2</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">3</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">4</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">5</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">6</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">7</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">8</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">9</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">10</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">11</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">12</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">13</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">14</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">15</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">16</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">17</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">18</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">19</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">20</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">21</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">22</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">23</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">24</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">25</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">26</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">27</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">28</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">29</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">30</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">31</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">32</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">33</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">34</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">35</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">36</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">37</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">38</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">39</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">40</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">41</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">42</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">43</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">44</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">45</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">46</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">47</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">48</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">49</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">50</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">51</span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">52</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:center;"> 
      <span style="color:#444444;"><span style="color:#000000;">53</span></span> 
     </div> 
    </div> </td> 
   <td style="text-align:left;vertical-align:top;"> 
    <div style="margin-left:0;text-align:left;"> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">package</span> <span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">client</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">math</span><span style="color:#000000;">.</span><span style="color:#000000;">BigDecimal</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">ArrayList</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">Date</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">java</span><span style="color:#000000;">.</span><span style="color:#000000;">util</span><span style="color:#000000;">.</span><span style="color:#000000;">List</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">dao</span><span style="color:#000000;">.</span><span style="color:#000000;">EmployeeDAO</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">dao</span><span style="color:#000000;">.</span><span style="color:#000000;">impl</span><span style="color:#000000;">.</span><span style="color:#000000;">EmployeeDAOImpl</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">import </span><span style="color:#000000;">com</span><span style="color:#000000;">.</span><span style="color:#000000;">infotech</span><span style="color:#000000;">.</span><span style="color:#000000;">model</span><span style="color:#000000;">.</span><span style="color:#000000;">Employee</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#097109;">/**</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#097109;">* @author KK JavaTutorials</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#097109;">*JDBC client program to show How to get primary key value (auto-generated keys) from inserted</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#097109;">* queries using JDBC</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#097109;">*/</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">class</span> <span style="color:#000000;">ClientTest</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">public</span> <span style="color:#800080;">static</span> <span style="color:#800080;">void</span> <span style="color:#000000;">main</span><span style="color:#000000;">(</span><span style="color:#800080;">String</span><span style="color:#000000;">[</span><span style="color:#000000;">]</span> <span style="color:#000000;">args</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">List</span><span style="color:#000000;">&lt;</span><span style="color:#000000;">Employee</span><span style="color:#000000;">&gt;</span> <span style="color:#000000;">employeeList</span> <span style="color:#000000;">=</span> <span style="color:#000000;">getEmployeesList</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">EmployeeDAO </span><span style="color:#000000;">employeeDAO</span> <span style="color:#000000;">=</span> <span style="color:#800080;">new</span> <span style="color:#000000;">EmployeeDAOImpl</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employeeDAO</span><span style="color:#000000;">.</span><span style="color:#000000;">createEmployees</span><span style="color:#000000;">(</span><span style="color:#000000;">employeeList</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">private</span> <span style="color:#800080;">static</span> <span style="color:#000000;">List</span><span style="color:#000000;">&lt;</span><span style="color:#000000;">Employee</span><span style="color:#000000;">&gt;</span> <span style="color:#000000;">getEmployeesList</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span> <span style="color:#000000;">{ </span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;">&nbsp;</span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">Employee </span><span style="color:#000000;">employee1</span> <span style="color:#000000;">=</span> <span style="color:#800080;">new</span> <span style="color:#000000;">Employee</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee1</span><span style="color:#000000;">.</span><span style="color:#000000;">setBonus</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">BigDecimal</span><span style="color:#000000;">(</span><span style="color:#0828fb;">290</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee1</span><span style="color:#000000;">.</span><span style="color:#000000;">setDoj</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">Date</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee1</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmployeeName</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"John"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee1</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmail</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"john.cs2016@yahoo.com"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee1</span><span style="color:#000000;">.</span><span style="color:#000000;">setSalary</span><span style="color:#000000;">(</span><span style="color:#0828fb;">90000.00</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">Employee </span><span style="color:#000000;">employee2</span> <span style="color:#000000;">=</span> <span style="color:#800080;">new</span> <span style="color:#000000;">Employee</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee2</span><span style="color:#000000;">.</span><span style="color:#000000;">setBonus</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">BigDecimal</span><span style="color:#000000;">(</span><span style="color:#0828fb;">290</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee2</span><span style="color:#000000;">.</span><span style="color:#000000;">setDoj</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">Date</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee2</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmployeeName</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"Sean"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee2</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmail</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"sean.cs2006@yahoo.com"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee2</span><span style="color:#000000;">.</span><span style="color:#000000;">setSalary</span><span style="color:#000000;">(</span><span style="color:#0828fb;">40000.00</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">Employee </span><span style="color:#000000;">employee3</span> <span style="color:#000000;">=</span> <span style="color:#800080;">new</span> <span style="color:#000000;">Employee</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee3</span><span style="color:#000000;">.</span><span style="color:#000000;">setBonus</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">BigDecimal</span><span style="color:#000000;">(</span><span style="color:#0828fb;">290</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee3</span><span style="color:#000000;">.</span><span style="color:#000000;">setDoj</span><span style="color:#000000;">(</span><span style="color:#800080;">new</span> <span style="color:#000000;">Date</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee3</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmployeeName</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"Robin"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee3</span><span style="color:#000000;">.</span><span style="color:#000000;">setEmail</span><span style="color:#000000;">(</span><span style="color:#0828fb;">"robin.s2017@yahoo.com"</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">employee3</span><span style="color:#000000;">.</span><span style="color:#000000;">setSalary</span><span style="color:#000000;">(</span><span style="color:#0828fb;">95000.00</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"></div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">List</span><span style="color:#000000;">&lt;</span><span style="color:#000000;">Employee</span><span style="color:#000000;">&gt;</span> <span style="color:#000000;">empList</span> <span style="color:#000000;">=</span> <span style="color:#800080;">new</span> <span style="color:#000000;">ArrayList</span><span style="color:#000000;">&lt;&gt;</span><span style="color:#000000;">(</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span> </span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">empList</span><span style="color:#000000;">.</span><span style="color:#000000;">add</span><span style="color:#000000;">(</span><span style="color:#000000;">employee1</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">empList</span><span style="color:#000000;">.</span><span style="color:#000000;">add</span><span style="color:#000000;">(</span><span style="color:#000000;">employee2</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">empList</span><span style="color:#000000;">.</span><span style="color:#000000;">add</span><span style="color:#000000;">(</span><span style="color:#000000;">employee3</span><span style="color:#000000;">)</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#800080;">return</span> <span style="color:#000000;">empList</span><span style="color:#000000;">;</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
     <div style="margin-left:0;text-align:left;"> 
      <span style="color:#444444;"><span style="color:#000000;"><span style="color:#000000;">}</span></span></span> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

运行 **ClientTest.java** 程序后，您将在 Eclipse 控制台上查看以下输出：

如果您查询数据库employee\_table，您会发现插入了三行主键1,2 和3，如下所示。

![b6a137fcd55db67422fc26d9c661117e.png][]

这就是这个主题的全部内容如何使用 JDBC 从插入的查询中获取主键值（自动生成的键）？

**你可能也会喜欢：**

[如何使用 JDBC 将文件存储在 MySQL 数据库中][JDBC _ MySQL]  
[如何使用 JDBC 从 MySQL 数据库中读取文件/CLOB 数据][JDBC _ MySQL _CLOB]  
[编写和读取 MySQL BLOB/二进制文件][MySQL BLOB]  
[在 JDBC 示例中使用 JDBC ResultSetMetaData][JDBC _ JDBC ResultSetMetaData]

[c2de9c90397a54642ee27df55069ab38.png]: https://img-blog.csdnimg.cn/img_convert/c2de9c90397a54642ee27df55069ab38.png
[b6a137fcd55db67422fc26d9c661117e.png]: https://img-blog.csdnimg.cn/img_convert/b6a137fcd55db67422fc26d9c661117e.png
[JDBC _ MySQL]: https://kkjavatutorials.com/how-to-store-file-in-mysql-database-using-jdbc/
[JDBC _ MySQL _CLOB]: https://kkjavatutorials.com/how-to-read-file-from-mysql-database-using-jdbc/
[MySQL BLOB]: https://kkjavatutorials.com/writing-and-reading-mysql-blob-binary-files-using-jdbc/
[JDBC _ JDBC ResultSetMetaData]: https://kkjavatutorials.com/resultsetmetadata-in-jdbc-example/