vb.net - How to check if a user disconnect from mysql? -


this table

------------------------------------------ | id | room_name | room_status | editing | ------------------------------------------ | 1  |     1     |     0       |    0    | | 2  |     2     |     1       |    0    | ------------------------------------------ 

i have form , form b

form contain many button(room), update editing column 0 1 , open form b when button(room) clicked

form b contain button, update editing column 1 0 when button clicked

*to leave form b must click button

*user not allow click button(room) if editing equal 1

if user click on button(room), , use task manager force exit room locked until manual change database

can mysql detect disconnect , change editing 0 itself? or other way solve problem?


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -