数据库基础入门（三）——通过JDBC对数据库进行增删改查操作

╰半夏微凉° 2022-04-12 10:46 278阅读 0赞

何谓JDBC？

JDK提供了一组API，让我们可以在java程序中连结到网络上的数据库，并执行SQL语句返回执行结果，这组API的应用我们通常称作JDBC技术；相关的API都在包java.sql.\*下面。

Connection对象，则是由java.sql.DriverManager类的静态方法getConnection(…)得到，一但应用程序中得取一个Connection对象，即应用程序与数据库创建立了连结。随后，我们就可以通过操作Connection对象，创建Statement对象以执行sql语句，或从执行结果返回的ResultSet中取得查询结果。

以下是具体代码实现：

1)连接到数据库：

需要注意的是以下的几个参数，URL：本地用户localhost端口号默认为3306后面是数据库的名字。Username默认为root，密码就是你设置的数据库密码。Driver：MySQL的驱动名应写成(驱动jar包要从www.mysql.org上下载):com.mysql.jdbc.Driver

如果是没有加载驱动将会出现找不到驱动的错误：

![找不到驱动.png][.png]

2）使用预编译sql

数据库处理SQL语句时，需要一个预编译过程，数据库可以把一些格式固定的SQL编译后，存入在其内存池中，再次执行时即直接使用，不再执行预编译过程，这样可以有效提高数据库操作效率；我们可以通过预编译对象实现，如下代码示例：

每一个问号代表了一个表中的数值。其中的：pstmt.setString(1, username);1代表的是第几个占位符，既不能多也不能重复使用。

连结对象创建成功后，即可通过连结对象创建statement对象，以执行SQL语句。我们可将要执行的SQL语句分为两类，一类为需要返回结果表的select语句；一类为执行insert、update、delete操作的语句，因用程序只需要这类语句返回操作所生效的行数即可；对于这两种SQL操作，Statement在执行时可采用不同的方法，如是select语句，则使用executeQuery(sql)方法返回一个ResultSet对象，其中包含查询到的数据；如是另外三种，则使用executeUpdate(sql)方法，返回一个int型值，代表语句所影响的行数，如下代码示例：

一下是针对具体项目的完整代码：

<table> 
 <tbody style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
  <tr style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div> 
    <div>
      11 
    </div> 
    <div>
      12 
    </div> 
    <div>
      13 
    </div> 
    <div>
      14 
    </div> 
    <div>
      15 
    </div> 
    <div>
      16 
    </div> 
    <div>
      17 
    </div> 
    <div>
      18 
    </div> 
    <div>
      19 
    </div> 
    <div>
      20 
    </div> 
    <div>
      21 
    </div> 
    <div>
      22 
    </div> 
    <div>
      23 
    </div> 
    <div>
      24 
    </div> 
    <div>
      25 
    </div> 
    <div>
      26 
    </div> 
    <div>
      27 
    </div> 
    <div>
      28 
    </div> 
    <div>
      29 
    </div> 
    <div>
      30 
    </div> 
    <div>
      31 
    </div> 
    <div>
      32 
    </div> 
    <div>
      33 
    </div> 
    <div>
      34 
    </div> 
    <div>
      35 
    </div> 
    <div>
      36 
    </div> 
    <div>
      37 
    </div> 
    <div>
      38 
    </div> 
    <div>
      39 
    </div> 
    <div>
      40 
    </div> 
    <div>
      41 
    </div> 
    <div>
      42 
    </div> 
    <div>
      43 
    </div> 
    <div>
      44 
    </div> 
    <div>
      45 
    </div> 
    <div>
      46 
    </div> 
    <div>
      47 
    </div> 
    <div>
      48 
    </div> 
    <div>
      49 
    </div> 
    <div>
      50 
    </div> 
    <div>
      51 
    </div> 
    <div>
      52 
    </div> 
    <div>
      53 
    </div> 
    <div>
      54 
    </div> 
    <div>
      55 
    </div> 
    <div>
      56 
    </div> 
    <div>
      57 
    </div> 
    <div>
      58 
    </div> 
    <div>
      59 
    </div> 
    <div>
      60 
    </div> 
    <div>
      61 
    </div> 
    <div>
      62 
    </div> 
    <div>
      63 
    </div> 
    <div>
      64 
    </div> 
    <div>
      65 
    </div> 
    <div>
      66 
    </div> 
    <div>
      67 
    </div> 
    <div>
      68 
    </div> 
    <div>
      69 
    </div> 
    <div>
      70 
    </div> 
    <div>
      71 
    </div> 
    <div>
      72 
    </div> 
    <div>
      73 
    </div> 
    <div>
      74 
    </div> 
    <div>
      75 
    </div> 
    <div>
      76 
    </div> 
    <div>
      77 
    </div> 
    <div>
      78 
    </div> 
    <div>
      79 
    </div> 
    <div>
      80 
    </div> 
    <div>
      81 
    </div> 
    <div>
      82 
    </div> 
    <div>
      83 
    </div> 
    <div>
      84 
    </div> 
    <div>
      85 
    </div> 
    <div>
      86 
    </div> 
    <div>
      87 
    </div> 
    <div>
      88 
    </div> 
    <div>
      89 
    </div> 
    <div>
      90 
    </div> 
    <div>
      91 
    </div> 
    <div>
      92 
    </div> 
    <div>
      93 
    </div> 
    <div>
      94 
    </div> 
    <div>
      95 
    </div> 
    <div>
      96 
    </div> 
    <div>
      97 
    </div> 
    <div>
      98 
    </div> 
    <div>
      99 
    </div> 
    <div>
      100 
    </div> 
    <div>
      101 
    </div> 
    <div>
      102 
    </div> 
    <div>
      103 
    </div> 
    <div>
      104 
    </div> 
    <div>
      105 
    </div> 
    <div>
      106 
    </div> 
    <div>
      107 
    </div> 
    <div>
      108 
    </div> 
    <div>
      109 
    </div> 
    <div>
      110 
    </div> 
    <div>
      111 
    </div> 
    <div>
      112 
    </div> 
    <div>
      113 
    </div> 
    <div>
      114 
    </div> 
    <div>
      115 
    </div> 
    <div>
      116 
    </div> 
    <div>
      117 
    </div> 
    <div>
      118 
    </div> 
    <div>
      119 
    </div> 
    <div>
      120 
    </div> 
    <div>
      121 
    </div> 
    <div>
      122 
    </div> 
    <div>
      123 
    </div> 
    <div>
      124 
    </div> 
    <div>
      125 
    </div> 
    <div>
      126 
    </div> 
    <div>
      127 
    </div> 
    <div>
      128 
    </div> 
    <div>
      129 
    </div> 
    <div>
      130 
    </div> 
    <div>
      131 
    </div> 
    <div>
      132 
    </div> 
    <div>
      133 
    </div> 
    <div>
      134 
    </div> 
    <div>
      135 
    </div> 
    <div>
      136 
    </div> 
    <div>
      137 
    </div> 
    <div>
      138 
    </div> 
    <div>
      139 
    </div> 
    <div>
      140 
    </div> 
    <div>
      141 
    </div> 
    <div>
      142 
    </div> 
    <div>
      143 
    </div> 
    <div>
      144 
    </div> 
    <div>
      145 
    </div> 
    <div>
      146 
    </div> 
    <div>
      147 
    </div> 
    <div>
      148 
    </div> 
    <div>
      149 
    </div> 
    <div>
      150 
    </div> 
    <div>
      151 
    </div> 
    <div>
      152 
    </div> 
    <div>
      153 
    </div> 
    <div>
      154 
    </div> 
    <div>
      155 
    </div> 
    <div>
      156 
    </div> 
    <div>
      157 
    </div> 
    <div>
      158 
    </div> 
    <div>
      159 
    </div> 
    <div>
      160 
    </div> 
    <div>
      161 
    </div> 
    <div>
      162 
    </div> 
    <div>
      163 
    </div> 
    <div>
      164 
    </div> 
    <div>
      165 
    </div> 
    <div>
      166 
    </div> 
    <div>
      167 
    </div> 
    <div>
      168 
    </div> 
    <div>
      169 
    </div> 
    <div>
      170 
    </div> 
    <div>
      171 
    </div> 
    <div>
      172 
    </div> 
    <div>
      173 
    </div> 
    <div>
      174 
    </div> 
    <div>
      175 
    </div> 
    <div>
      176 
    </div> 
    <div>
      177 
    </div> 
    <div>
      178 
    </div> 
    <div>
      179 
    </div> 
    <div>
      180 
    </div> 
    <div>
      181 
    </div> 
    <div>
      182 
    </div> 
    <div>
      183 
    </div> 
    <div>
      184 
    </div> 
    <div>
      185 
    </div> 
    <div>
      186 
    </div> 
    <div>
      187 
    </div> 
    <div>
      188 
    </div> 
    <div>
      189 
    </div> 
    <div>
      190 
    </div> 
    <div>
      191 
    </div> 
    <div>
      192 
    </div> 
    <div>
      193 
    </div> 
    <div>
      194 
    </div> 
    <div>
      195 
    </div> 
    <div>
      196 
    </div> 
    <div>
      197 
    </div> 
    <div>
      198 
    </div> 
    <div>
      199 
    </div> 
    <div>
      200 
    </div> 
    <div>
      201 
    </div> 
    <div>
      202 
    </div> 
    <div>
      203 
    </div> 
    <div>
      204 
    </div> 
    <div>
      205 
    </div> 
    <div>
      206 
    </div> 
    <div>
      207 
    </div> 
    <div>
      208 
    </div> 
    <div>
      209 
    </div> 
    <div>
      210 
    </div> 
    <div>
      211 
    </div> 
    <div>
      212 
    </div> 
    <div>
      213 
    </div> 
    <div>
      214 
    </div> 
    <div>
      215 
    </div> 
    <div>
      216 
    </div> 
    <div>
      217 
    </div> 
    <div>
      218 
    </div> </td> 
   <td style="background:none;width:669px;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
    <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">import</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">java.sql.Connection;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">import</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">java.sql.DriverManager;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">import</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">java.sql.PreparedStatement;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">import</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">java.sql.ResultSet;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">import</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">java.sql.SQLException;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">
       &nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">class</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Petsdb&nbsp;{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">static</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">main(String[]&nbsp;args)&nbsp;{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Petsdb&nbsp;db&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">new</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Petsdb();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//查询</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">db.queryMember(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"昭进"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//添加</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.addMember("昭进","123456","123456");</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//删除字段</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">db.delete_field();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//增加字段</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.add_field();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//删除用户</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.delete_user("昭进");</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//修改用户数据</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.update("new昭进",&nbsp;1);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;获取链接对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@return&nbsp;connection对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;getConnection()&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">throws</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">InstantiationException,&nbsp;IllegalAccessException,&nbsp;ClassNotFoundException,&nbsp;SQLException{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;conn&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">null</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;url&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"jdbc:mysql://localhost:3306/pets"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;//连接数据库的URL地址</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;username&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"root"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//连接数据库的用户名</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;password&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"123456"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//连接数据库的密码</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;driver&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"com.mysql.jdbc.Driver"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//加载驱动，然后再实例化驱动对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Class.forName(driver).newInstance();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//建立连接对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">conn&nbsp;=&nbsp;DriverManager.getConnection(url,&nbsp;username,&nbsp;password);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">return</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">conn;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;添加用户</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;username用户名</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;password密码</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;mail邮箱</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">addMember(String&nbsp;username,String&nbsp;password,String&nbsp;mail){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"insert&nbsp;into&nbsp;user(username,password,mail)&nbsp;values(?,?,?)"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//给每一个？占位符指定数据</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">1</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;username);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">2</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;password);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">3</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;mail);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">
       &nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">count&nbsp;=&nbsp;pstmt.executeUpdate();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行并记录次数</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">if</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(count&gt;</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">0</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"插入数据成功！影响的记录条数是"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">else</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"插入数据失败！"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**&nbsp;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;查询用户</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;condition&nbsp;查询条件</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">queryMember(String&nbsp;condition){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql2&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"select&nbsp;*&nbsp;from&nbsp;user&nbsp;where&nbsp;username&nbsp;=&nbsp;?"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //获取拼接SQL的执行对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Statement&nbsp;stmt&nbsp;=&nbsp;con.createStatement();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //执行拼接SQL语句返回一个结果集对象</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet&nbsp;rs&nbsp;=&nbsp;stmt.executeQuery(sql1);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql2);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//给每一个？占位符指定数据</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">1</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;condition);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">ResultSet&nbsp;rs&nbsp;=&nbsp;pstmt.executeQuery();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;username&nbsp;&nbsp;&nbsp;&nbsp;password&nbsp;&nbsp;&nbsp;&nbsp;mail"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">while</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(rs.next()){ </code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//检测是否还有下一条记录</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">id&nbsp;=&nbsp;rs.getInt(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"id"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;username&nbsp;=&nbsp;rs.getString(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"username"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;password&nbsp;=&nbsp;rs.getString(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"password"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;mail&nbsp;=&nbsp;rs.getString(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"mail"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(id+</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+username+</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+password+</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"&nbsp;&nbsp;&nbsp;&nbsp;"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+mail);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;删除字段</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">delete_field(){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"alter&nbsp;table&nbsp;user&nbsp;drop&nbsp;sex"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">count&nbsp;=&nbsp;pstmt.executeUpdate();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行并记录次数</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//判断如何执行成功？pstmt.executeUpdate();只返回被影响行数&nbsp;count=0;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(count&gt;0){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("删除字段成功！影响的记录条数是"+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("删除字段失败！"+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;添加字段&nbsp;&nbsp;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">add_field(){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"alter&nbsp;table&nbsp;user&nbsp;add&nbsp;sex&nbsp;boolean"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">count&nbsp;=&nbsp;pstmt.executeUpdate();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行并记录次数</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//判断如何执行成功？pstmt.executeUpdate();只返回被影响行数&nbsp;count=0;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(count&gt;0){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("添加字段成功！影响的记录条数是"+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("添加字段失败！"+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;删除用户</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;username&nbsp;用户名</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">delete_user(String&nbsp;username){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"delete&nbsp;from&nbsp;user&nbsp;where&nbsp;username&nbsp;=&nbsp;?"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//给每一个？占位符指定数据</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">1</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;username);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">count&nbsp;=&nbsp;pstmt.executeUpdate();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行并记录次数</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">if</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(count&gt;</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">0</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"删除数据成功！影响的记录条数是"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">else</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"删除数据失败！"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">/**</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;修改用户资料</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;username用户名</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*&nbsp;@param&nbsp;id用户id</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#808080;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">*/</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">public</code>&nbsp; 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">void</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">update(String&nbsp;username,</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">id){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">try</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">Connection&nbsp;con&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">this</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">.getConnection();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//定义SQL语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">String&nbsp;sql&nbsp;=&nbsp;</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"update&nbsp;user&nbsp;set&nbsp;username&nbsp;=&nbsp;?&nbsp;where&nbsp;id&nbsp;=&nbsp;?"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">;</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//获取预编译SQL执行对象，同时检测数据库中是否已经存在该SQL语句，如果存在，不存入SQL语句，如果不存在则存入ＳＱＬ语句</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">PreparedStatement&nbsp;pstmt&nbsp;=&nbsp;con.prepareStatement(sql);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//给每一个？占位符指定数据</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setString(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">1</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;username);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">pstmt.setInt(</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">2</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">,&nbsp;id);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">int</code>&nbsp; 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">count&nbsp;=&nbsp;pstmt.executeUpdate();</code> 
      <code style="background:none;text-align:left;color:#008200;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">//执行并记录次数</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">if</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(count&gt;</code> 
      <code style="background:none;text-align:left;color:#009900;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">0</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"修改数据成功！影响的记录条数是"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">+count);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">else</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">{ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">System.out.println(</code> 
      <code style="background:none;text-align:left;color:#0000FF;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">"修改数据失败！"</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">);</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
      <code style="background:none;text-align:left;color:#ff7800;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:bold;vertical-align:baseline;">catch</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">(Exception&nbsp;e){ </code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">e.printStackTrace();</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#c7254e;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">&nbsp;&nbsp;&nbsp;&nbsp;</code>&nbsp; 
     </div> 
     <div style="background:none;text-align:left;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;"> 
      <code style="background:none;text-align:left;color:#000000;line-height:1.1em;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;font-size:13px;font-style:normal;font-weight:normal;vertical-align:baseline;">}</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

[.png]: /images/20220412/2dba4aac87d74f72a376870cdf9238d8.png