Android通过jsp连接Oracle数据库--实例,学习的好东西，不错，不错
String pas sword="manager"; Connection conn= DriverManager get Connection(url, user, password); Statement stmt=conn. createstatement (Resultset TYPE SCROLL_ SENSITIVE> esultset, CONCUR UPDATABLE); String sql=select from system. SAZHAOXUN" 48 41 Resultset rs=stmt. executeQuery(sql); 42 43 44 45 String str ID: String strNAME 48 String strAGE String str 52 5了, 61.<% 63 while(rs, nexto) strID=rs getstring(" ID"); strNAME=rs getstring( NAME"); 71 strAGE=rs getstring( " AGE ) 73. strsEX=rs getstring("SEX"); 74 75 77,% < TONGX工N881> <ID><%=strID%></ID> NAME》<%=5 trNAME‰></NAME 85, AGEc‰ strAGE%></AGE 87 <SEX><%=strSEX></SEX> 88 89 </TONGXIN081> 93. ‰}%》 5 9了 99, </INFO> 188 if(r 198。 109 rs close(); 118 111 113 if(stmt!=null 114 115 stmt. close(; L8 119 128 121 if(cann! =null) 122 123 124 125 conn close(); 129 138 131 catch(Exception e) 132 133 134 135 e. printstackTraceo; 136, 138 139 下图为jsp后台取出数据的结果: ,X心有日,②,mat3hh 号加速 后沿的进停止新主页饮复无 <?xml version=1. 0" ancodingutf-B7> <TONGXINOB1E d>001cD> <NAME>sazhaoxun </NAME> <AGE>22 AGE> <SEX>male d/sEXx <TONGXINO81> <ONGXINOB1> D>002<TD dNAME >yangteng </NAME> <AGE>21AGE> <SEX>maleSEX> TONGXINO81> ∠ ONGAINO8L 1D003<ID <NAME>xingchangled/NAME> cAGE>21</AGE≥ <SEX>male</SEX <TONGXIN301> <TONGXNO81 dD004</D <NAME slizhimin<NAME% <AGE>23AGE> csEX>male</sEX. C/TONGXINO81> ToNG足N0s1> D>005<1D> <NAME>zhang kai</NAME> <AGE>23<AL SEX>male</sEx <TONGXINO81> <TONGXINOB1> <D-0064ID2 <NAME>LUCY<NAME> <AGE>20/AGE> 蔬「四 ∥当jsp后台从 Oracle数据库取到数据后就应该返回给 Android,这样就实现了 Android客 户端间接获得 Oracle中的数据 Android客户端代码: maln.xm(布局文件) [html] view plaincopyprinti 1. <?xml version="1. 0" encoding="utf-8"?> 2 3,<linEarlayoutxmins:android=http://schemas,androidcom/apk/res/android android: orientation="vertical 7 android: layout width="fill parent 8 9 android: layout height-"fill_parent 1② 12 13. <Button 14 15. android: id=@+id/myButton droid: layout width="wrap content 19, android: layout height="wrap content android:text-"获取orac1e数据" droid: id="@+id/my droid: layout width="fill_ parent 31 android: layout height=fill parent 32 5.</Linear Layout> in java (Activity ) [html] view plaincopyprint? 1 AndroidLinkTo]s 3. import java. 10. IOExcepti 4 t java. io StringReader 7. import javax. xml parsers SAXParserFactory; 8 9.importorgapachehttpHttpresponsei 11,importorgapachehttpclientClientProtocolexception; 13.importorgapachehttpclientmethodsHttpget; 15.importorgapachehttpimplclientDefaulthttpclienti 17.importorgapachehttputilEntityutils; 19. import org. xml. sax. InputSource: 21. import org. xml. sax. XMLReader; 23. import com. sazhaoxun AndroidLinkTo]sp R; 24 25,import android app. Activity: 27. import androidos Bundle; 31. import android view, View. OnclickListener 33, import android. widget. Button; 35.im indroid widget. Textvi 37 39. public class main extends Activity 41 Textview myText 42 43 private Button my Button; 44 45,//命名空间 46 47.//privatestaticfinalStringurlstr=http://18.88.5.225:8080/test/myjs 2·Jsp" /** Called when the activity is first created. * Override 53. public void on Create(Bundle savedInstanceState)t 55 super onCreate(savedInstancestate) setContentview(R, layout. main) my Text =(Textview)findviewById(R, id, myText); my But ton =(Button)findViewById(R id. y But ton) 63 my Button. setonclickListener(new showButton(); 65, 67 68 class show Button imp l ements OnClickListenert 71 override oublic void onClick(view v) 76 79, // TODO Auto-generated method stub 8