Android通過jsp連接Oracle數(shù)據(jù)庫 -- 實例

香山早秋 2012-02-28

展開全文

//首先寫一個jsp后臺服務連接到Oracle數(shù)據(jù)庫的實例myOra1（此處只是測試，所以用system身份連接到該實例）

//然后再通過jsp把數(shù)據(jù)返回給Android手機客戶端

//運行jsp代碼之前必須導入Oracle數(shù)據(jù)庫的jdbc驅(qū)動包（jar包），名字為：classes12.jar.這個包在Oracle的安裝目錄下可已

//找到，在瀏覽器中打開jsp網(wǎng)頁前必須保證Tomcat已經(jīng)正確啟動。

//jsp取到的數(shù)據(jù)以xml格式展現(xiàn)在web頁面中

//Oracle數(shù)據(jù)庫中的表如下：

//jsp代碼:

[html] view plain copy print ?

<?xml version="1.0" encoding="utf-8"?>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.88.5.117:1521:myOra1";
String user="system";
String password="manager";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from system.SAZHAOXUN";
ResultSet rs=stmt.executeQuery(sql);
String strID;
String strNAME;
String strAGE;
String strSEX;
%>
<INFO>
<%
while(rs.next())
{
strID=rs.getString("ID");
strNAME=rs.getString("NAME");
strAGE=rs.getString("AGE");
strSEX=rs.getString("SEX");
%>
<TONGXIN081>
<ID><%=strID%></ID>
<NAME><%=strNAME%></NAME>
<AGE><%=strAGE%></AGE>
<SEX><%=strSEX%></SEX>
</TONGXIN081>
<% } %>
</INFO>
<%
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>

下圖為jsp后臺取出數(shù)據(jù)的結果：

//當jsp后臺從Oracle數(shù)據(jù)庫取到數(shù)據(jù)后就應該返回給Android，這樣就實現(xiàn)了Android客戶端間接獲得Oracle中的數(shù)據(jù)

Android客戶端代碼：

1. main.xml(布局文件)：

[html] view plain copy print ?

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas./apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<Button
android:id="@+id/myButton"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="獲取Oracle數(shù)據(jù) "
/>
<TextView
android:id="@+id/myText"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
/>
</LinearLayout>

2． main.java（Activity）:

[html] view plain copy print ?

package com.AndroidLinkToJsp;
import java.io.IOException;
import java.io.StringReader;
import javax.xml.parsers.SAXParserFactory;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.util.EntityUtils;
import org.xml.sax.InputSource;
import org.xml.sax.XMLReader;
import com.sazhaoxun.AndroidLinkToJsp.R;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.TextView;
public class main extends Activity {
private TextView myText;
private Button myButton;
//命名空間
// private static final String urlStr="http://10.88.5.225:8080/test/MyJsp.jsp";
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
myText = (TextView)findViewById(R.id.myText);
myButton = (Button)findViewById(R.id.myButton);
myButton.setOnClickListener(new showButton());
}
class showButton implements OnClickListener{
@Override
public void onClick(View v)
{
// TODO Auto-generated method stub
System.out.println("開始獲得數(shù)據(jù)");
String uriAPI ="http://10.88.5.225:8080/test/MyJsp.jsp";
/*建立HTTP Get聯(lián)機*/
HttpGet httpRequest = new HttpGet(uriAPI);
try
{
/*發(fā)到HTTP request*/
HttpResponse httpResponse = new DefaultHttpClient().execute(httpRequest);
/*若狀態(tài)碼為200 ok*/
if(httpResponse.getStatusLine().getStatusCode() == 200)
{
/*取叨并應?串*/
String strResult = EntityUtils.toString(httpResponse.getEntity());
/*?除?余?元*/
//strResult = eregi_replace("(\r\n|\r|\n|\n\r)","",strResult);
try{
SAXParserFactory factory=SAXParserFactory.newInstance();
XMLReader reader=factory.newSAXParser().getXMLReader();
reader.setContentHandler(new ContentHandler());
reader.parse(new InputSource(new StringReader(strResult)));
}
catch (Exception e) {
e.printStackTrace();
}
System.out.println("成功獲得數(shù)據(jù)");
myText.setText(strResult.toString());
}
else
{
myText.setText("Error Response: "+httpResponse.getStatusLine().toString());
}
}
catch (ClientProtocolException e)
{
// mTextView1.setText(e.getMessage().toString());
e.printStackTrace();
}
catch (IOException e)
{
// mTextView1.setText(e.getMessage().toString());
e.printStackTrace();
}
catch (Exception e)
{
//mTextView1.setText(e.getMessage().toString());
e.printStackTrace();
}
/**
* 創(chuàng)建一個SAXParserFactory,再用這個工廠來創(chuàng)建一個XMLReader，以此來讀取XML
*/
// SAXParserFactory factory = SAXParserFactory.newInstance();
// XMLReader reader = factory.newSAXParser().getXMLReader();
//
// //為XMLReader設置內(nèi)容處理器，MyContentHandler()為具體處理的類
// reader.setContentHandler(new ContentHandler());
// //開始解析文件
// reader.parse(new InputSource(new StringReader(strResult)));
//
}
}
}

3 . ContentHandler.java:

[html] view plain copy print ?

package com.AndroidLinkToJsp;
import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;
public class ContentHandler extends DefaultHandler{
String ID,NAME,AGE,SEX;
String tagName;
/**
* 開始解析xml
* @throws SAXException
*/
public void startDocument() throws SAXException{
System.out.println("--------begin--------");
}
/**
* 結束解析xml
* @throws SAXException
*/
public void endDocument() throws SAXException{
System.out.println("--------end-----------");
}
/**
* 開始解析元素屬性
*
* @param namespaceURI 命名空間，防止命名重復
* @param localName 不帶前綴的名字
* @param qName 帶前綴的名字
* @param attr 代表標簽里所有的屬性
* @throws SAXException
*/
public void startElement(String namespaceURI, String localName,
String qName, Attributes attr) throws SAXException{
//System.out.println("qName-------->"+qName);//調(diào)試用
tagName = localName;//把當前正在解析的無前綴的名字傳給tagName
if(localName.equals("TONGXIN081")){
for (int i = 0; i < attr.getLength(); i++) {
System.out.println(attr.getLocalName(i) + "=" + attr.getValue(i));//得到第i個屬性的名字和值
}
}
}
/**
* 結束元素解析
*
* @param namespaceURI
* @param localName
* @param qName
* @throws SAXException
*/
public void endElement(String namespaceURI, String localName, String qName) throws SAXException{
//在worker標簽解析完之后，會打印出所有得到的數(shù)據(jù)
//tagName = "";
if(localName.equals("TONGXIN081"));
this.printout();
}
/**
* 具體解析標簽里的內(nèi)容
*
* @param ch 所有讀取到的內(nèi)容，都會放到char[]類型的數(shù)組里
* @param start 讀取的內(nèi)容是從char[]數(shù)組的哪一位開始
* @param length 從start開始，一共有多長的內(nèi)容
* @throws SAXException
*/
public void characters(char[] ch, int start, int length)
throws SAXException
{
if (tagName.equals("ID"))
ID = new String(ch, start, length);
else if (tagName.equals("NAME"))
NAME = new String(ch, start, length);
else if (tagName.equals("AGE"))
AGE = new String(ch, start, length);
else if (tagName.equals("SEX"))
SEX = new String(ch, start, length);
}
private void printout()
{
System.out.print("ID: ");
System.out.println(ID);
System.out.print("NAME: ");
System.out.println(NAME);
System.out.print("AGE: ");
System.out.println(AGE);
System.out.print("SEX: ");
System.out.println(SEX);
System.out.println();
}
}