3.Mysql开启远程连接参考这篇：https://blog.csdn.net/weixin_44013967/article/details/105312455?spm=1001.2101.3001.6661..._android连接mysql数据库实现注册">
devbox
小丑西瓜9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Android studio使用JDBC连接My SQL实现登陆注册修改（用户登录界面）详解_android连接mysql数据库实现注册

作者：小丑西瓜9 | 2024-04-10 20:17:36

赞

踩

android连接mysql数据库实现注册

一，准备工作

1.下载mysql-connector-java

2.在Android Manifest.xml中配置添加

 <uses-permission android:name="android.permission.INTERNET" />

3. Mysql开启远程连接

参考这篇：

https://blog.csdn.net/weixin_44013967/article/details/105312455?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7ETopBlog-1.topblog&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7ETopBlog-1.topblog&utm_relevant_index=1https://blog.csdn.net/weixin_44013967/article/details/105312455?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog-2~default~CTRLIST~TopBlog-1.topblog&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-2~default~CTRLIST~TopBlog-1.topblog&utm_relevant_index=1

4.在数据库创建表添加数据（这里比较简单的添加） 

二、编写Android Studio的java类和xml布局文件

1.在Android Studio当中创建JDBCUtils类

  1. package com.example.login_test;
  2. import android.util.Log;
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.SQLException;
  6. public class JDBCUtils {
  7.     private static String driver = "com.mysql.jdbc.Driver";// MySql驱动
  8.     //xxx.xxx.xxx.xxx为我电脑的ip，这里要用自己电脑的ip，login为我电脑的数据库名，也要换。
  9.     private static String url = "jdbc:mysql://xxx.xxx.xxx.xxx:3306/login?serverTimezone=UTC";
  10.     private static String user = "root";// 用户名
  11.     private static String password = "abc123";// 密码
  12.  
  13.     public static  Connection getConn() {
  14.         //开启连接数据库
  15.         Log.d("test", "开启连接数据库。。。。。");
  16.         Connection connection = null;
  17.         try{
  18.             Class.forName(driver);// 动态加载类
  19.             connection = DriverManager.getConnection(url, user, password);  // 尝试建立到给定数据库URL的连接
  20.         }catch (Exception e){
  21.             e.printStackTrace();
  22.         }
  23.         return connection;
  24.  
  25.     }
  26.     public static void close(Connection conn){//关闭数据库连接
  27.         Log.d("test", "关闭数据库连接。。。。");
  28.         try {
  29.             conn.close();
  30.         } catch (SQLException e) {
  31.             e.printStackTrace();
  32.         }
  33.     }
  34. }
  35.

 2.创建User类（这里我写的比较简单，大家有要求可以添加）

  1. package com.example.login_test;
  2.  
  3. public class User {//用户类
  4.     String user_name;
  5.     String user_password;
  6.  
  7.     public User() {
  8.     }
  9.  
  10.     public User(String user_name, String password) {
  11.         this.user_name = user_name;
  12.         this.user_password = password;
  13.     }
  14.  
  15.     public String getUser_name() {
  16.         return user_name;
  17.     }
  18.  
  19.     public void setUser_name(String user_name) {
  20.         this.user_name = user_name;
  21.     }
  22.  
  23.     public String getPassword() {
  24.         return user_password;
  25.     }
  26.  
  27.     public void setPassword(String user_password) {
  28.         this.user_password = user_password;
  29.     }
  30. }

3.创建dao层和UserDao

  1. package com.example.login_test;
  2.  
  3. import android.util.Log;
  4.  
  5. import java.sql.Connection;
  6. import java.sql.PreparedStatement;
  7. import java.sql.ResultSet;
  8. import java.sql.SQLException;
  9. import java.sql.Statement;
  10.  
  11. public class UserDao {
  12.     public boolean login(String username, String password) {//判断是否登录成功
  13.         Log.d("test", "开始成功。。。。。");
  14.         String sql = "select * from user where username = ? and password = ?";//sql语句
  15.         Connection con = JDBCUtils.getConn();//连接数据库
  16.         try {
  17.             PreparedStatement pst = con.prepareStatement(sql);//调用数据库连接对象con的方法prepareStatement获取SQL语句的预编译对
  18.             pst.setString(1, username);//调用pst的方法setXXX设置?占位
  19.             pst.setString(2, password);
  20.             if (pst.executeQuery().next()) {//查数据用executeQuery() 返回的是一个集合，如果有数据就返回true
  21.                 Log.d("test", "登录成功");
  22.                 return true;
  23.             }
  24.         } catch (SQLException e) {
  25.             e.printStackTrace();
  26.         } finally {
  27.             JDBCUtils.close(con);//关闭数据库
  28.         }
  29.         Log.d("test", "登录失败");
  30.         return false;
  31.     }
  32.  
  33.  
  34.     public boolean register(User user) {//注册用户密码
  35.         Log.d("test", "开始注册。。。。。");
  36.         String sql = "insert into user(username,password) values (?,?)";//sql语句
  37.         Connection con = JDBCUtils.getConn();//连接数据库
  38.         try {
  39.             PreparedStatement pst = con.prepareStatement(sql);//调用数据库连接对象con的方法prepareStatement获取SQL语句的预编译对
  40.             pst.setString(1, user.getUser_name());//调用pst的方法setXXX设置?占位
  41.             pst.setString(2, user.getPassword());
  42.             int value = pst.executeUpdate();//executeUpdate 的返回值是一个整数，指示受影响的行数（即更新计数）
  43.             if (value > 0) {
  44.                 Log.d("test", "register: 注册成功");
  45.                 return true;
  46.             }
  47.  
  48.         } catch (SQLException e) {
  49.             e.printStackTrace();
  50.         } finally {
  51.             JDBCUtils.close(con);
  52.         }
  53.         Log.d("test", "register: 注册失败");
  54.         return false;
  55.     }
  56.  
  57.  
  58.     public User findUser(String username) {//查询用户名
  59.         String sql = "select * from user where username = ?";
  60.         Connection con = JDBCUtils.getConn();//连接数据库
  61.         User user = null;
  62.         try {
  63.             PreparedStatement pst = con.prepareStatement(sql);//调用数据库连接对象con的方法prepareStatement获取SQL语句的预编译对
  64.             pst.setString(1, username);  // 调用pst的方法setXXX设置?占位
  65.             ResultSet rs = pst.executeQuery();//查数据用executeQuery() 返回的是一个集合，如果有数据就返回true
  66.             while (rs.next()) {//.next（）表示 指针先下一行,如果有数据就返回true
  67.                 String name = rs.getString(1);//获取查询到的账号密码
  68.                 String password = rs.getString(2);
  69.                 user = new User(name, password);//传给user对象
  70.             }
  71.         } catch (SQLException e) {
  72.             e.printStackTrace();
  73.         } finally {
  74.             JDBCUtils.close(con);
  75.         }
  76.         return user;//传入成功返回账号密码，失败则为null
  77.     }
  78.  
  79.     public int update(String name,String password) {
  80.  
  81.         String sql = "update user set password=? where username=?";
  82.         Connection con = JDBCUtils.getConn();//连接数据库
  83.         int i = 0;
  84.         Log.d("test", "开始修改。。。。。");
  85.  
  86.         try {
  87.             PreparedStatement pst = con.prepareStatement(sql);
  88.             pst.setString(2, name);//调用pst的方法setXXX设置?占位
  89.             pst.setString(1, password);
  90.             i = pst.executeUpdate();
  91.             System.out.println("resutl: " + i);
  92.             pst.close();
  93.             con.close();
  94.         } catch (SQLException e) {
  95.             e.printStackTrace();
  96.         }
  97.         return i;
  98.     }
  99.     public int updateUserData(User user){
  100.         Log.d("test"," 开始修改。。。。。");
  101.                 int result=-1;
  102.                 //获取链接数据库对象
  103.                 Connection  con= JDBCUtils.getConn();
  104.                 //MySQL 语句
  105.                 String sql="update user set password=? where username=?";
  106.  
  107.         try {
  108.             boolean closed=con.isClosed();
  109.             if(con!=null&&(!closed)){
  110.                 PreparedStatement pst=con.prepareStatement(sql);
  111.                 pst.setString(1,user.getPassword());
  112.                 //第一个参数state 一定要和上面SQL语句字段顺序一致
  113.                 pst.setString(2, user.getUser_name());
  114.                 //第二个参数 phone 一定要和上面SQL语句字段顺序一致
  115.                 result=pst.executeUpdate();
  116.                 //返回1 执行成功
  117.                 Log.d("test"," 修改成功。。。。。");
  118.                 Log.d("test","result： "+result);
  119.             }
  120.         } catch (SQLException e) {
  121.             e.printStackTrace();
  122.         } finally {
  123.             JDBCUtils.close(con);
  124.         }
  125.         return result;
  126.     }
  127. }

三、编写页面和Activity相关代码（这里写的比较粗糙，有些功能不全，欢迎各位大神来指导交流）

图片资源：

 1.登录页面 activity_login.xml

  1. <?xml version="1.0" encoding="utf-8"?>
  2. <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
  3.     xmlns:app="http://schemas.android.com/apk/res-auto"
  4.     xmlns:tools="http://schemas.android.com/tools"
  5.     android:layout_width="match_parent"
  6.     android:layout_height="match_parent"
  7.     tools:context=".Login_Activity"
  8.     android:orientation="vertical"
  9.     android:background="@drawable/wallpaper1"
  10.  
  11.     >
  12.     <LinearLayout
  13.         android:layout_width="match_parent"
  14.         android:layout_height="wrap_content"
  15.         android:orientation="vertical"
  16.         android:padding="60dp"
  17.         android:layout_marginTop="90dp"
  18.  
  19.         >
  20. <LinearLayout
  21.     android:layout_width="wrap_content"
  22.     android:layout_height="wrap_content"
  23.     android:layout_gravity="center"
  24.     >
  25.     <TextView
  26.         android:layout_width="wrap_content"
  27.         android:layout_height="wrap_content"
  28.         android:text="Welcome"
  29.         android:textSize="60dp"
  30.         android:textColor="#fff"
  31.         />
  32. </LinearLayout>
  33.     <LinearLayout
  34.         android:layout_width="match_parent"
  35.         android:layout_height="wrap_content"
  36.         android:layout_marginTop="40dp"
  37.         >
  38.         <EditText
  39.             android:id="@+id/user_name"
  40.             android:hint="请输入账号"
  41.             android:textSize="15dp"
  42.             android:paddingLeft="20dp"
  43.             android:layout_width="match_parent"
  44.             android:layout_height="45dp"
  45.             android:background="#fff"
  46.             android:alpha="0.9"
  47.     />
  48.     </LinearLayout>
  49.     <LinearLayout
  50.         android:layout_width="match_parent"
  51.         android:layout_height="wrap_content"
  52.         android:layout_marginTop="3dp">
  53.         <EditText
  54.             android:id="@+id/user_passw"
  55.             android:hint="请输入密码"
  56.             android:textSize="15dp"
  57.             android:paddingLeft="20dp"
  58.             android:inputType="textPassword"
  59.             android:layout_width="match_parent"
  60.             android:layout_height="45dp"
  61.             android:background="#fff"
  62.             android:alpha="0.9"
  63.             />
  64.     </LinearLayout>
  65.         <LinearLayout
  66.             android:layout_marginTop="5dp"
  67.             android:layout_width="match_parent"
  68.             android:layout_height="wrap_content"
  69.             android:gravity="right">
  70.             <TextView
  71.                 android:layout_width="wrap_content"
  72.                 android:layout_height="wrap_content"
  73.                 android:text="修改密码"
  74.                 android:textColor="#af3a11"
  75.                 android:onClick="amend"
  76.                 />
  77.         </LinearLayout>
  78.         <LinearLayout
  79.             android:layout_width="match_parent"
  80.             android:layout_height="wrap_content"
  81.             android:layout_marginTop="20dp"
  82.             >
  83.             <Button
  84.                 android:id="@+id/btn_login"
  85.                 android:layout_width="match_parent"
  86.                 android:layout_height="wrap_content"
  87.                 android:background="#fd8f36"
  88.                 android:text="Sign in"
  89.                 android:textColor="#ffffff"
  90.                 android:textSize="25dp"
  91.                 android:textAllCaps="false"
  92.                 android:onClick="login"
  93.                 />
  94.         </LinearLayout>
  95.  
  96.         <LinearLayout
  97.             android:layout_width="match_parent"
  98.             android:layout_height="wrap_content"
  99.             android:layout_marginTop="20dp"
  100.             >
  101.             <Button
  102.                 android:id="@+id/btn_add"
  103.                 android:layout_width="match_parent"
  104.                 android:layout_height="wrap_content"
  105.                 android:background="#af3a11"
  106.                 android:text="Sign up"
  107.                 android:textColor="#ffffff"
  108.                 android:textSize="25dp"
  109.                 android:textAllCaps="false"
  110.                 android:onClick="add"
  111.                 />
  112.         </LinearLayout>
  113.     </LinearLayout>
  114. </RelativeLayout>

 2.注册页面 activity_add_.xml

  1. <?xml version="1.0" encoding="utf-8"?>
  2. <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
  3.     xmlns:app="http://schemas.android.com/apk/res-auto"
  4.     xmlns:tools="http://schemas.android.com/tools"
  5.     android:layout_width="match_parent"
  6.     android:layout_height="match_parent"
  7.     tools:context=".Add_Activity"
  8.     android:orientation="vertical"
  9.     android:background="@drawable/wallpaper1"
  10.     >
  11.     <TextView
  12.         android:layout_marginLeft="10dp"
  13.         android:layout_width="wrap_content"
  14.         android:layout_height="wrap_content"
  15.         android:text="(---"
  16.         android:textSize="40dp"
  17.         android:textColor="#ffffff"
  18.         android:onClick="back"
  19.         />
  20.     <LinearLayout
  21.         android:layout_width="match_parent"
  22.         android:layout_height="wrap_content"
  23.         android:orientation="vertical"
  24.         android:padding="60dp"
  25.         android:layout_marginTop="90dp"
  26.  
  27.         >
  28.         <LinearLayout
  29.             android:layout_width="wrap_content"
  30.             android:layout_height="wrap_content"
  31.             android:layout_gravity="center"
  32.             >
  33.             <TextView
  34.                 android:layout_width="wrap_content"
  35.                 android:layout_height="wrap_content"
  36.                 android:text="Welcome"
  37.                 android:textSize="60dp"
  38.                 android:textColor="#fff"
  39.                 />
  40.         </LinearLayout>
  41.         <LinearLayout
  42.             android:layout_width="match_parent"
  43.             android:layout_height="wrap_content"
  44.             android:layout_marginTop="40dp"
  45.             >
  46.             <EditText
  47.                 android:id="@+id/add_name"
  48.                 android:hint="账号"
  49.                 android:textSize="15dp"
  50.                 android:paddingLeft="20dp"
  51.                 android:layout_width="match_parent"
  52.                 android:layout_height="45dp"
  53.                 android:background="#fff"
  54.                 android:alpha="0.9"
  55.                 />
  56.         </LinearLayout>
  57.         <LinearLayout
  58.             android:layout_width="match_parent"
  59.             android:layout_height="wrap_content"
  60.             android:layout_marginTop="3dp">
  61.  
  62.             <EditText
  63.                 android:id="@+id/add_password1"
  64.                 android:layout_width="match_parent"
  65.                 android:layout_height="45dp"
  66.                 android:alpha="0.9"
  67.                 android:background="#fff"
  68.                 android:hint="密码"
  69.                 android:inputType="textPassword"
  70.                 android:paddingLeft="20dp"
  71.                 android:textSize="15dp" />
  72.         </LinearLayout>
  73.         <LinearLayout
  74.             android:layout_width="match_parent"
  75.             android:layout_height="wrap_content"
  76.             android:layout_marginTop="3dp">
  77.             <EditText
  78.                 android:id="@+id/add_password2"
  79.                 android:hint="确认密码"
  80.                 android:textSize="15dp"
  81.                 android:paddingLeft="20dp"
  82.                 android:layout_width="match_parent"
  83.                 android:inputType="textPassword"
  84.                 android:layout_height="45dp"
  85.                 android:background="#fff"
  86.                 android:alpha="0.9"
  87.                 />
  88.         </LinearLayout>
  89.         <LinearLayout
  90.             android:layout_marginTop="3dp"
  91.             android:orientation="horizontal"
  92.             android:layout_width="match_parent"
  93.             android:layout_height="wrap_content">
  94.             <EditText
  95.                 android:id="@+id/ed_yzm"
  96.                 android:hint="验证码"
  97.                 android:textSize="15dp"
  98.                 android:paddingLeft="20dp"
  99.                 android:layout_width="0dp"
  100.                 android:layout_weight="1"
  101.                 android:layout_height="45dp"
  102.                 android:background="#fff"
  103.                 android:alpha="0.9"
  104.                 />
  105.             <ImageView
  106.                 android:id="@+id/img_yzm"
  107.                 android:layout_marginLeft="5dp"
  108.                 android:layout_width="0dp"
  109.                 android:layout_weight="1"
  110.                 android:layout_height="match_parent"
  111.                 android:onClick="cut"
  112.  
  113.                 />
  114.         </LinearLayout>
  115.  
  116.         <LinearLayout
  117.             android:layout_width="match_parent"
  118.             android:layout_height="wrap_content"
  119.             android:layout_marginTop="20dp"
  120.             >
  121.             <Button
  122.                 android:id="@+id/btn_add"
  123.                 android:layout_width="match_parent"
  124.                 android:layout_height="wrap_content"
  125.                 android:background="#af3a11"
  126.                 android:text="Sign up"
  127.                 android:textColor="#ffffff"
  128.                 android:textSize="25dp"
  129.                 android:textAllCaps="false"
  130.                 android:onClick="add"
  131.                 />
  132.         </LinearLayout>
  133.     </LinearLayout>
  134. </RelativeLayout>

3.验证码 CodeUtils

  1. package com.example.login_test;
  2.  
  3.  
  4. import android.graphics.Bitmap;
  5. import android.graphics.Canvas;
  6. import android.graphics.Color;
  7. import android.graphics.Paint;
  8.  
  9. import java.util.Random;
  10.  
  11. public class CodeUtils {//验证码工具类
  12.     private static final char[] CHARS = {
  13.             '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  14.             'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm',
  15.             'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z',
  16.             'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',
  17.             'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'
  18.  
  19.     };
  20.  
  21.     //  绘图准备
  22.     private static CodeUtils mCodeUtils;
  23.     private int mPaddingLeft, mPaddingTop;
  24.     private StringBuilder mBuilder = new StringBuilder();
  25.     private Random mRandom = new Random();
  26.  
  27.     private static final int DEFAULT_CODE_LENGTH = 6;//验证码的长度  这里6位，可以简单点，简单一点
  28.  
  29.     private static final int DEFAULT_FONT_SIZE = 60;//字体大小
  30.     private static final int DEFAULT_LINE_NUMBER = 3;//多少条干扰线
  31.     private static final int BASE_PADDING_LEFT = 20; //左边距
  32.     private static final int RANGE_PADDING_LEFT = 30;//左边距范围值
  33.     private static final int BASE_PADDING_TOP = 70;//上边距
  34.     private static final int RANGE_PADDING_TOP = 15;//上边距范围值
  35.     private static final int DEFAULT_WIDTH = 300;//默认宽度.图片的总宽
  36.     private static final int DEFAULT_HEIGHT = 100;//默认高度.图片的总高
  37.     private static final int DEFAULT_COLOR = 0xDF;//默认背景颜色值
  38.  
  39.  
  40.     private String code;
  41.     public static CodeUtils getInstance() {
  42.         if (mCodeUtils == null) {
  43.             mCodeUtils = new CodeUtils();
  44.         }
  45.         return mCodeUtils;
  46.  
  47.     }
  48.  
  49.  
  50.     public Bitmap createBitmap() {
  51.         mPaddingLeft = 0;
  52.         mPaddingTop = 0;
  53.         Bitmap bitmap = Bitmap.createBitmap(DEFAULT_WIDTH, DEFAULT_HEIGHT, Bitmap.Config.ARGB_8888);
  54.         Canvas canvas = new Canvas(bitmap);
  55.         code = createCode();
  56.  
  57.         canvas.drawColor(Color.rgb(DEFAULT_COLOR, DEFAULT_COLOR, DEFAULT_COLOR));
  58.  
  59.         Paint paint = new Paint();
  60.  
  61.         paint.setTextSize(DEFAULT_FONT_SIZE);
  62.  
  63.         for (int i = 0; i < code.length(); i++) {
  64.             randomTextStyle(paint);
  65.             randomPadding();
  66.             canvas.drawText(code.charAt(i) + "", mPaddingLeft, mPaddingTop, paint);
  67.  
  68.         }
  69.  
  70.         for (int i = 0; i < DEFAULT_LINE_NUMBER; i++) {
  71.  
  72.             drawLine(canvas, paint);
  73.  
  74.         }
  75.  
  76. //      这段代码，由于API28版本太高不能使用，所以需要降版本，否则报错
  77.         canvas.save();
  78.         canvas.restore();
  79.         return bitmap;
  80.  
  81.     }
  82.  
  83.  
  84.     public String getCode() {
  85.  
  86.         return code;
  87.  
  88.     }
  89.  
  90.  
  91.     public String createCode() {
  92.         mBuilder.delete(0, mBuilder.length());
  93.         for (int i = 0; i < DEFAULT_CODE_LENGTH; i++) {
  94.             mBuilder.append(CHARS[mRandom.nextInt(CHARS.length)]);
  95.         }
  96.         return mBuilder.toString();
  97.     }
  98.     private void drawLine(Canvas canvas, Paint paint) {
  99.  
  100.         int color = randomColor();
  101.  
  102.         int startX = mRandom.nextInt(DEFAULT_WIDTH);
  103.  
  104.         int startY = mRandom.nextInt(DEFAULT_HEIGHT);
  105.  
  106.         int stopX = mRandom.nextInt(DEFAULT_WIDTH);
  107.  
  108.  
  109.         int stopY = mRandom.nextInt(DEFAULT_HEIGHT);
  110.  
  111.  
  112.         paint.setStrokeWidth(1);
  113.         paint.setColor(color);
  114.  
  115.         canvas.drawLine(startX, startY, stopX, stopY, paint);
  116.  
  117.     }
  118.  
  119.     private int randomColor() {
  120.         mBuilder.delete(0, mBuilder.length());
  121.  
  122.         String haxString;
  123.         for (int i = 0; i < 3; i++) {
  124.             haxString = Integer.toHexString(mRandom.nextInt(0xFF));
  125.  
  126.             if (haxString.length() == 1) {
  127.                 haxString = "0" + haxString;
  128.             }
  129.  
  130.             mBuilder.append(haxString);
  131.         }
  132.         return Color.parseColor("#" + mBuilder.toString());
  133.     }
  134.  
  135.  
  136.     private void randomTextStyle(Paint paint) {
  137.  
  138.         int color = randomColor();
  139.  
  140.         paint.setColor(color);
  141.  
  142.         paint.setFakeBoldText(mRandom.nextBoolean());
  143.  
  144.         float skewX = mRandom.nextInt(11) / 10;
  145.  
  146.         skewX = mRandom.nextBoolean() ? skewX : -skewX;
  147.  
  148.         paint.setTextSkewX(skewX);
  149.     }
  150.  
  151.     private void randomPadding() {
  152.         mPaddingLeft += BASE_PADDING_LEFT + mRandom.nextInt(RANGE_PADDING_LEFT);
  153.  
  154.         mPaddingTop = BASE_PADDING_TOP + mRandom.nextInt(RANGE_PADDING_TOP);
  155.     }
  156.  
  157. }

4.完善登录功能  Login_Activity

  1. package com.example.login_test;
  2.  
  3. import androidx.appcompat.app.AppCompatActivity;
  4.  
  5. import android.content.Intent;
  6. import android.os.Bundle;
  7. import android.os.Handler;
  8. import android.os.Message;
  9. import android.text.TextUtils;
  10. import android.util.Log;
  11. import android.view.View;
  12. import android.widget.Button;
  13. import android.widget.EditText;
  14. import android.widget.TextView;
  15. import android.widget.Toast;
  16.  
  17. import java.sql.Connection;
  18. import java.sql.DriverManager;
  19. import java.sql.ResultSet;
  20. import java.sql.SQLException;
  21. import java.sql.Statement;
  22.  
  23. public class Login_Activity extends AppCompatActivity{//登录页面
  24.     private EditText editTextname;
  25.     private EditText editTextpassword;
  26.     User user;
  27.     User uu;
  28.     @Override
  29.     protected void onCreate(Bundle savedInstanceState) {
  30.         super.onCreate(savedInstanceState);
  31.         setContentView(R.layout.activity_login);
  32.         getSupportActionBar().hide();
  33.         intUI();//初始化页面
  34.     }
  35.  
  36.     private void intUI() {
  37.             editTextname = (EditText)findViewById(R.id.user_name);
  38.             editTextpassword = (EditText)findViewById(R.id.user_passw);
  39.     }
  40.  
  41.     public void login(View view) {
  42.         final String user_name=editTextname.getText().toString();//获取账号
  43.         String user_password=editTextpassword.getText().toString();//获取密码
  44.         user=new User();
  45.         user.setUser_name(user_name);//把数据传给user对象
  46.         Log.d("”test", "add_name:"+user_name);
  47.  
  48.         if(TextUtils.isEmpty(user_name)){//判账号是否为空
  49.             Toast.makeText(this, "请输入用户名", Toast.LENGTH_SHORT).show();
  50.             return;
  51.         }else if(TextUtils.isEmpty(user_password)){//判密码是否为空
  52.             Toast.makeText(this, "请输入密码", Toast.LENGTH_SHORT).show();
  53.             return;
  54.         }
  55. //必须以线程形式访问，否则报错,我也是萌新不懂，照做就对了
  56.         new Thread(new Runnable() {
  57.             @Override
  58.             public void run() {
  59.                 UserDao userDao = new UserDao();
  60.                 uu = userDao.findUser(user.getUser_name());
  61.                 Log.d("test", "uu:"+uu);
  62.                 boolean aa = userDao.login(editTextname.getText().toString(),editTextpassword.getText().toString());
  63.                 int msg = 0;
  64.                 if(aa){
  65.                     msg = 1;
  66.                 }else{
  67.                     msg = 2;
  68.                 }
  69.                 hand1.sendEmptyMessage(msg);
  70.             }
  71.         }).start();
  72.     }
  73.     final Handler hand1 = new Handler(){
  74.         public void handleMessage(Message msg) {
  75.             if(uu==null){
  76.                 Toast.makeText(Login_Activity.this, "未找到用户，请注册", Toast.LENGTH_SHORT).show();
  77.                 return;
  78.             }else {
  79.                 if (msg.what == 1) {
  80.                     Toast.makeText(getApplicationContext(), "登录成功", Toast.LENGTH_LONG).show();
  81.                     Intent intent = new Intent(Login_Activity.this,Login_after_Activity.class);
  82.                     startActivity(intent);
  83.                 } else if (msg.what == 2) {
  84.                     Toast.makeText(getApplicationContext(), "密码错误", Toast.LENGTH_LONG).show();
  85.                 }
  86.             }
  87.         }
  88.     };
  89.  
  90.     public void add(View view) {
  91.         Intent intent = new Intent(Login_Activity.this,Add_Activity.class);
  92.         startActivity(intent);
  93.         finish();
  94.     }
  95.  
  96.     public void amend(View view) {
  97.         Intent intent = new Intent(Login_Activity.this,Change_Activity.class);
  98.         startActivity(intent);
  99.         finish();
  100.     }
  101. }

5.完善注册功能 Add_Activity

  1. package com.example.login_test;
  2.  
  3. import androidx.appcompat.app.AppCompatActivity;
  4.  
  5. import android.content.Intent;
  6. import android.os.Bundle;
  7. import android.os.Handler;
  8. import android.os.Message;
  9. import android.util.Log;
  10. import android.view.View;
  11. import android.widget.EditText;
  12. import android.widget.ImageView;
  13. import android.widget.Toast;
  14.  
  15. public class Add_Activity extends AppCompatActivity {//注册页面
  16.     private EditText add_password1;
  17.     private EditText add_password2;
  18.     private EditText add_name;
  19.     private String realCode;
  20.     private EditText ed_yzm;
  21.     private ImageView iv_yzm;
  22.     String etCode;
  23.     @Override
  24.     protected void onCreate(Bundle savedInstanceState) {
  25.         super.onCreate(savedInstanceState);
  26.         setContentView(R.layout.activity_add_);
  27.         intUI();//初始化
  28.         getSupportActionBar().hide();//隐藏标题栏
  29.     }
  30.  
  31.     private void intUI() {
  32.         add_name = findViewById(R.id.add_name);
  33.         add_password1 = findViewById(R.id.add_password1);
  34.         add_password2 = findViewById(R.id.add_password2);
  35.         iv_yzm = findViewById(R.id.img_yzm);
  36.         ed_yzm = findViewById(R.id.ed_yzm);
  37.         iv_yzm.setImageBitmap(CodeUtils.getInstance().createBitmap());
  38.         realCode = CodeUtils.getInstance().getCode().toLowerCase();
  39.     }
  40.     public void cut(View view) {//验证码
  41.         iv_yzm.setImageBitmap(CodeUtils.getInstance().createBitmap());
  42.         realCode = CodeUtils.getInstance().getCode().toLowerCase();
  43.     }
  44.  
  45.     public void add(View view) {//注册按钮
  46.         Log.d("”test", "add: 开始注册");
  47.         String user_name=add_name.getText().toString();
  48.         String user_password1=add_password1.getText().toString();
  49.         String user_password2=add_password2.getText().toString();
  50.         Log.d("”test", "add_name:"+user_name);
  51.         Log.d("”test", "add_password1:"+user_password1);
  52.         Log.d("”test", "add_password2:"+user_password2);
  53.  
  54.         final User user = new User();//创建对象
  55.         user.setUser_name(user_name);//传值
  56.         user.setPassword(user_password1);//z
  57.  
  58.         if(user_name.length() <10 ){
  59.             Toast.makeText(getApplicationContext(),"账户长度不符合要求<至少10位数>",Toast.LENGTH_LONG).show();
  60.             return;
  61.         }
  62.         if(user_password1.length()<6 ){
  63.             Toast.makeText(getApplicationContext(),"密码长度不符合要求<至少6个字符/数字>",Toast.LENGTH_LONG).show();
  64.             return;
  65.         }
  66.         if(user_password2==null){
  67.             Toast.makeText(getApplicationContext(),"请再次输入密码",Toast.LENGTH_LONG).show();
  68.             return;
  69.         }
  70.         if(user_password1.equals(user_password2)){
  71.  
  72.         }else {
  73.             Toast.makeText(getApplicationContext(),"密码不一致，请重新输入",Toast.LENGTH_LONG).show();
  74.             return;
  75.         }
  76.  
  77.         etCode=ed_yzm.getText().toString().toLowerCase();//获取验证码
  78.         if(etCode.equals(realCode)){
  79.  
  80.         }else{
  81.             Toast.makeText(Add_Activity.this, "请输入正确的验证码", Toast.LENGTH_SHORT).show();
  82.             return;
  83.         }
  84.         new Thread(new Runnable() {
  85.             @Override
  86.             public void run() {
  87.                 int msg = 0;
  88.                 UserDao userDao = new UserDao();
  89.                 User uu = userDao.findUser(user.getUser_name());//查询用户名
  90.                 Log.d("test", "uu:"+uu);
  91.  
  92.                     if(uu != null){
  93.                         msg = 1;
  94.                     }else{
  95.                         boolean flag = userDao.register(user);
  96.                         Log.d("test", "user"+user);
  97.                         if(flag){
  98.                             msg = 2;
  99.                         }
  100.                     }
  101.  
  102.  
  103.  
  104.                 Log.d("test",etCode);
  105.  
  106.  
  107.                 hand.sendEmptyMessage(msg);
  108.  
  109.  
  110.  
  111.             }
  112.         }).start();
  113.  
  114.     }
  115.     final Handler hand = new Handler(){
  116.         public void handleMessage(Message msg) {
  117.                 if(msg.what == 0){
  118.                     Toast.makeText(Add_Activity.this, "注册失败", Toast.LENGTH_SHORT).show();
  119.                 }
  120.                 if(msg.what == 1)
  121.                 {
  122.                     Toast.makeText(Add_Activity.this, "该账号已经存在，请换一个账号", Toast.LENGTH_SHORT).show();
  123.                 }
  124.                 if(msg.what == 2) {
  125.                     Toast.makeText(Add_Activity.this, "注册成功", Toast.LENGTH_SHORT).show();
  126.                     Log.d("”test", "add: 用户注册成功");
  127.                     Intent intent = new Intent(Add_Activity.this,Login_Activity.class);
  128.                     intent.putExtra("a","注冊");
  129.                     startActivity(intent);
  130.                     finish();
  131.                 }
  132.  
  133.         }
  134.     };
  135.  
  136.  
  137.     public void back(View view) {
  138.         Intent intent=new Intent(Add_Activity.this,Login_Activity.class);
  139.         startActivity(intent);
  140.     }
  141. }

6.修改密码页面  Change_Activity

  1. package com.example.login_test;
  2.  
  3. import androidx.appcompat.app.AppCompatActivity;
  4.  
  5. import android.content.Intent;
  6. import android.os.Bundle;
  7. import android.os.Handler;
  8. import android.os.Message;
  9. import android.util.Log;
  10. import android.view.View;
  11. import android.widget.Button;
  12. import android.widget.EditText;
  13. import android.widget.Toast;
  14.  
  15. public class Change_Activity extends AppCompatActivity {
  16.  
  17.     private EditText change_password2;
  18.     private EditText change_password1;
  19.     private EditText change_password;
  20.     private EditText change_name;
  21.     private Button btn_change;
  22.     User uu;
  23.  
  24.     @Override
  25.     protected void onCreate(Bundle savedInstanceState) {
  26.         super.onCreate(savedInstanceState);
  27.         setContentView(R.layout.activity_change);
  28.         getSupportActionBar().hide();
  29.         intUI();
  30.     }
  31.  
  32.     private void intUI() {
  33.         change_name = findViewById(R.id.change_name);
  34.         change_password = findViewById(R.id.change_password);
  35.         change_password1 = findViewById(R.id.change_password1);
  36.         change_password2 = findViewById(R.id.change_password2);
  37.         btn_change = findViewById(R.id.btn_change);
  38.     }
  39.  
  40.     public void change(View view) {
  41.         final String Change_name=change_name.getText().toString();
  42.         final String Change_password=change_password.getText().toString();
  43.         final  String Change_password1=change_password1.getText().toString();
  44.         final String Change_password2=change_password2.getText().toString();
  45.         if(Change_name.length()<6){
  46.             Toast.makeText(this, "账号长度不够。。。", Toast.LENGTH_SHORT).show();
  47.             return;
  48.         }
  49.         if(Change_password.length()<=0||Change_password1.length()<=0){
  50.             Toast.makeText(this, "密码不能为空", Toast.LENGTH_SHORT).show();
  51.             return;
  52.         }
  53.         if(Change_password1==null){
  54.             Toast.makeText(this, "新密码不能为空", Toast.LENGTH_SHORT).show();
  55.             return;
  56.         }
  57.         if(!(Change_password1.equals(Change_password2))){
  58.             Toast.makeText(this, "两次密码不一致", Toast.LENGTH_SHORT).show();
  59.             return;
  60.         }
  61.  
  62.         uu=new User();
  63.         uu.setUser_name(Change_name);
  64.         uu.setUser_name(Change_password);
  65.         new Thread(new Runnable() {
  66.             @Override
  67.             public void run() {
  68.                 User user = new User(Change_name,Change_password2);
  69.                 UserDao userDao = new UserDao();
  70.                 uu = userDao.findUser(user.getUser_name());
  71.                 Log.d("test", "uu:"+uu);
  72.                 boolean aa = userDao.login(Change_name,Change_password2);
  73.                 userDao.updateUserData(user);
  74.                 int msg = 0;
  75.                 if(aa){
  76.                     msg = 1;
  77.                 }else{
  78.                     msg = 2;
  79.                 }
  80.                 hand1.sendEmptyMessage(msg);
  81.             }
  82.  
  83.         }).start();
  84.     }
  85.     final Handler hand1 = new Handler(){
  86.         public void handleMessage(Message msg) {
  87.             if(uu==null){
  88.                 Toast.makeText(Change_Activity.this, "未找到用户，请注册", Toast.LENGTH_SHORT).show();
  89.                 return;
  90.             }else {
  91.                 if (msg.what == 1) {
  92.                     Toast.makeText(getApplicationContext(), "修改成功", Toast.LENGTH_LONG).show();
  93.                     Intent intent = new Intent(Change_Activity.this,Login_Activity.class);
  94.                     startActivity(intent);
  95.                 } else if (msg.what == 2) {
  96.                     Toast.makeText(getApplicationContext(), "原密码错误", Toast.LENGTH_LONG).show();
  97.                 }
  98.             }
  99.         }
  100.  
  101.     };
  102.  
  103.     public void back(View view) {
  104.         Intent intent = new Intent(Change_Activity.this,Login_Activity.class);
  105.         startActivity(intent);
  106.     }
  107. }

7.登录成功页面 （这里写的很简单，各位大神自行发挥） 有更好的或者写的不对的地方评论区交流，，欢迎大神来指点。。。。

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

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号