background top icon
background center wave icon
background filled rhombus icon
background two lines icon
background stroke rhombus icon
header logo icon

Download "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15"

input logo icon
Cover of audio
Please wait. We're preparing links for easy ad-free video watching and downloading.
console placeholder icon
Previous video: Eminem - Houdini [Official Music Video]Next video: Sprinting with More and More Money
Other popular videos
|

Other popular videos

Video tags
|

Video tags

java crud update
java crud
java mysql update
java
mysql
java mysql
sistema java
sistema desktop
projeto java
crud update
javamysql,
crud,
update
Subtitles
|

Subtitles

subtitles menu arrow
  • ruRussian
Download
00:00:00
Hello everyone, I'm Professor José de
00:00:02
Assis, continuing the special
00:00:05
Java MySQL In this class we're going to
00:00:09
code the button change this button
00:00:12
here known in crud as update So
00:00:16
let's go, the first step is for us
00:00:20
to understand how this update will be done,
00:00:23
in this case I'll search for
00:00:27
the user that I want to change to a
00:00:30
field, for example here
00:00:34
search user, here I change the field, example
00:00:38
telephone, I will put
00:00:40
888888
00:00:42
88888 and when clicking on this button it
00:00:48
updates the table with the new content
00:00:52
here in the Fields of this form we can
00:00:55
say that the logical reasoning here it is
00:00:58
very similar to the add button
00:01:01
we only change here the SQL statement and
00:01:05
some details regarding the capture
00:01:08
of information let's go to the
00:01:14
source code in the last class We created the
00:01:17
add method here I go here below the
00:01:21
add method create the change method
00:01:24
always remembering that these methods
00:01:27
need to be inside the
00:01:28
main class so exactly here after the
00:01:32
add method I will create here so
00:01:35
let's
00:01:37
comment
00:01:41
by creating the
00:01:44
method to
00:01:46
change user data
00:01:53
Private
00:01:55
void
00:01:58
change let's start here with the
00:02:01
SQL statement SQL
00:02:04
string
00:02:06
equals dot e comma noo here I
00:02:11
will update the database table
00:02:14
If there are any questions,
00:02:18
watch the class again where I did
00:02:21
this directly in
00:02:23
MySQL the instruction is
00:02:25
update name of the
00:02:28
table
00:02:30
seven the fields I want to
00:02:33
change in this case the Fields Are
00:02:37
user equal Question
00:02:41
comma
00:02:43
phone equal Question comma
00:02:47
equal login Question
00:02:52
comma
00:02:54
password equal Question
00:02:58
comma equal profile
00:03:01
Question let's access
00:03:05
MySQL here I have the table description here
00:03:08
first I search for the
00:03:12
user ID I'm not going to modify this
00:03:15
ID here it will be used as reference
00:03:18
to make changes to these Fields
00:03:21
So the fields that will be changed
00:03:23
will be the user phone login password
00:03:27
and profile fields here a very
00:03:30
important detail I need to pass
00:03:34
the parameters and replace
00:03:36
these questions here in sequence so
00:03:39
this will be the first field to be
00:03:42
replaced this is the second this is the
00:03:45
third this is the fourth this is the fifth and
00:03:48
I have here the reference that I am going to
00:03:52
use which is the user ID So
00:03:55
update the user table modify this
00:03:59
scan
00:04:00
here I put
00:04:04
Where ID user equal then Interrogate the
00:04:10
field here ID user equal Question he is
00:04:14
the reference he is the sixth Field to be
00:04:18
filled in this one is a very
00:04:21
important detail that we need to pay
00:04:23
attention to the sequence here in relation to
00:04:27
passing the parameters or the reasoning
00:04:30
here it is very similar to adding
00:04:32
what changes This is the update instruction,
00:04:36
what changes here is the sequence of passing
00:04:39
these parameters here
00:04:43
Ok, continuing what we are going to do
00:04:46
now is create the
00:04:50
try here, I will take advantage of it here and handle the
00:04:53
exception if it
00:04:56
occurs, I will reuse the
00:05:00
method code previous using the same
00:05:03
message, that is, it will display the error and
00:05:06
here now I will prepare the
00:05:10
connection and also pass the
00:05:13
parameters, replacing the
00:05:16
question marks PST is the same connection
00:05:20
dot prepared Statement
00:05:25
SQL
00:05:28
semicolon PST P7 string 1 V
00:05:35
TXT use name pon get
00:05:42
text semicolon let's analyze
00:05:46
the project here this is the first field
00:05:49
to receive a parameter it
00:05:52
will take this information that is in this
00:05:55
field and update the table this
00:05:58
TXT field use the name the phone here is the second
00:06:02
TXT I use phone and so on
00:06:07
So I'll go here Copy this line to
00:06:10
save
00:06:11
time control ctrl v
00:06:15
pst7 string
00:06:18
2 TXT
00:06:21
use
00:06:23
phone PG
00:06:25
text once again here
00:06:28
the TR Field right
00:06:31
TXT use
00:06:38
login Field
00:06:42
4 use
00:06:49
password the fifth Field here we can't
00:06:54
forget that it is a combobox it has a
00:06:57
different name CBO usage profile
00:07:02
PST
00:07:05
P7
00:07:06
string 5 v
00:07:10
CBO
00:07:12
usage
00:07:14
profile dot
00:07:19
get selected item in this case
00:07:23
here
00:07:25
dot true
00:07:27
string ok
00:07:31
and here now pay close attention to the sixth
00:07:35
Field it will be here the reference the ID
00:07:39
user then the ID
00:07:41
user is the sixth parameter here that I will
00:07:45
be passing that I will be
00:07:48
replacing in this question Ok
00:07:53
so pst7 string TX use
00:07:58
ID pon get
00:08:02
perfect text what we are going to do
00:08:05
now is similar to what was done in the
00:08:08
previous class Let me go back a
00:08:10
little here in the add method here
00:08:13
in the
00:08:15
add method before I update the
00:08:18
database I did a validation here
00:08:21
to check if the mandatory fields
00:08:23
were filled in I will use this same
00:08:26
logical reasoning I cannot leave a
00:08:30
mandatory field without being filled in and
00:08:33
also here I I'm going to run the update and
00:08:36
display a
00:08:38
message saying that the data was
00:08:41
changed successfully so it's the same
00:08:44
logic as the previous class I'm going to copy
00:08:48
it all here to save
00:08:52
time contr
00:08:57
ctrl v good here so I'm just going to
00:09:01
modify the comment the low structure
00:09:04
used to confirm the
00:09:08
change of
00:09:13
user data in the table This command then
00:09:17
Execute update it is used for both
00:09:20
adding and changing it is the same
00:09:23
command and here I will put a
00:09:27
different message instead of user
00:09:30
added successfully Let's put
00:09:37
user data
00:09:41
changed with success and here it clears
00:09:46
the fields we created here then the
00:09:50
change method which is very similar to the
00:09:54
add method what I'm going to do now is
00:09:57
Add this method to the button let's go
00:10:00
in project click here with the
00:10:02
right mouse button events Action Action
00:10:07
performance and here we are going to call the
00:10:12
change method by calling the
00:10:18
change method simply here
00:10:22
change
00:10:27
semicolon I will save
00:10:30
I will
00:10:32
execute user admin password
00:10:36
admin
00:10:38
login
00:10:41
user registration I will search here for the id2 for
00:10:45
example make the query José de Assis
00:10:48
Ah, I will change José de Assis's phone number here
00:10:50
the phone
00:10:53
is now 2 2 2 2
00:10:58
2 here in this button the
00:11:02
change button it returned me an error here
00:11:05
let's analyze this error in fact an
00:11:09
exception there is no value specified
00:11:12
for parameter
00:11:13
6
00:11:15
Ok let's see where I had a ball
00:11:19
here return to
00:11:26
code 1 2 3 4 5
00:11:31
sixth Field Ah,
00:11:34
field one name Field 2 telephone Field
00:11:38
3 login Field 4 password Field number
00:11:43
5 the profile and here the sixth Field the error
00:11:47
is here so the six is ​​missing here the sixth
00:11:52
Field TXT usid PG
00:11:57
text I will save the
00:11:59
project to run here
00:12:03
again user AD me
00:12:10
password login registration users
00:12:15
I will search here user
00:12:17
2 José de Assis I want to change the
00:12:21
phone number to 2 2 2 2 2 2 2 2 I will click
00:12:27
here on this button
00:12:29
user data changed
00:12:34
successfully Ok let's check Here the database
00:12:38
data select from bank
00:12:42
here user number 2 José de Assis here,
00:12:46
phone changed
00:12:50
perfect let's do one more here in the
00:12:53
last class I had left user
00:12:55
10 I will search for this user
00:13:00
I had used him as an example before
00:13:04
validating the
00:13:06
Mandatory Fields I go here then register
00:13:08
a phone
00:13:10
9999
00:13:12
9999 login test
00:13:16
10 the password I will leave
00:13:20
blank the password is a mandatory field and
00:13:23
here I will click on this change button
00:13:27
it gives me a message fill in all the
00:13:30
mandatory fields this detail It is
00:13:33
very important let me go back a
00:13:35
little here in the
00:13:39
code, in fact, here is the same
00:13:42
validation that I had
00:13:44
done in the
00:13:47
add method, we need to think about
00:13:50
all the details, I need to do
00:13:53
the
00:13:54
validation here, even when changing, I cannot
00:13:58
leave the mandatory field without being
00:14:01
filled in, so this is working
00:14:04
perfectly if I fill it in here a
00:14:07
password 1 2 3 4 5 6 now if I click
00:14:11
here user data changed
00:14:16
successfully for today that's it

Description:

CRUD (Create Read Update e Delete) são as quatro operações básicas relacionadas ao banco de dados. Esta aula ensina a alterar o registro de um usuário do banco de dados. Você pode apoiar o canal: Inscrevendo-se✔️ Curtindo os vídeos✔️ Comentando✔️ Compartilhando o conteúdo✔️ ☕ Você também pode me pagar um café! PIX: [email protected] 😃 Muito obrigado pelo apoio. 🔗 Sites: https://html5css3.com.br/ https://joseassis.com.br/ https://roboticapratica.com.br/ 👨‍💻 Siga-me nas redes sociais: Linkedin: https://www.linkedin.com/in/professorjosedeassis/ Face: https://www.facebook.com/unsupportedbrowser Instagram: https://www.facebook.com/unsupportedbrowser Twitter: https://twitter.com/joseassis 📁 GitHub (material de apoio dos tutoriais e projetos do canal): ​https://github.com/professorjosedeassis https://github.com/roboticapratica Você faz. Você vê. Você aprende.

Preparing download options

popular icon
Popular
hd icon
HD video
audio icon
Only sound
total icon
All
* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."
** — Link intended for online playback in specialized players

Questions about downloading video

mobile menu iconHow can I download "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15" video?mobile menu icon

  • http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.

  • The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.

  • UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.

  • UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

mobile menu iconWhich format of "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15" video should I choose?mobile menu icon

  • The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

mobile menu iconWhy does my computer freeze when loading a "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15" video?mobile menu icon

  • The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

mobile menu iconHow can I download "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15" video to my phone?mobile menu icon

  • You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

mobile menu iconHow can I download an audio track (music) to MP3 "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15"?mobile menu icon

  • The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

mobile menu iconHow can I save a frame from a video "☕️ Java MySQL - Sistema Completo - CRUD - UPDATE - #15"?mobile menu icon

  • This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

mobile menu iconWhat's the price of all this stuff?mobile menu icon

  • It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.