Android studio 开发安卓软件后端java代码示例

参照本示例首先需要有fastjson jar包以及dbutils jar包和安卓异步服务器的jar包

1.对数据库的相关操作，该部分用于从数据库获取数据

public class ProsDao {
	private QueryRunner qr;
	private Connection conn;
	public List<Map<String,Object>> findAll(){
		List<Map<String,Object>> list=null;
		String sql="select * from tbl_pro_info";
		try {
			conn=DBHelper.getConnection();
			qr=new QueryRunner();
			list=qr.query(conn, sql, new MapListHandler());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			DBHelper.close(conn);
		}
		
		return list;
		
	}
	public int save(String proName,String proPrice) {
		int row=1;
		String sql="insert into tbl_pro_info(proName,proPrice)"+ 
		" values(?,?)";
		try {
			conn=DBHelper.getConnection();
			qr=new QueryRunner();
			row=qr.update(conn,sql,proName,proPrice);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			DBHelper.close(conn);
		}
		
		
		return row;
		
	}
	public List<Map<String,Object>> findByParams(String proName,String loPrice,String hiPrice){
		List<Map<String,Object>> list=null;
		String sql="select * from tbl_pro_info"
				+ " where 1=1";
		//创建一个容器存放要查询的条件
		List<String > params=new ArrayList<String>();
		if(proName!=null&&proName.length()>0) {
			sql+=" and proName like ?";
			params.add("%"+proName+"%");
		}
		if(loPrice!=null&&loPrice.length()>0) {
			sql+=" and proPrice>=?";
			params.add(loPrice);
			
		}
		if(hiPrice!=null&&hiPrice.length()>0) {
			sql+=" and proPrice<=?";
			params.add(hiPrice);
		}
		try {
			conn=DBHelper.getConnection();
			qr=new QueryRunner();
			list=qr.query(conn, sql,new MapListHandler(),params.toArray());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			DBHelper.close(conn);
		}
		
	    return list;
		
	}
	public static  void main(String[] args) {
		ProsDao dao=new ProsDao();
		List<Map<String,Object>> list=
				dao.findAll();
		System.out.println(list);
		
	}

}

2.servlet相关部分设计（servlet用于向前端传输数据）

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;


import main.webapp.dao.ProsDao;

/**
 * Servlet implementation class ProSearchServlet
 */
@WebServlet("/ProSearchServlet")
public class ProSearchServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ProSearchServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//处理中文
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		String proName=request.getParameter("proName");
		
		String loPrice=request.getParameter("loPrice");
		String hiPrice=request.getParameter("hiPrice");
		ProsDao prosDao=new ProsDao();
		List<Map<String,Object>> list=prosDao.findByParams(proName, loPrice, hiPrice);
		String msg=JSON.toJSONString(list);
		PrintWriter out=response.getWriter();
		out.println(msg);
		out.close();
		
		
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

 

3.Android studio部分java代码（MainActivity部分代码，用于控制页面控件）

package com.example.mysqlite;

import android.content.Context;
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;
import android.widget.Toast;

import com.example.mysqlite.dao.UsersDao;
import com.loopj.android.http.AsyncHttpClient;
import com.loopj.android.http.AsyncHttpResponseHandler;
import com.loopj.android.http.RequestParams;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

public class MainActivity extends AppCompatActivity {

    private Button btnSave;
    private Button btnSearch;
    private ListView lvUsers;
    private SimpleAdapter adapter;
    private List<Map<String, String>> list;
    private Button btnTest;
    private TextView test;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        btnSave = findViewById(R.id.main_btn_save);
        btnSearch = findViewById(R.id.main_btn_search);
        lvUsers = findViewById(R.id.main_lv_users);
        btnTest = findViewById(R.id.main_btn_test);
        list = new ArrayList<>();
adapter = new SimpleAdapter(this,list,R.layout.main_lv_users_item,
                new String[]{"user_id","user_name","user_email"},
                new int[]{R.id.main_lv_users_id,R.id.main_lv_users_name,R.id.main_lv_users_email});
        lvUsers.setAdapter(adapter);

        btnSave.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                UsersDao usersDao = new UsersDao(MainActivity.this);
                String name = "张三";
                String email = "zhangsan@163.com";
                int row = usersDao.save(name,email);
                if(row>0){
                    Toast.makeText(MainActivity.this,"添加成功!",Toast.LENGTH_SHORT)
                            .show();
                }else{
                    Toast.makeText(MainActivity.this,"添加失败！",Toast.LENGTH_SHORT).show();
                }
            }
        });

        btnSearch.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                UsersDao usersDao = new UsersDao(MainActivity.this);
                list.clear();
                list.addAll(usersDao.search());
                adapter.notifyDataSetChanged();
            }
        });
        btnTest.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Intent intent=new Intent(MainActivity.this,RegActivity.class);
                startActivity(intent);

            }
        });
}
}

4.前端页面布局xml文件

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    >
    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        app:layout_constraintTop_toTopOf="parent"
        android:id="@+id/main_tv_test"/>

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/main_linear_btn"
        android:orientation="horizontal"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintLeft_toLeftOf="parent"
        android:layout_marginTop="30dp">
        <Button
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:id="@+id/main_btn_save"
            android:text="保存"/>
        <Button
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:id="@+id/main_btn_search"
            android:text="查询"/>
        <Button
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:id="@+id/main_btn_test"
            android:text="测试"/>
    </LinearLayout>
    <ListView
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/main_lv_users"
        app:layout_constraintLeft_toLeftOf="parent"
        app:layout_constraintTop_toBottomOf="@id/main_linear_btn"></ListView>
</android.support.constraint.ConstraintLayout>