JAVA WEB开发_web开发_java_其他

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/627850b7517cd20ea4a67608/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/627850b7517cd20ea4a67608/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">package com.dao;</div><div class="t m0 x1 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0">import java.sql.*;</div><div class="t m0 x1 h3 y4 ff1 fs0 fc0 sc0 ls0 ws0">import javax.sql.*;</div><div class="t m0 x1 h3 y5 ff1 fs0 fc0 sc0 ls0 ws0">import javax.naming.*;</div><div class="t m0 x1 h3 y6 ff1 fs0 fc0 sc0 ls0 ws0">import java.util.ArrayList;</div><div class="t m0 x1 h3 y7 ff1 fs0 fc0 sc0 ls0 ws0">import com.model.CustomerBean;</div><div class="t m0 x1 h3 y8 ff1 fs0 fc0 sc0 ls0 ws0">public class CustomerDAO{</div><div class="t m0 x1 h3 y9 ff1 fs0 fc0 sc0 ls0 ws0"> private static <span class="fc1">InitialContext conte<span class="_ _0"></span>xt</span>= null;</div><div class="t m0 x1 h3 ya ff1 fs0 fc0 sc0 ls0 ws0"> private <span class="fc1">DataSource dataSource<span class="_ _0"></span></span> = null;</div><div class="t m0 x1 h3 yb ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _1"> </span> <span class="_ _1"> </span> private<span class="_ _2"> </span> <span class="fc1">static<span class="_ _3"></span> <span class="_ _3"></span>final<span class="_ _3"></span> <span class="_ _3"></span>String<span class="_ _3"></span> <span class="_ _3"></span>SELE<span class="_ _4"></span>CT_SQL<span class="_ _5"></span> <span class="_ _3"></span>=<span class="_ _3"></span> <span class="_ _3"></span>"SELECT<span class="_ _5"></span> <span class="_ _3"></span>*<span class="_ _3"></span> <span class="_ _3"></span>FROM</span></div><div class="t m0 x1 h3 yc ff1 fs0 fc1 sc0 ls0 ws0">customer";</div><div class="t m0 x1 h3 yd ff1 fs0 fc0 sc0 ls0 ws0"> private static final String GET_ONE_SQL<span class="_ _6"></span> = </div></div></div><div class="pi" data-data='{"ctm":[1.338445,0.000000,0.000000,1.338445,0.000000,0.000000]}'></div></div> </body> </html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/627850b7517cd20ea4a67608/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x2 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">"SELECT<span class="_ _7"> </span> <span class="_ _8"> </span>custName,email,phone<span class="_ _8"> </span> <span class="_ _8"> </span>FROM<span class="_ _8"> </span> <span class="_ _8"> </span>customer</div><div class="t m0 x1 h3 ye ff1 fs0 fc0 sc0 ls0 ws0">WHERE custName=?";</div><div class="t m0 x1 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _9"> </span> <span class="_ _9"> </span> private<span class="_ _a"> </span> <span class="_ _a"> </span>static<span class="_ _2"> </span> <span class="_ _a"> </span>final<span class="_ _a"> </span> <span class="_ _2"> </span>String<span class="_ _a"> </span> <span class="_ _a"> </span>INSER<span class="_ _b"></span>T_SQL<span class="_ _c"></span> <span class="_ _a"> </span>=<span class="_ _2"> </span> <span class="_ _a"> </span>"INSER<span class="_ _b"></span>T<span class="_ _2"> </span> <span class="_ _a"> </span>INT<span class="_ _4"></span>O</div><div class="t m0 x1 h3 y4 ff1 fs0 fc0 sc0 ls0 ws0">customer <span class="_ _4"></span>V<span class="_ _d"></span>ALUES(?,?,?)";</div><div class="t m0 x1 h3 y5 ff1 fs0 fc0 sc0 ls0 ws0"> private static final String DELETE_SQL<span class="_ _6"></span> = </div><div class="t m0 x2 h3 y6 ff1 fs0 fc0 sc0 ls0 ws0">"DELETE FROM customers <span class="_ _4"></span>WHERE custName = ?";</div><div class="t m0 x1 h3 y7 ff1 fs0 fc0 sc0 ls0 ws0"> private static final String UPDA<span class="_ _e"></span>TE_SQL<span class="_ _6"></span> = </div><div class="t m0 x2 h3 yf ff1 fs0 fc0 sc0 ls0 ws0">"UPDA<span class="_ _e"></span>TE<span class="_ _5"></span> customers<span class="_ _5"></span> <span class="_ _0"></span>SET<span class="_ _0"></span> <span class="_ _5"></span>email=?<span class="_ _0"></span> <span class="_ _5"></span>,<span class="_ _0"></span> <span class="_ _5"></span>phone=<span class="_ _4"></span>?<span class="_ _5"></span> WHERE</div><div class="t m0 x1 h3 y8 ff1 fs0 fc0 sc0 ls0 ws0">custName=?";</div><div class="t m0 x1 h3 y9 ff1 fs0 fc0 sc0 ls0 ws0"> </div><div class="t m0 x1 h3 ya ff1 fs0 fc1 sc0 ls0 ws0"> public CustomerDAO(){</div><div class="t m0 x1 h3 yb ff1 fs0 fc1 sc0 ls0 ws0"> <span class="_ _f"> </span>try{</div><div class="t m0 x1 h3 yc ff1 fs0 fc1 sc0 ls0 ws0"> <span class="_ _f"> </span> if(context == null){</div><div class="t m0 x3 h3 yd ff1 fs0 fc1 sc0 ls0 ws0"> context = new InitialContext();</div></div></div><div class="pi" data-data='{"ctm":[1.338445,0.000000,0.000000,1.338445,0.000000,0.000000]}'></div></div>