String query="select * from hdxcy_info where XcyName='"+XcyName+"'";

            String sqlStr="insert into hdxcy_info values('"+XcyName+"','"+sex+"','"+ID+"','"+address+"','"+Telephone+"','"+QQ+"','"+beizhu+"')";

               //设置连接

            database.setConnection("com.mysql.jdbc.Driver","jdbc:mysql://localhost:3306/erlake_hdxcxm","root","zhangweijie");

            //调用DatabaseBean中的设置SQL语句 方法

            database.setSqlStr(query);

            ResultSet rs=database.getResult();

            //查看是否已经有记录

            if(rs.next())//已经有记录，报错

            {

                  out.println("<script> alert('该巡查员信息已经添加过')</script>");

                  out.println("<h3 align='center' style='color:red'>添加失败</h3>");

            }

            else//没有记录，添加，并给出添加的信息

            {

                database.setSqlStr(sqlStr);

                database.insertData();

                out.println("<h4 align='center'>数据表操作成功！已添加巡查员："+XcyName+"的信息.</h4><br>");

                 out.println("<div align='center'> <table border>");

                 out.println("<tr><td>巡查员：</td><td>"+XcyName+"</td>");

                 out.println("<tr><td>性别</td><td>"+sex+"</td>");

                 out.println("<tr><td>省份证号：</td><td>"+ID+"</td>");

                 out.println("<tr><td>家庭住址：</td><td>"+address+"</td>");

                 out.println("<tr><td>联系电话：</td><td>"+Telephone+"</td>");

                 out.println("<tr><td>QQ号：</td><td>"+QQ+"</td>");

                 out.println("<tr><td>备注：</td><td>"+beizhu+"</td>");

                 out.println("</table></div>");

             }