{"id":360,"date":"2010-01-17T01:04:00","date_gmt":"2010-01-16T17:04:00","guid":{"rendered":"http:\/\/115.29.108.60\/?p=360"},"modified":"2011-09-26T21:50:30","modified_gmt":"2011-09-26T13:50:30","slug":"package-db","status":"publish","type":"post","link":"http:\/\/115.29.108.60\/?p=360","title":{"rendered":"package db;"},"content":{"rendered":"<p>\u5728QMaster\u5206\u7c7b\u91cc\u8bb0\u5f55\u7684\u76f8\u5173\u6e90\u7801\u662f\u4e2a\u4eba\u8ba4\u4e3a\u5199\u5f97\u6bd4\u8f83\u597d\u3001\u6bd4\u8f83\u6709\u7528\uff08\u53ef\u590d\u7528\u7a0b\u5ea6\u6bd4\u8f83\u9ad8\uff09\u7684\u4e00\u90e8\u5206\uff0c\u5e76\u975eQMaster\u7684\u5168\u90e8\u6e90\u7801\u3002\u6b22\u8fce\u8bc4\u8bba\u3002<\/p>\n<p><span style=\"color: #ff0000;\"><strong>dbconfig.xml<\/strong><\/span><\/p>\n<p>&lt;?xml version=&#8221;1.0&#8243; encoding=&#8221;GB2312&#8243;?&gt;<br \/>\n&lt;!&#8211;\u6570\u636e\u5e93\u914d\u7f6e\u6587\u4ef6&#8211;&gt;<br \/>\n&lt;dbconfig&gt;<br \/>\n\u00a0\u00a0\u00a0 &lt;jdbcdriver&gt;com.mysql.jdbc.Driver&lt;\/jdbcdriver&gt;&lt;!&#8211;JDBC Driver&#8211;&gt;<br \/>\n\u00a0\u00a0\u00a0 &lt;jdbcurl&gt;jdbc:mysql:\/\/localhost:3306\/questionnaire&lt;\/jdbcurl&gt;&lt;!&#8211;JDBC URL&#8211;&gt;<br \/>\n\u00a0\u00a0\u00a0 &lt;dbuser&gt;root&lt;\/dbuser&gt;&lt;!&#8211;\u6570\u636e\u5e93\u7528\u6237\u540d&#8211;&gt;<br \/>\n\u00a0\u00a0\u00a0 &lt;dbpwd&gt;yarpee19890607&lt;\/dbpwd&gt;&lt;!&#8211;\u6570\u636e\u5e93\u5bc6\u7801&#8211;&gt;<br \/>\n&lt;\/dbconfig&gt;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>DBConfig.java<\/strong><\/span><\/p>\n<p>\/**<br \/>\n\u00a0* \u529f\u80fd\uff1a\u89e3\u6790dbconfig.xml\u6587\u4ef6\uff0c\u63d0\u4f9b\u6570\u636e\u5e93\u914d\u7f6e\u3002<br \/>\n\u00a0*\/<br \/>\npackage db;<\/p>\n<p>import java.io.IOException;<br \/>\nimport java.io.InputStream;<br \/>\nimport javax.xml.parsers.DocumentBuilderFactory;<br \/>\nimport javax.xml.parsers.ParserConfigurationException;<br \/>\nimport org.w3c.dom.Document;<br \/>\nimport org.w3c.dom.Element;<br \/>\nimport org.w3c.dom.Node;<br \/>\nimport org.w3c.dom.NodeList;<br \/>\nimport org.xml.sax.SAXException;<\/p>\n<p><!--more--><\/p>\n<p>public class DBConfig {<br \/>\n\u00a0\u00a0\u00a0 \/\/\u5bf9\u5e94dbconfig.xml\u4e2d\u7684\u914d\u7f6e<br \/>\n\u00a0\u00a0\u00a0 private String jdbcDriver;<br \/>\n\u00a0\u00a0\u00a0 private String jdbcUrl;<br \/>\n\u00a0\u00a0\u00a0 private String dbUser;<br \/>\n\u00a0\u00a0\u00a0 private String dbPwd;<\/p>\n<p>\u00a0\u00a0\u00a0 DBConfig() throws ParserConfigurationException, SAXException, IOException {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DocumentBuilderFactory docBuildFac = DocumentBuilderFactory.newInstance();\/\/\u751f\u6210\u4e00\u4e2aDOM\u89e3\u6790\u5668\u5de5\u5382<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 InputStream is = this.getClass().getClassLoader().getResourceAsStream(&#8220;dbconfig.xml&#8221;);\/\/\u76f8\u5bf9\u4f4d\u7f6esrc\/dbconfig.xml<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Document doc = docBuildFac.newDocumentBuilder().parse(is);\/\/\u751f\u6210\u4e00\u4e2aDOM\u89e3\u6790\u5668\uff0c\u5e76\u89e3\u6790dbconfig.xml\u751f\u6210Doc\u3002<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Element root = doc.getDocumentElement();\/\/\u6839\u7ed3\u70b9<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NodeList nodeList = root.getChildNodes();\/\/\u6839\u7ed3\u70b9\u7684\u5b50\u7ed3\u70b9\u94fe\u8868<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for(int i = 0; i &lt; nodeList.getLength(); i++) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Node node = nodeList.item(i);\/\/\u5b50\u7ed3\u70b9<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(node.getNodeType() == Node.ELEMENT_NODE) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(node.getNodeName().equals(&#8220;jdbcdriver&#8221;)) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 jdbcDriver = node.getFirstChild().getNodeValue();\/\/DOM\u628a&lt;node&gt;value&lt;\/node&gt;\u5f53\u6210\u4e24\u5c42\u7ed3\u70b9<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } else if(node.getNodeName().equals(&#8220;jdbcurl&#8221;)) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 jdbcUrl = node.getFirstChild().getNodeValue();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } else if(node.getNodeName().equals(&#8220;dbuser&#8221;)) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbUser = node.getFirstChild().getNodeValue();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } else if(node.getNodeName().equals(&#8220;dbpwd&#8221;)) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbPwd = node.getFirstChild().getNodeValue();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public String getDbPwd() {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return dbPwd;<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public String getDbUser() {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return dbUser;<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public String getJdbcDriver() {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return jdbcDriver;<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public String getJdbcUrl() {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return jdbcUrl;<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>}<\/p>\n<p><span style=\"color: #ff0000;\"><strong>DB.java<\/strong><\/span><\/p>\n<p>\/**<br \/>\n\u00a0* \u529f\u80fd\uff1a\u8fde\u63a5\u3001\u5173\u95ed\u6570\u636e\u5e93<br \/>\n\u00a0*\/<br \/>\npackage db;<\/p>\n<p>import java.io.IOException;<br \/>\nimport java.sql.*;<br \/>\nimport javax.xml.parsers.ParserConfigurationException;<br \/>\nimport org.xml.sax.SAXException;<\/p>\n<p>public class DB {<br \/>\n\u00a0\u00a0\u00a0 private DBConfig config = null;<br \/>\n\u00a0\u00a0\u00a0 private Connection conn = null;<\/p>\n<p>\u00a0\u00a0\u00a0 public DB() throws ClassNotFoundException, ParserConfigurationException, SAXException, IOException {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 config = new DBConfig();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Class.forName(config.getJdbcDriver());<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public Connection getConnection() throws SQLException {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 conn = DriverManager.getConnection(config.getJdbcUrl(), config.getDbUser(), config.getDbPwd());<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return conn;<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public void close() throws SQLException {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(conn != null)<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 conn.close();<br \/>\n\u00a0\u00a0\u00a0 }<br \/>\n}<\/p>\n<p><span style=\"color: #ff0000;\"><strong>DBBak.java<\/strong><\/span><\/p>\n<p>\/**<br \/>\n\u00a0* \u529f\u80fd\uff1a\u5907\u4efd\u3001\u8fd8\u539f\u6570\u636e\u5e93<br \/>\n\u00a0*\/<br \/>\npackage db;<\/p>\n<p>import java.io.BufferedReader;<br \/>\nimport java.io.File;<br \/>\nimport java.io.FileInputStream;<br \/>\nimport java.io.FileOutputStream;<br \/>\nimport java.io.IOException;<br \/>\nimport java.io.InputStream;<br \/>\nimport java.io.InputStreamReader;<br \/>\nimport java.io.OutputStream;<br \/>\nimport java.io.OutputStreamWriter;<br \/>\nimport java.util.Calendar;<br \/>\nimport javax.xml.parsers.ParserConfigurationException;<br \/>\nimport org.xml.sax.SAXException;<\/p>\n<p>public class DBBak {<br \/>\n\u00a0\u00a0\u00a0 private DBConfig config = null;<\/p>\n<p>\u00a0\u00a0\u00a0 public DBBak() throws ParserConfigurationException, SAXException, IOException {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 config = new DBConfig();<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public String getFileName() {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Calendar today = Calendar.getInstance();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String year = String.valueOf(today.get(Calendar.YEAR));<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String month = String.valueOf(today.get(Calendar.MONTH) + 1);\/\/0~11\u8868\u793a1~12\u6708<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String date = String.valueOf(today.get(Calendar.DATE));<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String time = String.valueOf(today.getTimeInMillis());<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return year + &#8220;-&#8221; + month + &#8220;-&#8221; + date + &#8220;-&#8221; + time + &#8220;.sql&#8221;;<br \/>\n\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0<br \/>\n\u00a0\u00a0\u00a0 public void backUp(String path) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 try {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String jdbcUrl = config.getJdbcUrl();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int pos = jdbcUrl.lastIndexOf(&#8220;\/&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String dbName = jdbcUrl.substring(pos+1);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String cmd = &#8220;mysqldump -u&#8221; + config.getDbUser() + &#8221; -p&#8221; + config.getDbPwd() + &#8221; &#8221; + dbName;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Runtime rt = Runtime.getRuntime();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Process child = rt.exec(cmd);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 InputStream in = child.getInputStream();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 InputStreamReader xx = new InputStreamReader(in, &#8220;ISO-8859-1&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String inStr;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 StringBuffer sb = new StringBuffer(&#8220;&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String outStr;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BufferedReader br = new BufferedReader(xx);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 while ((inStr = br.readLine()) != null) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sb.append(inStr + &#8220;\\r\\n&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 outStr = new String(sb.toString().getBytes(&#8220;ISO-8859-1&#8221;), &#8220;UTF-8&#8243;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FileOutputStream fout = new FileOutputStream(path);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OutputStreamWriter writer = new OutputStreamWriter(fout,&#8221;UTF-8&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.write(outStr);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.flush();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 in.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 xx.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 br.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fout.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 catch (Exception e) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 e.printStackTrace();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0 }<\/p>\n<p>\u00a0\u00a0\u00a0 public void load(String path){<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 try{<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 File f = new File(path);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FileInputStream fis = new FileInputStream(f);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String jdbcUrl = config.getJdbcUrl();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int pos = jdbcUrl.lastIndexOf(&#8220;\/&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String dbName = jdbcUrl.substring(pos+1);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String cmd = &#8220;mysql -u&#8221; + config.getDbUser() + &#8221; -p&#8221; + config.getDbPwd() + &#8221; &#8221; + dbName;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Runtime rt = Runtime.getRuntime();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Process child = rt.exec(cmd);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OutputStream out = child.getOutputStream();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String inStr;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 StringBuffer sb = new StringBuffer(&#8220;&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String outStr;<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BufferedReader br = new BufferedReader(new InputStreamReader(fis, &#8220;UTF-8&#8221;));<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 while ((inStr = br.readLine()) != null) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sb.append(inStr + &#8220;\\r\\n&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 outStr =new String(sb.toString().getBytes(&#8220;UTF-8&#8221;), &#8220;ISO-8859-1&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OutputStreamWriter writer = new OutputStreamWriter(out, &#8220;ISO-8859-1&#8221;);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.write(outStr);<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.flush();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 out.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 br.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 writer.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fis.close();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } catch (Exception e) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 e.printStackTrace();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0 }<br \/>\n}<\/p>\n<p><span style=\"color: #ff0000;\"><strong>FileList.java<\/strong><\/span><\/p>\n<p>\/**<br \/>\n\u00a0* \u529f\u80fd\uff1a\u5217\u51fa\u6570\u636e\u5e93\u5907\u4efd\u6587\u4ef6<br \/>\n\u00a0*\/<br \/>\npackage db;<\/p>\n<p>import java.io.File;<br \/>\nimport java.util.ArrayList;<\/p>\n<p>public class FileList {<br \/>\n\u00a0\u00a0\u00a0 public ArrayList tree(File f) {\/\/\u4f20\u5165\u76ee\u5f55<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ArrayList files = new ArrayList();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 File[] list = f.listFiles();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(list != null){<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for(int i = 0; i &lt; list.length; i++) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(list[i].isFile()) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if(list[i].getName().endsWith(&#8220;.sql&#8221;)) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 files.add(list[i].getName());<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return files;<br \/>\n\u00a0}<br \/>\n}<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728QMaster\u5206\u7c7b\u91cc\u8bb0\u5f55\u7684\u76f8\u5173\u6e90\u7801\u662f\u4e2a\u4eba\u8ba4\u4e3a\u5199\u5f97\u6bd4\u8f83\u597d\u3001\u6bd4\u8f83\u6709\u7528\uff08\u53ef\u590d\u7528\u7a0b\u5ea6\u6bd4\u8f83\u9ad8\uff09\u7684\u4e00\u90e8\u5206\uff0c\u5e76\u975eQMast [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,21],"tags":[],"class_list":["post-360","post","type-post","status-publish","format-standard","hentry","category-qmaster","category-java"],"_links":{"self":[{"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/posts\/360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/115.29.108.60\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=360"}],"version-history":[{"count":7,"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/posts\/360\/revisions"}],"predecessor-version":[{"id":909,"href":"http:\/\/115.29.108.60\/index.php?rest_route=\/wp\/v2\/posts\/360\/revisions\/909"}],"wp:attachment":[{"href":"http:\/\/115.29.108.60\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/115.29.108.60\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=360"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/115.29.108.60\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}