Login Form in java using Netbeans and Sql Server

[@indrasubedi]

Hello My Brothers and Sisters. My humble request to you, *Please* *Don't* *Forget* *To* *Subscribe* If you have any problem, Comment down. I will provide you solution as soon as possible.

[@amandapanda3750]

Didn't do the exact same thing you did but I followed the basis of the video and it helped a lot!! You're a Life Saver! Thanks for the great content

[@RiyaRaniEARCS]

Thanku so much ur video helped me alot i am trying many times to install but today ur video helped me

[@gulan2008]

Dear Indra, Thank you very much. I solved my problems from your video instructions. Regards, Hamidi

[@tianfattloke9066]

Hi Indra. I am using Windows Authentication and put the JAR files into the libraries already, also putting the sqljdbc_auth.dll file into my System32 as i read the comments. But i still couldn't execute my program, with the error shown below. Error Pop-up Message: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionID:.......... Error shown in netbeans: Mar 25, 2018 11:12:48 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path May i know how can i solve this?

[@indrasubedi]

kzbin.info/www/bejne/e5ezdmBjnbydfbs Watch this video from 1:56 If you get/donot get solution reply me

[@tianfattloke9066]

I have did everything according the video u have provided. But still same error i got

[@indrasubedi]

i will search on it. and let you know if i found the solution My request if possible try using sql server authentication.

[@tianfattloke9066]

Thank you. I have also tried to establish a server authentication by following the steps below. msdn.microsoft.com/en-us/library/aa337562(v=sql.105).aspx But then when i want to login using Server authentication, i was informed that i had established the connection but there is an error occured somehow. TITLE: Connect to Server ------------------------------ Cannot connect to LAPTOP-11F0IBL5. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

[@tianfattloke9066]

Hi Indra. I have solved my problem. The link below shows the solution for Windows Authentication who might have the same problem as I do. Please refer to the first answer provided by Amine Soumiaa. stackoverflow.com/questions/11707056/no-sqljdbc-auth-in-java-library-path Hope this may help u too, Indra :D

[@unycassama9728]

thank you indra, i am using windows authentication, its giving an error. what should i do ? i have problem with: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver.class");

[@mrbotgaming6666]

really helpful sir 🙏🙏

[@indrasubedi]

Thanks for your feedback and dont forget to subscribe

[@knightrulzzz]

Dude, thanks for the help !!! Awesome and helpful Video Clip! Keep It Up bro !! ;)

[@indrasubedi]

Thanks for your feedback.

[@sukirtiarora3583]

Thank you very much for this tutorial. Being a beginner it totally helped me.

[@emerald21576]

It's helped me more!!!!👍👍👍

[@7-amrithaharidas832]

Thank u for this tutorial . It was really helpful

[@sipporatoppo1340]

Thank you for this video. It's really a very helpful.

[@indrasubedi]

Thanks for your feedback

[@computerbolter4079]

Thanks Bro!!! It worked with sqlite manager by changing forname and url.

[@aalamali6704]

Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter this problem is shown in my terminal while login. Please suggest me a valid souliton

[@TheDr.01]

Amazing video bro, helped me out very quickly

[@-indeed8285]

good video...thanks ...keep making videos like this.

[@indrasubedi]

+M A K you can find more useful videos in my channel. And dont forget to subscribe

[@gmrole1209]

thank you, this is really helpful to me it works.

[@devopstraining785]

hi indra where i can find the source code that you pasted in signin action performed.....i downloaded the zip file from your blog but cant find it..please help!!

[@KartikRathor]

Showing error in no. Of parameters of pst.setString()

[@rounakghosh7177]

What will happen if we create a main class

[@pacharapolballz4402]

From your clip I want you to teach the search. Search all data from table using "Text Field"

[@pacharapolballz4402]

Thank you.

[@indrasubedi]

Thanks. I will upload it soon

[@pacharapolballz4402]

ok i wait you upload

[@pacharapolballz4402]

I have 4 days before sending. Thank you :)

[@genesisc135]

Thanks for your video. Very helpful and simple

[@isiahcharles6804]

how do i solve the problem "com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionID:21e0f682-39b9-4bab-9f78-b5483df3fae6" my authentication is windows authentication only, do I need to change it to SQL authentication?

[@indrasubedi]

Use the below code in the connection url. change the database as per your database name. String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true";

[@nuzzy_nuz]

Thank You! It was helpful and allowed me to easily create the login

[@indrasubedi]

Thank you for your feedback

[@Necklaceish]

thank you indra subedi

[@zerodigits2413]

I am facing an error can you help me fix it? here is the error.. com.microsoft.sqlserver.jdbc.SQLServerException: this driver is not configured for integrated authentication.

[@munibmarwan]

hi ! i wanna ask you something .. what is the different between SQL server Database and derby Database .. and which one is better .. and the last thing is can i do it with derby database in netbeans instead of SQL SERVER ? .. thank you all .

[@sunnyaahil166]

i am facing "com.microsoft.sqlserver.jdbc.SQLServerException".... how we solve?

[@indrasubedi]

There are two main reason to get this error. One is you have logged in with windows authentication. If so login with sql server authentication or replace above code with String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true"; be sure to include your database name Second is you have not enabled TCP connection. check the video properly from 8:34 .

[@sunnyaahil166]

my TCP connection is enabled....but i am logged in with using windows authentication

[@indrasubedi]

Ok. then you the above code

[@sunnyaahil166]

still error

[@sunnyaahil166]

check your email... i sent you my code and error screenshot

[@SweetPrince-123]

thanks indra, however i ahve import the sql jar file but still saying ..........java-lang-classnotfoundexceptioncom-mysql-jdbc-driver when i press signin..... please what can i do next to solve it

[@indrasubedi]

+Prince please be sure that you have used sql jar file because the error says that you have used mysql jar file. Also the video uses sql server authentication. If you are using windows server authentication, Use the below code in the connection url. change the database as per your database name. String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true";

[@franciscoleonelruizgutierr8707]

Hi, i have a question, Where is the link for the jar ? i dont found in your description :(

[@franciscoleonelruizgutierr8707]

www.microsoft.com/en-us/download/details.aspx?id=11774 this is the jar link and choose with extension tar.gz

[@shazidmorshed1889]

bro..i have a question here...where did you used the password orchid in sql ??? if you could tell me then it will be very helpful :)

[@sofiyamariyanova8129]

Thank you so much! Amazing tutorial!! :)

[@danielgorry5565]

can you paste the try() code that you used in the authentication step here please

[@tomiturner5523]

Yes; please paste the codes used

[@stepankonsel5584]

hi bro, i have a problem at :com.microsoft.sqlserver.jdbc.SQLServerExeception: The method executeQuery() cannpt take arguments on a PreparedStatement or CallableStatement

[@stepankonsel5584]

do u know why? I have exactly the same code like u......

[@indrasubedi]

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;user=sa;password=orchid"; Connection con = DriverManager.getConnection(url); String sql = "Select * from test where username=? and password = ?"; PreparedStatement pst = con.prepareStatement(sql); pst.setString(1, username.getText()); pst.setString(2, password.getText()); ResultSet rs = pst.executeQuery(); if(rs.next()){ JOptionPane.showMessageDialog(null, "Username and Password Matched"); Check whether your code matches this code except database name, table name, username and password

[@karim-10]

I wanna Link To Make Form Insert Update delate System to Java and SQL server Plz Tel me if you Can Bro Thnx

[@indrasubedi]

Please watch my video playlist. You could find all the related videos there

[@prasantabis]

Where I get import.java.sql.connection, I am not getting that thing.

[@ahmadmaulana235]

Thank you very much for this tutorial

[@racionator2668]

Keeping passwords as varchar is not a great idea, but for demo purpose its ok !!!

[@princephilipmabesa213]

im new to java, im having an error in Class.forName, i just actually copied all the code inside Class.forName (" "), can u help me?

[@indrasubedi]

Please send me the code that you have done in [e-mail]

[@softus8453]

hey dear i get this error and i dont why ? i just make sql authentication and give my db my pass but after i put it i received this error:com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'user'.

[@softus8453]

so how i can fix it ,i used netbeans 8.2 and sqlserver 2016

[@gergoo007_]

Keep it up! This is very helpful!

[@indrasubedi]

Thank you

[@globalnavigator]

How to connect the Java form with Oracle Database for instance 11g?

[@indrasubedi]

You need a JDBC Driver to be imported in the library of your project. This is the link for download. www.oracle.com/technetwork/database/application-development/index-099369.html Also adjust the following code as per your project. try { String dbURL = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=whatEverYourHostNameIs)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=yourServiceName)))"; String strUserID = "yourUserId"; String strPassword = "yourPassword"; Connection myConnection=DriverManager.getConnection(dbURL,strUserID,strPassword); Statement sqlStatement = myConnection.createStatement(); String readRecordSQL = "select * from sa_work_order where WORK_ORDER_NO = '1503090' "; ResultSet myResultSet = sqlStatement.executeQuery(readRecordSQL); while (myResultSet.next()) { System.out.println("Record values: " + myResultSet.getString("WORK_ORDER_NO")); } myResultSet.close(); myConnection.close(); } catch (Exception e) { System.out.println(e); }

[@AzizjanAyupov_leo]

Thank you very much! But I wanna give you advice: speak more clearly or at last slowly :)

[@indrasubedi]

+Azizjan Ayupov Thank you I appreciate your feedback. Will make changes in the upcomming videos

[@XxGummib3arxX]

When I tried to use SQLServer Authentication it did not work, but When I used windows authentication it works, is there a difference?.

[@indrasubedi]

Definitely there is a difference in security. If you are using your personal computer, it doesn't matter in using windows authentication.But in case you want to authenticate the users against set of users available in your application database, then in that case you will want to go for SQL Authentication.

[@XxGummib3arxX]

Also for string url, what do I type im pretty sure its not the same as yours. and can i get a copy and paste for the code as well in the beginning.

[@indrasubedi]

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;user=sa;password=orchid"; Connection con = DriverManager.getConnection(url); //This is for sql server authentication, for windows server you have to modify

[@anushamathew1916]

Could not find or load main class what it mean sir ? What are we supposed to do

[@indrasubedi]

While creating project uncheck the create main class selection

[@nancyagrawal5819]

Hello Sir when I downloaded the sql connector, it is in .txt format. And when I try to add it in library it is not showing in the list. What should I do?

[@indrasubedi]

+Nancy Agrawal There are different format to download. Choose zip or rar file and download

[@firdausazad9759]

where did user=sa and password=orchid come?

[@jordansantos3993]

can you reply me the code you use in button? thanks :) . its hard for me to read and type it with my poor eyevisbility :(

[@ravikiran3763]

bro i want some code for "current login details to show next page without using database" please rply bro as soon as possible

[@LalGebi]

Great.. Please make more videos ... GOD bless you.. I have little doubt .. if you can answer.. we needed to authenticate users credential against the database credential and not the separate database where credentials are merely data of table...How one can create code for that..? pl. anybody out there to comment

[@elmakaouinassima6910]

when i used easyphp , i could'nt connect database

[@loginid7108]

Do you have the same Program / Login Page GUI with MySQL database. ?????

[@indrasubedi]

+Dev S yes find it on my video list

[@jacquesngouabe7746]

hello Sir i saw your tuto and it is very well made but i'm one thin that i don't get i'm working with NetBeans Build-in DataBase so how can i get the Class.ForName(" ") ? help me please

[@minbogati3342]

Good job keep it up...

[@gnaneditz]

How did you gave password as orchid

[@indrasubedi]

its an authentication password for sql server management studio

[@sumanmandal3569]

I have my sql server management with windows authentication.so what to give as user and password? where you have used user as "sa" and password as "orchid".

[@NadaALbahri95]

SUMAN MANDAL I have the same question

[@wasimabbaci6567]

@@sumanmandal3569 SELECT CURRENT_USER; to find user

[@erosexclu4578]

can you attach the codes you used? thanks

[@prasantabis]

Where I will import.com.sql.connection

[@RaghunathTambde]

Instead of setting the 1st form as false for visibility shouldn't we close it 🤔

[@indrasubedi]

You can.

[@indrasubedi]

You can.

[@codingwithjava7297]

Bhai drag and drop mt use kia kro please 🙏🙏 Jb kuchh sikhana h to step by step sikhe

[@benedictfaustino5705]

it shows java-lang-classnotfoundexceptioncom-mysql-jdbc-driver when i press signin

[@indrasubedi]

+Benedict Faustino Please import sql jar file to solve this problem. You can download it from: www.microsoft.com/en-us/download/details.aspx?id=11774 If you still get the error, email me at [e-mail]

[@benedictfaustino5705]

how to import

[@indrasubedi]

Watch the video from 7:28

[@WithPray]

Not working for me. Did everything like you.

[@Rohan-dz4cd]

can u provide source codes along with the videos....it would be really helpful.

[@dylandtoledano4261]

I had an error, is this "Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Error de inicio de sesión del usuario 'sa'. ClientConnectionId:205dc5b0-4c8f-4d73-b956-867e2db10694" Do you have the solution?

[@indrasubedi]

+dyland Toledano which authentication havd you used? sql server authentication or windows server?

[@dylandtoledano4261]

I use the Windows autentication

[@indrasubedi]

Use the below code in the connection url. change the database as per your database name. String url="jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true";

[@surajnagpure4445]

PLEASE GIVE ME SOURCE CODE OF THIS PROGRAM

[@almasbegum3988]

Can u send the code

[@DavidArangosoychon]

seria de grandisima ayuda que tambien podamos copiar ese codigo el del logeo amigo

[@gowthamprasath361]

it doesn't checks whether the password in caps or not

[@indrasubedi]

+Anonymous For case sensitive password, you have to add alittle code

[@healthsecret9416]

where is code

[@computerbolter4079]

Bhai aapka microsoft sql server ka download link milega plz.

[@indrasubedi]

You Can watch my video for the step by step download and installation at here: kzbin.info/www/bejne/fn-weIiuq7Jnfs0 Downlaod link is : www.microsoft.com/en-us/download/details.aspx?id=29062

[@waqastufail6105]

JAR file link please?

[@indrasubedi]

Find it on the description of this video

[@riyakhan6491]

Please give the source code

[@indrasubedi]

Please find it on javaguiapp.blogspot.com

[@polojoy6824]

ok thank q so much

[@InduwaraJ]

great

[@indrasubedi]

Thanks. Please subscribe for more videos.

[@krishnachaitanya2522]

how did u given the login name as "sa" and password:*********.

[@indrasubedi]

+krishna chaitanya you can create multiple users in sql server.if you cofused you can find video to create user in sql

[@krishnachaitanya2522]

how in any of the video they are not showing how to create that login and password

[@indrasubedi]

+krishna chaitanya search how to create user in sql server management studio

[@krishnachaitanya2522]

how to did u create the server name as HOME\SQLEXPRESS and login and password

[@krishnachaitanya2522]

ya ok i have got it thank u

[@belkheirfatiha3226]

thank you so mutch

[@duaabatool3634]

Thankyou so much :) bless you :)

[@duvancaballeroa3297]

PORQUE HABLAS EN ESE INGLES MAL HABLADO SI LA DESCRIPCION Y TITULO DEL VIDEO ES EN ESPAÑOL XD XD

[@indrasubedi]

como se llama el titulo en español enviame

[@duvancaballeroa3297]

@@indrasubedi Formulario de inicio de sesión en Java usando Netbeans y Sql Server ??? necesito tu video en español :(

[@zimmeruda]

@@duvancaballeroa3297 Habla asi porque es el acento que tienen en la India, no es que hable mal

[@bycecoconut1188]

I need a search code. help me ;'(

[@indrasubedi]

I will upload it at night. If i provide you the code, you wont understand. So please be updated with my project. I will add in this project.

[@bycecoconut1188]

Thank you Indra :)

[@abdirashiddahirahmed484]

Java Application with jasper report

[@sayuogiwara632]

Thank you:3