第一阶段冲刺五

忘记密码，修改密码，退出登录

一、忘记密码

1.样图

2.代码

忘记密码activity

package com.example.hotel.Activity;



import androidx.appcompat.app.AppCompatActivity;



import android.os.Bundle;

import android.view.View;

import android.widget.ArrayAdapter;

import android.widget.Button;

import android.widget.EditText;

import android.widget.TextView;



import com.example.hotel.Database.MysqlUser;

import com.example.hotel.R;



import java.sql.SQLException;



public class NopwdActivity extends AppCompatActivity {

    private Button Button;

    private EditText Userid,Userphone;

    private TextView Pwd;

    private String searpwd,searphone;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_nopwd);

        Userid=(EditText) findViewById(R.id.userid);

        Userphone=(EditText)findViewById(R.id.userphone);

        Pwd=(TextView) findViewById(R.id.pwdresult);

        Button=findViewById(R.id.searchpwd);

        Button.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View v) {

                new Thread(new Runnable() {

                    @Override

                    public void run() {

                        MysqlUser mysqlUser=new MysqlUser();

                        try {

                            String sql="select password from userinfo where id='"+Userid.getText().toString()+"'";

                            searpwd=mysqlUser.select(sql).toString();

                            String sql2="select phone from userinfo where id='"+Userid.getText().toString()+"'";

                            searphone=mysqlUser.select(sql2).toString();

                        } catch (SQLException e) {

                            e.printStackTrace();

                        }

                    }

                }).start();

                search();

            }

        });

    }

    public void search(){

        String userid=Userid.getText().toString();

        String userphone=Userphone.getText().toString();

        if(userphone.equals(searphone)){

            Pwd.setText("您的密码为："+searpwd);

        }

    }



}

忘记密码布局

<?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:orientation="vertical"

    tools:context=".Activity.NopwdActivity">



    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_marginTop="50dp"

        android:layout_marginLeft="10dp"

        android:textColor="#03A9F4"

        android:text="请输入您的id"/>



    <EditText

        android:id="@+id/userid"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:layout_margin="10dp" />



    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_marginTop="50dp"

        android:layout_marginLeft="10dp"

        android:textColor="#03A9F4"

        android:text="请输入您的手机号"/>



    <EditText

        android:id="@+id/userphone"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:layout_margin="10dp"

        />



    <TextView

        android:id="@+id/pwdresult"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_marginTop="50dp"

        android:layout_marginLeft="10dp"

        android:textSize="20sp"

        android:textColor="#ED2A08"

        android:text=""/>



    <Button

        android:id="@+id/searchpwd"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_gravity="center_horizontal"

        android:layout_marginTop="50dp"

        android:background="@drawable/btnpress"

        android:text="查询"/>

</LinearLayout>

修改密码activity

package com.example.hotel.Activity;



import androidx.appcompat.app.AppCompatActivity;



import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;



import com.example.hotel.Database.MysqlUser;

import com.example.hotel.R;



import java.sql.SQLException;



public class EditpwdActivity extends AppCompatActivity {

    private Button editButton;

    private EditText Editpwd_id,Editpwd_oldpwd,Editpwd_newpwd;

    private String editsearchid,editsearcholdpwd;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_editpwd);

        Editpwd_oldpwd=findViewById(R.id.editpwd_oldpwd);

        Editpwd_newpwd=findViewById(R.id.editpwd_newpwd);

        editButton=findViewById(R.id.editpwd);

        editButton.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View v) {

                new Thread(new Runnable() {

                    @Override

                    public void run() {

                        MysqlUser mysqlUser=new MysqlUser();

                        try {

                            String sql="select password from userinfo where id='"+Editpwd_id.getText().toString()+"'";

                            editsearcholdpwd=mysqlUser.select(sql).toString();

                        } catch (SQLException e) {

                            e.printStackTrace();

                        }

                    }

                }).start();

                edit();

            }

        });

    }

    public void edit(){

        if(editsearcholdpwd!=null){

            Toast.makeText(this,"修改成功！",Toast.LENGTH_SHORT).show();

            new Thread(new Runnable() {

                @Override

                public void run() {

                    MysqlUser mysqlUser=new MysqlUser();

                    try {

                        String sql="update user set password ="+Editpwd_newpwd.getText().toString()+"where id='"+Editpwd_id.getText().toString()+"'";

                        editsearcholdpwd=mysqlUser.select(sql).toString();

                    } catch (SQLException e) {

                        e.printStackTrace();

                    }

                }

            }).start();

        }

    }

}

连接数据库代码

package com.example.hotel.Database;



import android.util.Log;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;



public class MysqlUser {



    PreparedStatement statement;

    public static Connection getConnection(String dbname)throws SQLException {

       Connection conn=null;

        try {

            Class.forName("com.mysql.jdbc.Driver"); //加载驱动

            String ip =我的ip地址;

            conn =(Connection) DriverManager.getConnection(

                    "jdbc:mysql://" + ip + ":3306/" + dbname,

                    "user", "123456");

//            Log.e("user","连接成功!");

        }catch (SQLException | ClassNotFoundException ex) {

            ex.printStackTrace();

        }

        return conn;//返回Connection型变量conn用于后续连接

    }

    public static String select(String sql) throws SQLException {//查询数据

        String a=null;

        Connection conn=getConnection("user");

        try {

            Statement  stmt = conn.createStatement();

            //使用Connection来创建一个Statment对象

            ResultSet rs =stmt.executeQuery(sql);//

            //执行查询语句并且保存结果

            rs.first();//rs行指针指向第一行

            a=rs.getString(1);

            rs.close();//查询关闭

        } catch (SQLException e) {

            e.printStackTrace();

        }

        return a;

    }



    public static int insert(String sql) throws SQLException {//增加数据

        Connection  conn = null;

        conn = getConnection("user");

        //使用DriverManager获取数据库连接

        Statement stmt = conn.createStatement();

        //使用Connection来创建一个Statment对象

        return stmt.executeUpdate(sql);

    }



    public static int updateData(String sql) throws SQLException {//修改数据

        Connection  conn = null;

        conn = getConnection("user");

        //使用DriverManager获取数据库连接

        Statement  stmt = conn.createStatement();

        //使用Connection来创建一个Statment对象//修改的sql语句

        return stmt.executeUpdate(sql);
    }



    public static int delete(String sql)throws SQLException{   //删除数据

        Connection  conn = null;

        conn = getConnection("user");

        //使用DriverManager获取数据库连接

        Statement  stmt = conn.createStatement();

        //使用Connection来创建一个Statment对象

        return stmt.executeUpdate(sql);

    }

}

二、修改密码，退出登录

一、样图

二、代码

package com.example.hotel.Activity.User;

import android.content.Intent;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.TextView;


import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.fragment.app.Fragment;

import com.example.hotel.Activity.EditpwdActivity;
import com.example.hotel.MainActivity;
import com.example.hotel.R;

public class UserBackFragment extends Fragment {
    private Button Editbutton;
    private Button Outbutton;
    private Button Lookbutton;
    private TextView Nowid;
    private String str;
    @Nullable
    @Override
    public View onCreateView(@NonNull LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
        View view=inflater.inflate(R.layout.userback_fragment,container,false);
        Nowid=(TextView) view.findViewById(R.id.nowid);
        Bundle bundle=getArguments();
        str=null;
        if(bundle!=null)
            str=bundle.getString("nowid");
        Nowid.setText("当前用户id为："+str);
        return view;
    }

    @Override
    public void onActivityCreated(@Nullable Bundle savedInstanceState) {
        super.onActivityCreated(savedInstanceState);
        Editbutton=(Button)getActivity().findViewById(R.id.editbutton);
        Editbutton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent= new Intent(getActivity(), EditpwdActivity.class);
                Bundle bundle=new Bundle();
                bundle.putString("nowid", str);
                intent.putExtras(bundle);
                startActivity(intent);
            }
        });
        Outbutton=(Button) getActivity().findViewById(R.id.outbutton);
        Outbutton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent;
                intent = new Intent(getActivity(),MainActivity.class);
                startActivity(intent);
            }
        });
        Lookbutton=(Button) getActivity().findViewById(R.id.lookbutton);
        Lookbutton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent;
                intent = new Intent(getActivity(),HotelActivity.class);
                startActivity(intent);
            }
        });
    }
}