Android通过jsp连接Oracle数据库 .docx

《Android通过jsp连接Oracle数据库 .docx》由会员分享，可在线阅读，更多相关《Android通过jsp连接Oracle数据库 .docx（24页珍藏版）》请在三一办公上搜索。

1、Android通过jsp连接Oracle数据库-实例/首先写一个jsp后台服务连接到Oracle数据库的实例myOral （此处只是测试，所以用 system身份连接到该实例）/然后再通过jsp把数据返回给Android手机客户端运行jsp代码之前必须导入Oracle数据库的jdbc驱动包（jar包），名字为:classes12.jar.这个包在Oracle的安装目录下可已/找到，在浏览器中打开jsp网页前必须保证Tomcat已经正确启动。/jsp取到的数据以xml格式展现在web页面中/Oracle数据库中的表如下：-intxjID卬HAMEKAGEPSEX|i:22J:二azhaoMun2

2、2nnalT?（002玄vamcrfeng21malexing triangle21nnale网Him min23malsOOfczhang ksi23mal9uucy2Qremal/jsp代码：html view plaincopyprint?1. 2.2. 4.3. 6.4. 8.9.10.11. 18.19.20.15. 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.102.103. 下图为jsp后台取出数据的结果:_j local hostc?xnil veisp

3、nn-,i.Ol encodinijtf-fl1 ? d：=ooi ns22mnle/SEi-1DXJOJ =:Fv-ME :-vanqfenq :/N51E:：.21malc-10003 iogch angle A也ay纹SEXm*sle-ID：lO04方I i i hi rniK J NAME a23：maleSX5- -dr x05 小空I： zhan q kni -/ NAMt： -23cyaGmaie-L ucy 亦凸 ME JO=_重一-*!当jsp后台从Oracle数据库取到数据后就应该返回给Android，这样就实现了 Android客 户端间接获得Oracle中的数据Andr

4、oid客户端代码：1.main.xml（布 局文件）：html view plaincopyprint?1. 2.2. 12.7. 24.13. 34.18. 冈2. main.java (Activity):html view plaincopyprint?1. package com.AndroidLinkToJsp;2.2. import java.io.IOException;4.3. import java.io.StringReader;6.4. import javax.xml.parsers.SAXParserFactory;8.5. import org.apache.htt

5、p.HttpResponse;10.6. import org.apache.http.client.ClientProtocolException;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

6、;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. publicclass main extends

7、Activity 40.41. private TextView myText;42.42. private Button myButton;44.43. 命名空间46.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.47. / private static final String urlStr=http:/10.88.5.225:8080/test/MyJsP.jsp”；/* Called when the activity is first cr

8、eated. */Overridepublic void onCreate(Bundle savedInstanceState) super.onCreate(savedlnstanceState);setContentView(R.layout.main);myText = (TextView)findViewByld(R.id.myText);myButton = (Button)findViewByld(R.id.myButton);myButton.setOnClickListener(new showButton();class showButton implements OnCli

9、ckListenerOverridepublic void onClick(View v)/ TODO Auto-generated method stub81.System.out.println(开始获得数据);82.83.String uriAPI =http:/10.88.5.225:8080/test/MyJsp.jsp;84.85./*建立HTTP Get联机*/86.87.HttpGet httpRequest = new HttpGet(uriAPI);88.89.try90.91.92.93./*发到 HTTP request*/94.95.HttpResponse http

10、Response = new DefaultHttpClient().execute(httpRequest);96.97./*若状态码为200 ok*/98.99.if(httpResponse.getStatusLine().getStatusCode() = 200)100.101.102.103./*取叨并应？串*/104.105.String strResult = EntityUtils.toString(httpResponse.getEntity();106.107./*?除？余？元*/108.109./strResult = eregi_replace(rn|r|n|nr),

11、strResult);110.111.try112.113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143SAXParserFactory factory=SAXParserFactory.newInstance() ；XMLReader reader=factory.newSAXParser().getXMLReader();reader.setContentHandler(new ContentHandler();reader.parse(new InputS

12、ource(new StringReader(strResult );catch (Exception e) e.printStackTrace();System.out.println(成功获得数据);myText.setText(strResult.toString();elsemyText.setText(Error Response: +httpResponse.getStatusLine().toString();144.145. 146.146. 148.147. catch (ClientProtocolException e)150.148. 152.149. / mTextV

13、iew1.setText(e.getMessage().toString();154.150. e.printStackTrace();156.151. 158.152. catch (IOException e)160.153. 162.154. / mTextView1.setText(e.getMessage().toString();164.155. e.printStackTrace();166.156. 168.157. catch (Exception e)170.158. 172.159. /mTextView1.setText(e.getMessage().toString(

14、);174.160. e.printStackTrace();176.161. 178.179.180.162. /*182.163. *创建一个SAXParserFactory,再用这个工厂来创建一个XMLReader, 以此来读取XML184.164. */186.165. /SAXParserFactory factory = SAXParserFactory.newInstance();188.166. /XMLReader reader = factory.newSAXParser().getXMLReader();190.167. /192.168. /为XMLReader设置内容

15、处理器，MyContentHandler()为具体处理的类194.169. /reader.setContentHandler(new ContentHandler();196.170. /开始解析文件198.171. /reader.parse(new InputSource(new StringReader(strResult);200.172. /202.173. 204.205.206.174. 208.209.210.175. 3 . ContentHandler.java:html view plaincopyprint?1.package com.AndroidLinkToJsp

16、;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.publicclass ContentHandler extends DefaultHandler14.15.String ID,NAME,AGE,SEX;16.17.String tagName;18.19.20.21./*22.23.*开始解析xml24.25.* throws SAXException26.27.*/28.29.pu

17、blic void startDocument() throws SAXException30.31.System.out.println(begin);32.33.34.35.36.37./*38.39.*结束解析xml40.41.* throws SAXException42.*/43.44.45.public void endDocument() throws SAXException46.47.System.out.println(end);48.49.50.51.52.53./*54.55.*开始解析元素属性56.57.59.* param namespaceURI命名空间，防止命名

18、重复60.不带前缀的名字带前缀的名字代表标签里所有的属性61. * param localName62.62. * param qName64.63. * param attr66.67.* throws SAXException 68.69. */70.70. public void startElement(String namespaceURI, String localName,72.71. String qName, Attributes attr) throws SAXException74.72. /System.out.println(qName+qName);/调试用76.73. tagName = localName;/把当前正在解析的无前缀的名字传给tagName78.74. if(localName.equals(TONGXIN081)80.75. for (int i = 0; i k!/intent:-filrer F、pp3_zLc:at:iciii下图为Android取到jsp后台xml格式的数据后返回给Android客户端ok,我们在Android手机上可以看到远程数据库的数据。这个Demo就是Android通过jsp 连接远程Oracle数据库。