资源描述:
《android之获取远程数据》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Android之从mysql数据库中获取数据下面是整体结构图数据库端创建数据库CREATEDATABASE`user`/*!40100DEFAULTCHARACTERSETutf8*/;创建用户表CREATETABLE`users`(`name`char(30)NOTNULL,`password`char(30)NOTNULL,PRIMARYKEY(`name`))ENGINE=InnoDBDEFAULTCHARSET=utf8;插入数据insertintousers(name,password)values("zhangsan","123
2、456");insertintousers(name,password)values("lisi","123456");insertintousers(name,password)values("wangwu","123456");insertintousers(name,password)values("zhaoliu","123456");insertintousers(name,password)values("sunqi","123456");服务器端packagecom.jackie.fz;importjava.io.IOExce
3、ption;importjava.io.PrintWriter;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjava
4、x.servlet.http.HttpServletResponse;publicclassConn_mysqlextendsHttpServlet{/****/privatestaticfinallongserialVersionUID=1L;Connectionconn=null;PreparedStatementstate=null;ResultSetres=null;@OverrideprotectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)throwsServ
5、letException,IOException{try{//加载驱动程序Class.forName("com.mysql.jdbc.Driver");//连接数据库conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/user","root","310911");Stringsql="select*fromusers";state=conn.prepareStatement(sql);//查询数据res=state.executeQuery();//将取得的数据串成一个
6、Json格式的字符串StringBuilderresult=newStringBuilder();result.append("[");while(res.next()){result.append("{"+""name":"+"""+res.getString("name")+"""+",");result.append(""password":"+"""+res.getString("password")+"""+"}"+",");}//删除最后一个逗号result.deleteCharAt(result.length(
7、)-1);result.append("]");//设置响应编码resp.setContentType("text/html;charset=utf-8");//打印PrintWriterout=resp.getWriter();out.print(result.toString());}catch(Exceptione){e.printStackTrace();}}@OverrideprotectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp)throwsServlet
8、Exception,IOException{this.doGet(req,resp);}}Android客户端packagecom.example.conn_mysql;impo