小蓝xlanll

这个屌丝很懒，什么也没留下！

热门标签

Android Studio 实现实现学生信息的查询 -源代码三（Servlet + 连接MySql数据库）（JSON通信）_android studio 成绩查询界面代码

作者：小蓝xlanll | 2024-02-21 09:05:48

踩

android studio 成绩查询界面代码

Android Studio 实现登录注册-源代码（连接MySql数据库）
Android Studio 实现登录注册-源代码二（Servlet + 连接MySql数据库）
[Android Studio 实现登录注册-源代码三（Servlet + 连接MySql数据库）实现学生信息的查询（JSON通信）]
Android Studio 实现实现学生信息的增删改查 -源代码四（Servlet + 连接MySql数据库）

在这里插入图片描述

一、在数据库当中创建学生信息表

在这里插入图片描述
SQL语句：

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50562
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50562
File Encoding         : 65001

Date: 2021-05-17 16:14:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `student`
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `age` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', 'andy', '21', '北京');
INSERT INTO `student` VALUES ('2', 'aaa', '22', '上海');
INSERT INTO `student` VALUES ('3', 'asdc', '34', '大连');
INSERT INTO `student` VALUES ('4', '张三', '20', '北京');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `age` int(255) NOT NULL,
  `phone` longblob NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('2', '123', 'HBV环保局', '123', '33', 0x3133333333333333333333);
INSERT INTO `users` VALUES ('3', '1233', '反复的', '1233', '12', 0x3132333333333333333333);
INSERT INTO `users` VALUES ('4', '1244', '第三代', '1244', '12', 0x3133333333333333333333);
INSERT INTO `users` VALUES ('5', '1255', 'SAS', '1255', '33', 0x3133333333333333333333);
INSERT INTO `users` VALUES ('6', '122', '但是ADS', '122', '12', 0x3132323232323232323232);
INSERT INTO `users` VALUES ('7', 'admin123', 'admin', '123', '45', 0x3132323232323232323232);
INSERT INTO `users` VALUES ('8', 'admin123', 'admin', '123', '45', 0x3132323232323232323232);
INSERT INTO `users` VALUES ('9', 'admin123', 'admin', '123', '45', 0x3132323232323232323232);
INSERT INTO `users` VALUES ('10', 'admin1232', 'admin', '123', '45', 0x3132323232323232323232);
INSERT INTO `users` VALUES ('11', 'admin222', '222', '2222', '222', 0x3232323232323232323232);
INSERT INTO `users` VALUES ('12', 'admin123', '123', '1212', '22', 0x32313231323232323232);
INSERT INTO `users` VALUES ('13', 'admin', 'admin', '2121', '33', 0x3333333333333333333333);
INSERT INTO `users` VALUES ('14', '123121212', '12321212', '123', '12', 0x3132333333333333333333);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

二、Android端代码

1、引入JSON相关的驱动包

切换工程目录
在这里插入图片描述
添加jar

切换回Android工程

2、创建Student的实体类

在这里插入图片描述

package com.example.application01.entity;

public class Student {

    private int id;
    private String name;
    private int age;
    private String address;

    public Student() {
    }

    public Student(int id, String name, int age, String address) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.address = address;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }



}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

3、创建跳转显示学生信息的页面

在这里插入图片描述

点击Finish

完善页面信息布局
在这里插入图片描述

<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.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"
    tools:context=".Student_List">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="vertical"
        tools:layout_editor_absoluteX="76dp"
        tools:layout_editor_absoluteY="98dp">

        <LinearLayout
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:padding="20dp"

            android:orientation="horizontal">


            <EditText
                android:id="@+id/stuname"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:layout_weight="1"
                android:ems="10"
                android:inputType="textPersonName"
                />

            <Button
                android:id="@+id/buttonStu"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:layout_weight="1"
                android:text="查询" />
        </LinearLayout>
        <LinearLayout
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:padding="20dp"
            android:orientation="horizontal">

            <ListView
                android:id="@+id/stulist"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content">


            </ListView>

        </LinearLayout>
    </LinearLayout>
</androidx.constraintlayout.widget.ConstraintLayout>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

在这里插入图片描述

4、修改MainActivity当中的登录成功方法，设置其跳转到上述创建的页面当中

在这里插入图片描述
全部代码

package com.example.application01;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

import com.example.application01.dao.UserDao;
import com.example.application01.utils.PostUtil;

import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    public void reg(View view){

        startActivity(new Intent(getApplicationContext(),RegisterActivity.class));

    }


    public void login(View view){

        EditText EditTextname = (EditText)findViewById(R.id.name);
        EditText EditTextpassword = (EditText)findViewById(R.id.password);

        new Thread(){
            @Override
            public void run() {

                String data="";
                try {
                    data = "name="+ URLEncoder.encode(EditTextname.getText().toString(), "UTF-8")+
                            "&password="+ URLEncoder.encode(EditTextpassword.getText().toString(), "UTF-8");
                } catch (UnsupportedEncodingException e) {
                    e.printStackTrace();
                }

                String request = PostUtil.Post("LoginServlet",data);

                int msg = 0;
                if(request.equals("成功")){
                    msg = 1;
                }

                hand1.sendEmptyMessage(msg);


            }
        }.start();


    }
    final Handler hand1 = new Handler()
    {
        @Override
        public void handleMessage(Message msg) {

            if(msg.what == 1)
            {
                //Toast.makeText(getApplicationContext(),"登录成功",Toast.LENGTH_LONG).show();
                startActivity(new Intent(getApplicationContext(),Student_List.class));
            }
            else
            {
                Toast.makeText(getApplicationContext(),"登录失败",Toast.LENGTH_LONG).show();
            }
        }
    };

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

5、创建一个XML页面用于显示ListView内部的东西

student_list.xml
在这里插入图片描述

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
    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"
    android:padding="20dp"

    >


    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal">

        <TextView
            android:id="@+id/id"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="id" />

        <TextView
            android:id="@+id/name"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="姓名" />

        <TextView
            android:id="@+id/age"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="年龄" />

        <TextView
            android:id="@+id/address"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="地址" />
    </LinearLayout>
</LinearLayout>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

5、创建StudentAdapter

在这里插入图片描述

package com.example.application01;
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;
import com.example.application01.entity.Student;

import java.util.ArrayList;

public class StudentAdapter extends BaseAdapter {

     ArrayList<Student> studatalist = new ArrayList<>();
    private Context mContext;

    public StudentAdapter(ArrayList<Student> sData, Context mContext) {
        this.sData = sData;
        this.mContext = mContext;
    }
    @Override
    public int getCount() {
        return sData.size();
    }
    @Override
    public Object getItem(int position) {
        return null;
    }

    @Override
    public long getItemId(int position) {
        return position;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {

        convertView = LayoutInflater.from(mContext).inflate(R.layout.student_list,null);

        TextView txt_id = (TextView) convertView.findViewById(R.id.id);
        TextView txt_name = (TextView) convertView.findViewById(R.id.name);
        TextView txt_age = (TextView) convertView.findViewById(R.id.age);
        TextView txt_address = (TextView) convertView.findViewById(R.id.address);

        txt_id.setText(sData.get(position).getId()+"");
        txt_name.setText(sData.get(position).getName());
        txt_age.setText(sData.get(position).getAge()+"");
        txt_address.setText(sData.get(position).getAddress());
        return convertView;
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

6、在Student_List当中实现点击搜索，并显示对应是学生列表

(1)修改activity_student_list.xnl当中的按钮

添加onClick
在这里插入图片描述

(2)在Student_List当中完善对应的方法

在这里插入图片描述

package com.example.application01;

import androidx.appcompat.app.AppCompatActivity;

import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.view.View;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;

import com.example.application01.entity.Student;
import com.example.application01.utils.PostUtil;

import org.json.JSONArray;
import org.json.JSONObject;

import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.ArrayList;

public class Student_List extends AppCompatActivity {

    EditText editTextname = null;

    ArrayList<Student> studatalist = null;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_student__list);
        editTextname = findViewById(R.id.stuname);

    }


    public void findALLStudent(View view){


        new Thread() {
            public void run() {
                if(studatalist != null){
                    studatalist.clear();
                }
                String data="";
                try {
                    data = "name="+ URLEncoder.encode(editTextname.getText().toString(), "UTF-8");
                } catch (UnsupportedEncodingException e) {
                    e.printStackTrace();
                }

                String stuJson= PostUtil.Post("studentServlet",data);

                try {

                    JSONArray jsonArray = new JSONArray(stuJson);

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

                        JSONObject jsonObject = (JSONObject) jsonArray.get(i);
                        Student student = new Student();
                        student.setId(jsonObject.getInt("id"));
                        student.setName(jsonObject.getString("name"));
                        student.setAge(jsonObject.getInt("age"));
                        student.setAddress(jsonObject.getString("address"));
                        studatalist.add(student);
                    }

                } catch (org.json.JSONException e) {
                    e.printStackTrace();
                }
                /*
                 */
                hand.sendEmptyMessage(1);

            }

        }.start();



    }
    Handler hand=new Handler(){
        @Override
        public void handleMessage(Message msg) {

            if(msg.what == 1)
            {
                ListView stuList = (ListView) findViewById(R.id.stulist);

                StudentAdapter adapter = new StudentAdapter( studatalist, Student_List.this);
                stuList.setAdapter(adapter);
                //startActivity(new Intent( getApplicationContext(),  StuInfoActivity.class ) );
            }
            else
            {
                Toast.makeText(getApplicationContext(),"查询错误",Toast.LENGTH_LONG).show();
            }
        }

    };

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104

三、Web端代码

1、创建Student实体类直接Android的复制即可

在这里插入图片描述

package entity;

public class Student {

    private int id;
    private String name;
    private int age;
    private String address;

    public Student() {
    }

    public Student(int id, String name, int age, String address) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.address = address;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }



}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

2、创建对应的StudentDao查询

在这里插入图片描述

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import entity.Student;

public class StudentDao {
	
	
	
	public ArrayList<Student> getStuByName(String name)
	{
		
		ArrayList<Student> stuList=new ArrayList<Student>();
		
		
		
		String sql="select * from student where name like '%"+name+"%'";

        Connection con=JDBCUtils.getConn();


        try {
            PreparedStatement pst=con.prepareStatement(sql);

            ResultSet rs=pst.executeQuery();
            
            while(rs.next())
            {
            	Student stu=new Student();
            	
            	stu.setId(rs.getInt(1));
            	stu.setName(rs.getString(2));
            	stu.setAge(rs.getInt(3));
            	stu.setAddress(rs.getString(4));
            	
            	stuList.add(stu);
            }


        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
        	JDBCUtils.close(con);
        }
        
        return stuList;
	}
	

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

3、在web工程当中引入JSON相关的jar

在这里插入图片描述

4、创建StudentServlet

在这里插入图片描述

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

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

import net.sf.json.JSONArray;

import dao.StudentDao;
import dao.UserDao;
import entity.Student;

public class StudentServlet extends HttpServlet {
	
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
//获取请求名字
		
		
		String name=request.getParameter("name");
		
		
		//调用dao层
		StudentDao studentDAO=new StudentDao();
		
		ArrayList<Student> stuList=studentDAO.getStuByName(name);
		
		
		response.setContentType("application/x-json");
		response.setCharacterEncoding("utf-8");
		PrintWriter out = response.getWriter();
		
		
		JSONArray jsonArray = JSONArray.fromObject(stuList); 
		out.print(jsonArray);

		
		out.flush();
		out.close();
	
	}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

四、运行测试

先启动web端代码
在这里插入图片描述
运行Android端代码

Android Studio 实现登录注册-源代码（连接MySql数据库）
Android Studio 实现登录注册-源代码二（Servlet + 连接MySql数据库）
[Android Studio 实现登录注册-源代码三（Servlet + 连接MySql数据库）实现学生信息的查询（JSON通信）]
Android Studio 实现实现学生信息的增删改查 -源代码四（Servlet + 连接MySql数据库）

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小蓝xlanll/article/detail/122339?site

Android Studio 实现实现学生信息的查询 -源代码 三（Servlet + 连接MySql数据库） （JSON通信）_android studio 成绩查询界面代码

一、在数据库当中创建学生信息表

二、Android端代码

1、引入JSON相关的驱动包

2、创建Student的实体类

3、创建跳转显示学生信息的页面

4、修改MainActivity当中的登录成功方法，设置其跳转到上述创建的页面当中

5、创建一个XML页面用于显示ListView内部的东西

5、创建StudentAdapter

6、在Student_List当中实现点击搜索，并显示对应是学生列表

(1)修改activity_student_list.xnl当中的按钮

(2)在Student_List当中完善对应的方法

三、Web端代码

1、创建Student实体类直接Android的复制即可

2、创建对应的StudentDao查询

3、在web工程当中引入JSON相关的jar

4、创建StudentServlet

四、运行测试

Android Studio 实现实现学生信息的查询 -源代码三（Servlet + 连接MySql数据库）（JSON通信）_android studio 成绩查询界面代码