android登陆注册mysql

// 假设已经获取到了用户名和密码的输入框
String username = editTextUsername.getText().toString();
String password = editTextPassword.getText().toString();

// 创建 JDBC 连接
Connection conn = DriverManager.getConnection("jdbc:mysql://your_database_host:3306/your_database_name", "your_username", "your_password");

// 创建 SQL 查询语句
String sql = "SELECT * FROM users WHERE username = ? AND password = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);

// 执行查询
ResultSet rs = pstmt.executeQuery();

if (rs.next()) {
    // 登录成功
} else {
    // 登录失败
}

// 关闭连接
rs.close();
pstmt.close();
conn.close();

// 假设已经获取到了用户名、密码和邮箱的输入框
String username = editTextUsername.getText().toString();
String password = editTextPassword.getText().toString();
String email = editTextEmail.getText().toString();

// 创建 JDBC 连接
Connection conn = DriverManager.getConnection("jdbc:mysql://your_database_host:3306/your_database_name", "your_username", "your_password");

// 创建 SQL 插入语句
String sql = "INSERT INTO users (username, password, email) VALUES (?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.setString(3, email);

// 执行插入
int rowsAffected = pstmt.executeUpdate();

if (rowsAffected > 0) {
    // 注册成功
} else {
    // 注册失败
}

// 关闭连接
pstmt.close();
conn.close();