package com.example.money import android.content.Intent import android.os.Bundle import android.util.Log import android.view.View import android.view.WindowManager import android.widget.Button import android.widget.EditText import android.widget.Toast import androidx.appcompat.app.AppCompatActivity import java.sql.Connection import java.sql.DriverManager import java.sql.SQLException class LoginActivity : AppCompatActivity() { var login2: Button? =null var zhuce: Button?=null var phone: EditText?=null var pwd: EditText?=null // var conn: Connection? = null//一个成员变量 override fun onCreate(savedInstanceState: Bundle?) { super.onCreate(savedInstanceState) setContentView(R.layout.activity_login) //设置全屏 getWindow().setFlags( WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN ); //隐藏顶部标题栏 getSupportActionBar()?.hide() //获取控件 getviews(); // login2?.setOnClickListener(this); login2?.setOnClickListener { val phone = phone?.text.toString().trim() val pwd = pwd?.text.toString() //判断用户名和密码是否正确 // if (phone.equals("18089500801") && pwd.equals("123456")) { // val intent = Intent(this, UserActivity::class.java) // startActivity(intent) // } else { // Toast.makeText(this, "用户名或密码错误", Toast.LENGTH_LONG).show() // } Thread(Runnable { val sql = "SELECT * FROM moneyusers" mysqlConnection(sql) }).start() } zhuce?.setOnClickListener{ val intent = Intent(this@LoginActivity, ZhuCeActivity::class.java) startActivity(intent) } } fun getviews(){ login2 = findViewById(R.id.login2) zhuce = findViewById(R.id.zhuce) phone = findViewById(R.id.phone) pwd = findViewById(R.id.pwd) } //连接数据库 fun mysqlConnection(sql:String) { var cn: Connection try { //加载驱动 Class.forName("com.mysql.jdbc.Driver") //建立连接 cn = DriverManager.getConnection("jdbc:mysql://192.168.43.73:3306/mydb","root","143226"); val ps = cn.createStatement() val resultSet = ps!!.executeQuery(sql) while (resultSet.next()) { Log.d("mysqlConnection: " , resultSet.getString("id") + resultSet.getString("phone") + resultSet.getString("email")+resultSet.getString("pwd")) } if (ps != null) { ps!!.close() } if (cn != null) { cn.close() } } catch (e: ClassNotFoundException) { e.printStackTrace() } catch (e: SQLException) { e.printStackTrace() } } // override fun onClick(v: View?) { // if (v!!.id == R.id.login2) { // // } // } }
正则表达式语法错误,检查是否书写不合规范