第一个安卓程序访问服务器的Servlet，Servlet访问数据库

1.        1新建Android的数据库和表。添加user表信息

2.        运行AndroidStudio，编写安卓访问数据库程序。

a)        导入volly jar包，建MainActivityxml文件布局如下

b)       在MainActivity里写人代码，利用get发送请求

 

package com.cll.myapplication;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;
import com.android.volley.toolbox.Volley;

public class MainActivity extendsAppCompatActivity {
    Button btn1;
    EditText et1;
    RequestQueue requestQueue;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        btn1 =(Button)findViewById(R.id.btn1);
        et1 =(EditText)findViewById(R.id.et1);
        requestQueue = Volley.newRequestQueue(this);
        btn1.setOnClickListener(newView.OnClickListener() {
            @Override
            public void onClick(View view) {
                StringRequeststringRequest =new StringRequest("http://www.baidu.com",new Response.Listener<String>(){
                    @Override
                    public void onResponse(String s) {
                    et1.setText(s);
                    }
                }, new Response.ErrorListener() {
                    @Override
                    public void onErrorResponse(VolleyError volleyError) {
                        et1.setText("出错了");
                    }
                });
                requestQueue.add(stringRequest);
            }
        });
    }
}

c)        运行效果

 

3.        编写Servlet和Java访问数据库程序

a)        导入MySQL数据库连接驱动和放到tamcat/bin目录下

b)       分别建Dbhelper、Dbcon类和LoginServlet

c)        类的代码如下

                       i.             Dbhelperpackagemodel;

import java.sql.DriverManager;

import java.sql.SQLException;

 

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

 

import constant.Dbcon;

 

public class DbHelper {

 

       Connectionconn = null;

       publicConnection Getconnect() {

              Connection conn = null;

              try{

                     Class.forName(Dbcon.driver);

                    

                     conn= (Connection)DriverManager.getConnection(Dbcon.url,Dbcon.user,Dbcon.password);

                    

              }catch (ClassNotFoundException e) {

                     //TODO Auto-generated catch block

                     e.printStackTrace();

                     System.out.println("Sorry,can`tfind the Driver!");

              }catch(SQLException e) {

                     //TODO Auto-generated catch block

                     e.printStackTrace();

                     System.out.println("Sorry,can`tDatabase");

              }

              finally{

                     System.out.println("数据库数据成功获取！！");

 

              }

 

//            //1.getConnection()方法，连接MySQL数据库！！

              if(!conn.isClosed())

                     System.out.println("Succeededconnecting to the Database!");

 

             

              returnconn;

       }

/*    publicvoid Result(){

              conn= Getconnect();

              try{

                     java.sql.Statement  statement = conn.createStatement();

                     Stringsql = "select * from user";

                     java.sql.ResultSetrs = statement.executeQuery(sql);

                     Stringname = null;

                     Stringpwd = null;

 

                     while(rs.next()){

                            name= rs.getString("name");

                            pwd= rs.getString("pwd");

                            name= new String(name.getBytes("ISO-8859-1"),"gb2312");

                            System.out.println(pwd+ "\t" + name);

                     }

                     rs.close();

                     conn.close();

 

              }catch (Exception e) {

                     //TODO Auto-generated catch block

                     e.printStackTrace();

              }

       }

       publicString Result1(){

              conn= Getconnect();

              Stringnames ="";

              Stringpwds ="";

              try{

                     java.sql.Statement  statement = conn.createStatement();

                     Stringsql = "select * from user";

                     java.sql.ResultSetrs = statement.executeQuery(sql);

                     Stringname[] = null;

                     Stringpwd[] = null;

                     inti=0;

                     while(rs.next()){

                            i++;

                            name[i]= rs.getString("name");

                            pwd[i]= rs.getString("pwd");

                            name[i]= new String(name[i].getBytes("ISO-8859-1"),"gb2312");

                            System.out.println(pwd+ "\t" + name);

                     }

                     rs.close();

                     conn.close();

                    

                     for(i=0;i<name.length;i++){

                            if(name[i]!=null&&pwd[i]!=null){

                                   names+= name[i];

                                   pwds+=pwd[i];

                            }

                     }

              }catch (Exception e) {

                     //TODO Auto-generated catch block

                     e.printStackTrace();

              }

              returnnames+pwds;

       }*/

        public static void main(String[] args) {

              //newDbHelper().Result();

       }

}

                     ii.             Dbcon

 package constant;

 

import com.mysql.jdbc.Connection;

 

public class Dbcon {

       //publicfinal static Connection con;

       publicfinal static String driver = "com.mysql.jdbc.Driver";

       publicfinal static String url = "jdbc:mysql://127.0.0.1:3306/android";

       publicfinal static String user = "root";

       publicfinal static String password = "root";

}

     iii.     LoginServlet package controller;

 

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

importjavax.servlet.http.HttpServletRequest;

importjavax.servlet.http.HttpServletResponse;

 

import com.mysql.jdbc.Connection;

 

import model.DbHelper;

 

/**

 *Servlet implementation class LoginServlet

 */

@WebServlet("/LoginServlet")

public class LoginServlet extendsHttpServlet {

       privatestatic final long serialVersionUID = 1L;

      

   /**

    * @see HttpServlet#HttpServlet()

    */

   public LoginServlet() {

       super();

       // TODO Auto-generated constructor stub

    }

 

       /**

        * @see HttpServlet#doGet(HttpServletRequestrequest, HttpServletResponse response)

        */

       protectedvoid doGet(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {

              //TODO Auto-generated method stub

              DbHelperdbhelp = new DbHelper();

              Connectioncon = dbhelp.Getconnect();

              if(con!=null)

              response.getWriter().append("Servedat: ").append(request.getContextPath());

      

       }

 

       /**

        * @see HttpServlet#doPost(HttpServletRequestrequest, HttpServletResponse response)

        */

       protectedvoid doPost(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {

              //TODO Auto-generated method stub

              doGet(request,response);

       }

 

}

4修改安卓post访问地址"10.0.2.2:8080/First/LoginServlet"

5运行结果