Android通过jsp连接Oracle数据库_--_实例.doc

Android通过jsp连接Oracle数据库 - 实例 /首先写一个jsp后台服务连接到Oracle数据库的实例myOra1（此处只是测试，所以用system身份连接到该实例）/然后再通过jsp把数据返回给Android手机客户端/运行jsp代码之前必须导入Oracle数据库的jdbc驱动包（jar包），名字为：classes12.jar.这个包在Oracle的安装目录下可已/找到，在浏览器中打开jsp网页前必须保证Tomcat已经正确启动。/jsp取到的数据以xml格式展现在web页面中/Oracle数据库中的表如下：/jsp代码:html view plaincopyprint?1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 18. 19. 20. 21. 56. 57. 58. 59. 60. 61. 78. 79. 80. 81. 82. 83. 84. 85. 86. 87. 88. 89. 90. 91. 92. 93. 94. 95. 96. 97. 98. 99. 100. 101. 102. 103. 下图为jsp后台取出数据的结果：/当jsp后台从Oracle数据库取到数据后就应该返回给Android，这样就实现了Android客户端间接获得Oracle中的数据 Android客户端代码：1. main.xml(布局文件)：html view plaincopyprint?1. 2. 3. 12. 13. 24. 25. 34. 35. 2 main.java（Activity）:html view plaincopyprint?1. packagecom.AndroidLinkToJsp;2. 3. importjava.io.IOException;4. 5. importjava.io.StringReader;6. 7. importjavax.xml.parsers.SAXParserFactory;8. 9. importorg.apache.http.HttpResponse;10. 11. importorg.apache.http.client.ClientProtocolException;12. 13. importorg.apache.http.client.methods.HttpGet;14. 15. importorg.apache.http.impl.client.DefaultHttpClient;16. 17. importorg.apache.http.util.EntityUtils;18. 19. importorg.xml.sax.InputSource;20. 21. importorg.xml.sax.XMLReader;22. 23. importcom.sazhaoxun.AndroidLinkToJsp.R;24. 25. importandroid.app.Activity;26. 27. importandroid.os.Bundle;28. 29. importandroid.view.View;30. 31. importandroid.view.View.OnClickListener;32. 33. importandroid.widget.Button;34. 35. importandroid.widget.TextView;36. 37. 38. 39. publicclassmainextendsActivity40. 41. privateTextViewmyText;42. 43. privateButtonmyButton;44. 45. /命名空间46. 47. /privatestaticfinalStringurlStr=25:8080/test/MyJsp.jsp;48. 49. /*Calledwhentheactivityisfirstcreated.*/50. 51. Override52. 53. publicvoidonCreate(BundlesavedInstanceState)54. 55. super.onCreate(savedInstanceState);56. 57. setContentView(R.layout.main);58. 59. myText=(TextView)findViewById(R.id.myText);60. 61. myButton=(Button)findViewById(R.id.myButton);62. 63. myButton.setOnClickListener(newshowButton();64. 65. 66. 67. 68. 69. classshowButtonimplementsOnClickListener70. 71. Override72. 73. publicvoidonClick(Viewv)74. 75. 76. 77. 78. 79. /TODOAuto-generatedmethodstub80. 81. System.out.println(开始获得数据);82. 83. StringuriAPI=25:8080/test/MyJsp.jsp;84. 85. /*建立HTTPGet联机*/86. 87. HttpGethttpRequest=newHttpGet(uriAPI);88. 89. try90. 91. 92. 93. /*发到HTTPrequest*/94. 95. HttpResponsehttpResponse=newDefaultHttpClient().execute(httpRequest);96. 97. /*若状态码为200ok*/98. 99. if(httpResponse.getStatusLine().getStatusCode()=200)100. 101. 102. 103. /*取叨并应?串*/104. 105. StringstrResult=EntityUtils.toString(httpResponse.getEntity();106. 107. /*?除?余?元*/108. 109. /strResult=eregi_replace(rn|r|n|nr),strResult);110. 111. try112. 113. SAXParserFactoryfactory=SAXParserFactory.newInstance();114. 115. XMLReaderreader=factory.newSAXParser().getXMLReader();116. 117. reader.setContentHandler(newContentHandler();118. 119. reader.parse(newInputSource(newStringReader(strResult);120. 121. 122. 123. catch(Exceptione)124. 125. e.printStackTrace();126. 127. 128. 129. System.out.println(成功获得数据);130. 131. myText.setText(strResult.toString();132. 133. 134. 135. 136. 137. 138. 139. else140. 141. 142. 143. myText.setText(ErrorResponse:+httpResponse.getStatusLine().toString();144. 145. 146. 147. 148. 149. catch(ClientProtocolExceptione)150. 151. 152. 153. /mTextView1.setText(e.getMessage().toString();154. 155. e.printStackTrace();156. 157. 158. 159. catch(IOExceptione)160. 161. 162. 163. /mTextView1.setText(e.getMessage().toString();164. 165. e.printStackTrace();166. 167. 168. 169. catch(Exceptione)170. 171. 172. 173. /mTextView1.setText(e.getMessage().toString();174. 175. e.printStackTrace();176. 177. 178. 179. 180. 181. /*182. 183. *创建一个SAXParserFactory,再用这个工厂来创建一个XMLReader，以此来读取XML184. 185. */186. 187. /SAXParserFactoryfactory=SAXParserFactory.newInstance();188. 189. /XMLReaderreader=factory.newSAXParser().getXMLReader();190. 191. /192. 193. /为XMLReader设置内容处理器，MyContentHandler()为具体处理的类194. 195. /reader.setContentHandler(newContentHandler();196. 197. /开始解析文件198. 199. /reader.parse(newInputSource(newStringReader(strResult);200. 201. /202. 203. 204. 205. 206. 207. 208. 209. 210. 211. 3 . ContentHandler.java:html view plaincopyprint?1. packagecom.AndroidLinkToJsp;2. 3. 4. 5. importorg.xml.sax.Attributes;6. 7. importorg.xml.sax.SAXException;8. 9. importorg.xml.sax.helpers.DefaultHandler;10. 11. 12. 13. publicclassContentHandlerextendsDefaultHandler14. 15. StringID,NAME,AGE,SEX;16. 17. StringtagName;18. 19. 20. 21. /*22. 23. *开始解析xml24. 25. *throwsSAXException26. 27. */28. 29. publicvoidstartDocument()throwsSAXException30. 31. System.out.println(-begin-);32. 33. 34. 35. 36. 37. /*38. 39. *结束解析xml40. 41. *throwsSAXException42. 43. */44. 45. publicvoidendDocument()throwsSAXException46. 47. System.out.println(-end-);48. 49. 50. 51. 52. 53. /*54. 55. *开始解析元素属性56. 57. *58. 59. *paramnamespaceURI命名空间，防止命名重复60. 61. *paramlocalName不带前缀的名字62. 63. *paramqName带前缀的名字64. 65. *paramattr代表标签里所有的属性66. 67. *throwsSAXException68. 69. */70. 71. publicvoidstartElement(StringnamespaceURI,StringlocalName,72. 73. StringqName,Attributesattr)throwsSAXException74. 75. /System.out.println(qName-+qName);/调试用76. 77. tagName=localName;/把当前正在解析的无前缀的名字传给tagName78. 79. if(localName.equals(TONGXIN081)80. 81. for(inti=0;iattr.getLength();i+)82. 83. System.out.println(attr.getLocalName(i)+=+attr.getValue(i);/得到第i个属性的名字和值84. 85. 86. 87. 88. 89. 90. 91. 92. 93. 94. 95. /*96. 97. *结束元素解析98. 99. *100. 101. *paramnamespaceURI102. 103. *paramlocalName104. 105. *paramqName106. 107. *throwsSAXException108. 109. */110. 111. publicvoidendElement(StringnamespaceURI,StringlocalName,StringqName)throwsSAXException112. 113. /在worker标签解析完之后，会打印出所有得到的数据114. 115. /tagName=;116. 117. if(localName.equals(TONGXIN081);118. 119. this.printout();120. 121. 122. 123. /*124. 125. *具体解析标签里的内容126. 127. *128. 129. *paramch所有读取到的内容，都会放到char类型的数组里130. 131. *paramstart读取的内容是从char数组的哪一位开始132. 133. *paramlength从start开始，一共有多长的内容134. 135. *throwsSAXException136. 137. */138. 139. publicvoidcharacters(charch,intstart,intlength)140. 141. throwsSAXException142. 143. 144. 145. if(tagName.equals(ID)146. 147. ID=newString(ch,start,length);148. 149. elseif(tagName.equals(NAME)150. 151. N