Practice English Speaking&Listening with: Login Form in java using Netbeans and Sql Server

Normal
(0)
Difficulty: 0

Hello youtube this is me indra and today i am going to show you how to create login form

in java using netbeans and linking it with sql server in the previous video also i have

done the same but it works for netbeans with a version less than 8 so in this video i will

be creating the tutorial or the project that works in every versions of netbeans so to

start our project let us start the let us create a database at first so provide the

username and password and click on connect then after right click on the database and

click on new database and provide the name of database testdb then click on ok let me

expand this and this one also testdb which is our database and then after right click

on table to create a new table which will store our username and password first of all

symbol number this will be integer without null then username this will be varchar password

this also will be varchar and let the symbol number be our primary key and also auto increment

it make it yes now this will be auto incremented and ctr + s to save name of our table let

it be test click on ok we can view over here our table test i will insert a row data username

indra password 12345 let me check whether this is save or not select on top 1000 rows

ok it is saved now so our database work is finished let me minimized this and open the

netbeans so we need to create a new project click on new project then after in java categories

choose java project application and click on next then after write the name of the project

testlogin or logintest anything you can write donot create the main class and click on finish

let me expand this right click on the source package and go to new and click on jFrameForm

so write the name of our class name loginCheck then click on finish so this is the area where

we have to design our login page or login window so we need to label one for username

and the other for password then after one text field for username another password field

for password and two buttons one for sign in and the other for reset so let me edit

the name this is username and this one is password stretch this one same for this also

ok i will change the variable name also right click on this click on change variable name

this is username click on ok this is password ok and this is sign in button signin let me

change its variable name also sign in this is reset button rename this also ok now we

have to perform the action when we click on the sign in button so double click on the

sign in button ok now we have to write our code over here what action we have to perform

when we click on sign in button we have to check whether the typed in information is

typed in information matched with the database information that is if username and password

is provided by user it should match with the data that is store in the database so i have

the code here so let me copy and paste this in our project let me show you all the code

so we have to import the connection to import the connection click on this like a bulb symbol

then add import the connection for preparestatement also do the same also for the result set add

import also for joption pane also then after ok its fine now ok driver manager we have

left it ok this is the code what we have to do is we have to include it in the try and

catch block class for name and class for name is the specify what kinds of driver we are

using that is microsoft sql server jdbc driver and this will establish the connection jdbc

sql server and local host with the database name testdb and user is sa and password is

orchid and it will establish the connection by providing the string type url ok this much

here now we have to import a jar file to establish the connection between netbeans and sql server

for that right click on the for that you have to download the jar file from the internet

i will provide the link in the description box so here right click on the library folder

then after click on add jar file folder then i have store it in d drive sql jdbc 6.0 click

on sql jdbc 4.jar and click on open let me expand this it arrives over here now this

is our coding for the sign in button ok let me tell you one thing that you may get error

when you provide this information what error you may get is there may not be the tcp connection

tcp connection may be disabled in the computer for that what you have to do is go to programs

then after sql server configuration manager sql server configuration manager click on

yes then this tcp/ip status is disabled you have to enable this enable this one click

on ok you have to start the sql server management studio restart the sql server management studio

then after again right click on it and go to properties the go to ip address and go

down and in ip all the tcp port is empty you have to write 1433 because we have used 1433

port in the code then click on apply and click on ok and again click on ok let me close this

here we have used port 1433 so i have place the same port number over there then after

let me run this program once let me provide some data value over there it may take some

time for the first time ok it show me the error tcp connection to the local host ok

i haven't restarted the sql server management studio so i shows this error let me restart

this right click on the server then click on restart then click on yes it will restart

the sql server then after click on yes ok let me run the program once let me close this

and run it again now this is correct it says username and password not correct because

i have provided garbage value let me provide correct value indra 12345 then click on sign

in it says username and password match ok now this works for us let me close this and

i will show you i will show you how to code for the reset button also double click on

the reset then after you have to code over here for this what you have to write is username

username.setText this will be empty similarly for password also password .setText ok this

will reset the value let me show you if i type some information and when i press reset

button that will go out then after when user provide information is correct you have to

go to the next window for that what you have to do is create a new jframe form then click

on right click on source package and click on jframe form and type in form me success

if valid username and password is provided it will go to the success class jframe form

then click on finish ok i will take this when the username and password is correct i will

take it to the success.java class for that what i have to do is over here i have to write

the code it will display the message and when i press the ok button it will display the

success window for that success success field = new success then after field . set visible

this will be true then i have to close the original window login window for that setvisible

fale spelling wrong here succes make it the same or you can change over here also that

will not create any problem ok let me run this once indra 12345 ok username and password

match click on ok so thanks for watching please hit like button and subscribe my channel thank

you

The Description of Login Form in java using Netbeans and Sql Server