赞
踩
(1)通过搜索打开环境变量。
(2).点击环境变量。
(3).找到系统变量点击新建。
(4).点击新建之后输入如下内容,切记变量值是你的mysql安装路径。
(5).找到path路径点击进入。
(6).新建一个关于mysql的环境变量,配置完后全部确定。
(7).进行验证mysql数据库是否安装成功。按住电脑win+R输入cmd命令进入终端
输入 mysql -uroot -p 命令,然后需要让你输入你在安装mysql是设置的密码,点击回车,
如果显示如下图这样,说明数据库安装完成,配置成功。
JDBCUtil类:
( private static final String URL = "jdbc:mysql://XXX.XXX.XXX.XXX:3306/dictionary?useUnicode=true&characterEncoding=utf-8&useSSL=false";)
此语句中的XXX.XXX.XXX.XXX代表电脑本机的ip地址,3306为端口号(一般都是这个),dictionary为mysql数据库库里面新建的一个名叫dictionary的数据库。
(private static final String USER = "XXX";)此语句中的XXX代表使用数据库的用户名。
(private static final String PWD = "XXXX";)此语句中的XXXX代表用户连接数据库的密码。
- import android.util.Log;
- import java.sql.Connection;
- import java.sql.DriverManager;
-
-
- public class JDBCUtil {
- private static final String CLS = "com.mysql.jdbc.Driver";
- private static final String URL = "jdbc:mysql://XXX.XXX.XXX.XXX:3306/dictionary?useUnicode=true&characterEncoding=utf-8&useSSL=false";
- private static final String USER = "XXX";
- private static final String PWD = "XXXX";
- private static Connection connection;
-
- //数据库连接
- public static Connection getConn(){
- try{
- Class.forName(CLS);// 动态加载类
- // 尝试建立到给定数据库URL的连接
- connection = DriverManager.getConnection(URL, USER, PWD);
- Log.d("Dictionary","数据库连接成功!");
- }catch (Exception e){
- e.printStackTrace();
- Log.d("Dictionary","数据库连接失败!");
- }
- return connection;
- }
- }
UserDao类:
-
- import android.util.Log;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
-
- public class UserDao {
- private Connection connection = null;
- private PreparedStatement pStmt = null;
- private ResultSet rs = null;
-
- //插入用户信息
- public void insert(String name, String pwd, String phone, String status) {
- try {
- // 获取数据库连接
- connection = JDBCUtil.getConn();
- // 构造SQL语句
- String sql = "insert into user (name, pwd, phone,status) values (?, ?, ?, ?)";
- pStmt = connection.prepareStatement(sql);
- pStmt.setString(1, name);
- pStmt.setString(2, pwd);
- pStmt.setString(3, phone);
- pStmt.setString(4, status);
- // 执行SQL语句
- pStmt.executeUpdate();
- Log.d("Dictionary", "数据插入成功!");
- } catch (SQLException e) {
- e.printStackTrace(); // 打印异常信息
- Log.d("Dictionary", "数据插入失败!");
- } finally {
- try {
- connection.close();
- Log.d("Dictionary", "关闭数据库成功!");
- } catch (SQLException e) {
- e.printStackTrace();
- Log.d("Dictionary", "关闭数据库失败!");
- }
- }
- }
-
- //登录验证密码以及身份(Verify 验证)
- public boolean loginVerify(String name, String passWord,String status) {
- try {
- // 获取数据库连接
- connection = JDBCUtil.getConn();
- // 查询表中的密码
- String sql = "select pwd,status from user where name = ?";
- pStmt = connection.prepareStatement(sql);
- pStmt.setString(1, name);
- rs = pStmt.executeQuery();
- if (rs.next()) {
- // 比较查出的密码和传入的密码是否相同
- String dbPwd = rs.getString("pwd");
- String dbStatus =rs.getString("status");
-
- Log.d("Dictionary", dbPwd);
- Log.d("Dictionary", dbStatus);
- Log.d("Dictionary", passWord);
- Log.d("Dictionary", status);
- return (dbPwd.equals(passWord))&&(dbStatus.equals(status));
- } else {
- return false; // 没有找到对应的名字和身份,返回false表示登录失败
- }
- } catch (SQLException e) {
- e.printStackTrace(); // 打印异常信息
- Log.d("Dictionary", "异常!!!!");
- return false; // 发生异常,返回false表示登录失败
- } finally {
- try {
- connection.close();
- Log.d("Dictionary", "关闭数据库成功!");
- } catch (SQLException e) {
- e.printStackTrace();
- Log.d("Dictionary", "关闭数据库失败!");
- }
- }
- }
- }
MainActivity类:
-
- import androidx.appcompat.app.AppCompatActivity;
- import android.content.Intent;
- import android.os.Bundle;
- import android.view.View;
- import android.widget.Button;
- import android.widget.EditText;
- import android.widget.RadioButton;
- import android.widget.RadioGroup;
- import android.widget.Toast;
-
- import java.sql.SQLException;
-
- public class MainActivity extends AppCompatActivity {
-
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
-
- EditText userName = findViewById(R.id.userName);
- EditText passWord = findViewById(R.id.passWord);
- EditText phone = findViewById(R.id.phone);
-
-
- //按钮监听
- Button buttonRegister = this.findViewById(R.id.buttonRegister);
- buttonRegister.setOnClickListener(new View.OnClickListener(){
- @Override
- public void onClick(View view) {
- String name =ToolUtil.editTextToString(userName);
- String pwd =ToolUtil.editTextToString(passWord);
- String tel =ToolUtil.editTextToString(phone);
- String status = JudgeStatus();
- Insert(name,pwd, tel,status);
- Toast.makeText(RegisterActivity.this, "注册成功", Toast.LENGTH_SHORT).show();
-
- }
- });
- }
- //获取用户输入的数据插入到mysql数据库
- public void Insert( String name,String pwd ,String phone,String status){
- UserDao userDao = new UserDao();
- Thread thread= new Thread(new Runnable() {
- @Override
- public void run() {
- userDao.insert(name, pwd, phone, status);
- }
- });
- thread.start();
- }
- //判断用户选择的身份
- public String JudgeStatus() {
- String status="";
- RadioGroup radioGroup = findViewById(R.id.radioGroup);
- for (int i = 0; i <radioGroup.getChildCount() ; i++) {
- RadioButton radioButton = (RadioButton)radioGroup.getChildAt(i);
- if (radioButton.isChecked()) {
- status = radioButton.getText().toString().trim();
- }
- }
- return status;
- }
- }
-
-
activity_main.xml
- <?xml version="1.0" encoding="utf-8"?>
- <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
- xmlns:tools="http://schemas.android.com/tools"
- android:layout_width="match_parent"
- android:layout_height="match_parent"
- tools:context=".MainActivity">
-
- <LinearLayout
- android:layout_width="match_parent"
- android:layout_height="wrap_content"
- android:layout_marginTop="80dp"
- android:orientation="vertical"
- android:padding="60dp">
-
- <TextView
- android:id="@+id/registerTitle"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:layout_gravity="center_horizontal"
- android:layout_marginBottom="50dp"
- android:text="用户注册"
- android:textColor="#4A919D"
- android:textSize="30dp"
- android:textStyle="bold" />
-
- <LinearLayout
- android:layout_width="match_parent"
- android:layout_height="wrap_content"
- android:orientation="vertical"
- android:padding="40dp">
-
- <EditText
- android:id="@+id/userName"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:ems="10"
- android:hint="用户名"
- android:inputType="textPersonName"
- android:padding="8dp"
- android:textSize="18dp" />
-
- <EditText
- android:id="@+id/passWord"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:layout_marginTop="15dp"
-
- android:ems="10"
- android:hint="密码"
- android:inputType="textPassword"
- android:padding="8dp"
- android:textSize="18dp" />
-
-
- <EditText
- android:id="@+id/phone"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:layout_marginTop="15dp"
-
- android:ems="10"
- android:hint="电话"
- android:inputType="phone"
- android:padding="8dp"
- android:textSize="18dp" />
-
- </LinearLayout>
-
- <RadioGroup
- android:id="@+id/radioGroup"
- android:layout_width="wrap_content"
- android:layout_height="match_parent"
- android:layout_gravity="center_horizontal"
- android:layout_marginTop="10dp"
- android:orientation="horizontal">
-
- <RadioButton
- android:id="@+id/radioButtonAdmin"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:layout_marginLeft="20dp"
- android:text="admin"
- android:textSize="18dp" />
-
- <RadioButton
- android:id="@+id/radioButtonUser"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:layout_marginLeft="90dp"
- android:text="user"
- android:textSize="18dp" />
- </RadioGroup>
-
- <LinearLayout
- android:layout_width="match_parent"
- android:layout_height="wrap_content"
- android:layout_marginTop="25dp"
- android:orientation="horizontal"
- android:padding="4dp">
-
-
-
- <Button
- android:id="@+id/buttonRegister"
- android:layout_width="wrap_content"
- android:layout_height="wrap_content"
- android:text="注册"
- android:textSize="20dp" />
-
- </LinearLayout>
-
-
- </LinearLayout>
-
- </RelativeLayout>
最后希望能通过这篇文章给予大家一点帮助,欢迎技术大佬能给予指正,有什么问题欢迎大家积极留言。
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。