4.Library Management System - Authentication of Login Page with Database
HTML-код
- Опубликовано: 15 дек 2024
- An integrated library system (ILS), also known as a library management system (LMS), is an enterprise resource planning system for a library, used to track items owned, orders made, bills paid, and patrons who have borrowed.
For Source code & Required Files:-
Refer to my GitHub account: www.github.com...
Please Subscribe and comment Keep Watching. Thanking You
If you have any trouble or any query regarding this project please contact me.
Email - ramsundar.1238@gmail.com
Hello. During running the file it is showing a message "java.sql.sqlexception-No suitable driver is found." I downloaded the jdbc also.And after creating an account its showing an error java.lang.NullPointerException. What to do?
bro after doing the full code from your previous tutorial when i click the Create button it shows error msg like "java.lang.unsupportedOperationException:Not supported yet"??
Amazing tutorials Ram. Subscribed! Thank you so much for this great tutorial.
why error code:pst.setString(3,jPasswordField1.getText());
java.sql.SQLException.No suitable driver found for jdbc.sqlite:C\Users\hp\Documents\NetbeansProjects\LibraryManagementSystem\Library.sqlite
what should I do?
conn=javaconnect.ConnecrDb(); define this in init().
Sir I got the same error
i added 3-4 database in account and all have same security question answers that is it is giving same password for all and it is only comparing answer and giving password i want it compare password as well as username too to give password what can i do?
like that you have to add one more if-else statement do it youself its very easy.
I have a different solution:
"select * from Account where User='"+a1+"' and Answer='" + a2 + "'";
After done code when i press on login then unsupportedOperationException Not yet support are come..
Then tell me How to fix???
whenever I try to sign up there is exception, table is not found.
my code is running but why this exception is showing I don't know?
because I have created the table.
so why this exception is showing?
Might your table name and database table name not match
On clicking "Create Account" in signup form, i get "java.lang.nullpointerexception"
This exception only comes when you initialize a value null.
Bhai sql database open bhi krna pdta hai saath mai..jb database hi open nhi hoga to error aayega hi.
Null pointer exception is occurring..... What to do... I wrote code perfectly... I can't find wht the real problem is.
What is the need of closing the conn and rs in the 'try' block if the 'finally' block is executed anyway?
You can do both depends on the situation
@@TechEntertaining Thank you
java.lang.UnsupportedOperatioException: Not supported yet. What should I do?
comment the error so that i can identify.
Sir why is not working for me this? pst.setString(2,jpasswordField1.getText());
if i try running it ,it will say library management system does not have a main class set
Sir jdbc jar file download nahibho rahi hai please give another link
drive.google.com/file/d/1ErT0bE_YNM2NfVLEwXa4NPPy6oXbHloT/view?usp=drivesdk
When did u created jPasswordField before I saw you put jTextField on password index
Now my whole code began to suck now
No problem just replace it.
we are stuck at the part 3 man it gives this error : java.sql.SQLException:No suitable driver found for jdbc.sqlite:C:\Users\MyraB\Documents\NetBeansProjects\Library Management System\LibraryNew.sqlite
i already downloaded the jdbcdriver v 056 and open it on my libraries then i got this error here above.
+ralp dexter mention your email i send you the full source code so you can see where is your error ok.
spirits2898@yahoo.com thanks :D
send me the code of third part to my email i'll check the error post back to you in few hours.
What will happen if we dont write anything to form and click signup ?
Only the sec_q will go to the database?
You cant able to register
@ Tech Entertaining i am getting parameter index out of range ( 1>number of parametrers which is zero)
java.lang.RuntimeException: Uncompilable Source code - illegal start of type ..... ???????
Bro I am getting this error when i click on Retrieve.
this is caused due to inappropriate attachment of jar file go the below link and download all
Go the Link and download the Required Jar File -
clkmein.com/qBMFB6
Go the Link and download the Required icons -
clkmein.com/qBVcFb
Go the Link and download the Required Giphy Images -
clkmein.com/qBVcMR
Go the Link and download the Icon Pack -
clkmein.com/qBVve2
Library Management System Required Notes :-
clkmein.com/qBMGUJ
Tech Entertaining thank you brother... For your help. 🤝
when i enter the data and click create button i got a null pointer exception message why is that?
When you declare a reference variable (i.e. an object) you are really creating a pointer to an object. Consider the following code where you declare a variable of primitive type int:int x;
x = 10;In this example the variable x is an int and Java will initialize it to 0 for you. When you assign it to 10 in the second line your value 10 is written into the memory location pointed to by x.But, when you try to declare a reference type something different happens. Take the following code:Integer num;
num = new Integer(10);
Christeen Fernando
Yeah i too got same problem
you just do that
try{
String sql="Insert into account(Username,Name,Password,Security_Question,Answer)values(?,?,?,?,?)";
pst=conn.prepareStatement(sql);
pst.setString(1,user_txtfield.getText());
pst.setString(2,name_txtfield.getText());
pst.setString(3,password_txtfield.getText());
pst.setString(4,(String)jComboBox1.getSelectedItem());
pst.setString(5,answer_txtfield.getText());
//pst.executeQuery(sql);
int i= pst.executeUpdate();
JOptionPane.showMessageDialog(null,i+"New account created");
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
finally
{
try
{
rs.close();
ps.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, e);
}
}
I've corrected but when I try to create a new account a display message says "java. Lang. ClassNotFound:Exception :org.sqlite. JDBC"
Call conn=javaconnect.ComnecrDB();
Below init();
In every frame.
HI! why isn't there an output after clicking retrieve? What might be the problems?
solved it
happy to hear that.
when iam running my program there is an error that no suitable for jdbc sqlite and after that its shows java.nullpointException..now what can i do
Just use the java connection method in every frame
can any one send me the link of.....? " sqlite jdbc 056 " i.e the old version from the description i am unable to download. And please provide me the solution for the error " java.lang.classNotfoundException:org.sqlite.JDBC".
Download db browser
Hi i have nullpointer execption only on clicking login button. Can you please be specific how to remove that
Make sure you initialized all the values.
its showing null pointer exception. what to do now
bro just check any miss code
Why show me only incorrect username and password though my code has no error or any problem .....how can i fixed this problem. i can't login
If facing issue You can download from here www.github.com/codehax41
datatruncation error is coming at time of signup at securityQuestion question how to resolve it
Something has changed on the ServiceNow side. Usually someone made a string field longer than before. For example your ServiceNow admin made incident short_description longer (max length) from 80 to 200. So it means the new incident subjects cannot fit into your varchar(80) in the mirror database. To fix this, either manually alter the mirror table (column) or re-create the whole synchronization and perform an initial data load.
hello sir,
thanks for this project
but some error are coming like that "java.sql.SQLException:near"value":syntax error" when i am running signup after filling new account
plz help
+SHRUTI SHUKLA dear the reason you're getting this error due to either you have typed any mistakes in the sql query or any symbol please re-watch the tutorial if again showing.
java.long null point exception. i cant find error
same here bro,i think we all are getting the same error.
check for the syntax error which you have carried in the program
@@TechEntertaining i check it many times plz help me out
Hello. In video number 5 in the playlist, under forgot password when i run the program and type a name in the username text field, it doesn't show anything and i have checked the code so many times i couldn't find the error. please what do you think can be the error?
What's the error is
Tech Entertaining
Hy, the problem I am facing is that when I typed a name which I already created in the database, when I type the name and click on search it doesn’t show anything at all and the funny thing is there is no error at all. And also in video number 6, after I followed what you did for user login which will go to the next jframe form, it will then show an exception error which I really don’t know why and in the coding part there is no error at all. I think the system is not reaching the database at that point. I will really appreciate your help thank you.
Hy, i followed the videos starting from the first one, i connected the database and i am able to create new users which works well but in the video number 5, i can't search for a user when i type in a user i already created but it doesn't show me anything and i couldn't find any error and i don't know what i did wrong and also in video number 6, i followed the same thing but at the end when i run the program i can't login with a user that i already registered. I would very much like to hear from you and i will really appreciate your help.
I have the same problem
java.sql.sqlexception-No suitable driver is found....solution for this
ive even added the exact jdbc jar file
did you call the method in every frame.
Wasim Akram put the filename with .sqlite format in the path
Don't use that BS database. Use something else.
Hello bro every thing is done but when i press login button there are some exceptions like null java.lang.null.exception.....firstly this error was coming just in login form but now in every form is also coming database is locked...please tell me the solution very soon
Try to remove the null value.
hi i face ...Java.null.pointException ... this problem can u help me
This error happens when you have spelling mistakes or special symbols.
"Near "-" syntax error "..how can I solve this
This error happens when you have spelling mistakes or special symbols.
What is the working of super("forgot password"); ???????
its a header name of the frame
everytime i saw when you create the form object
you first write setVisible(false); and then you create the form object.
please explain me this.
I am waiting for your explaination
setVisible(false); this will hide the current frame.......
java.lang.NullPointerException this error is coming what to do....................
When you declare a reference variable (i.e. an object) you are really creating a pointer to an object. Consider the following code where you declare a variable of primitive type int:int x;
x = 10;In this example the variable x is an int and Java will initialize it to 0 for you. When you assign it to 10 in the second line your value 10 is written into the memory location pointed to by x.But, when you try to declare a reference type something different happens. Take the following code:Integer num;
num = new Integer(10);
try{
String sql="Insert into account(Username,Name,Password,Security_Question,Answer)values(?,?,?,?,?)";
pst=conn.prepareStatement(sql);
pst.setString(1,user_txtfield.getText());
pst.setString(2,name_txtfield.getText());
pst.setString(3,password_txtfield.getText());
pst.setString(4,(String)jComboBox1.getSelectedItem());
pst.setString(5,answer_txtfield.getText());
//pst.executeQuery(sql);
int i= pst.executeUpdate();
JOptionPane.showMessageDialog(null,i+"New account created");
rs.close();
pst.close();
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
i hv done ds..... be specific whr i hv to chng the code
you just do that
try{
String sql="Insert into account(Username,Name,Password,Security_Question,Answer)values(?,?,?,?,?)";
pst=conn.prepareStatement(sql);
pst.setString(1,user_txtfield.getText());
pst.setString(2,name_txtfield.getText());
pst.setString(3,password_txtfield.getText());
pst.setString(4,(String)jComboBox1.getSelectedItem());
pst.setString(5,answer_txtfield.getText());
//pst.executeQuery(sql);
int i= pst.executeUpdate();
JOptionPane.showMessageDialog(null,i+"New account created");
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
finally
{
try
{
rs.close();
ps.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, e);
}
}
i do have same error did you solve it
TAYYAB DOST Bro its for SignUp page but I'm getting NullPointerExceltion on the same code.
what is the difference between setText()and setString()?
i)SetText() method in Java is used to print or title something in Java
ii)It is used for create, drop, insert, update, delete etc. executes the select query. It returns an instance of ResultSet.
From where we have to right the code
not able to download jar file
sir skip the ads please
which java compiler are you using
+N.I.T its java ide Netbeans 8.1
Ive followed everything you've done but when I install the drivers you recommended they ain't doing??Please help me out
Can you just explain me!?
This code:
Con=javaconnect.connectDb()
How with the name of the class we are able to call the method?
we import the class (javaconnect) is the class name...and (connectDb) is the function
static methods are invoked with class name directly .It doesn't need an object to be invoked.
i m getting null pointer error can u help me
NullPointerException whenever I am clicking the seach..
Its a basic error if there is some syntax error
in part4 when i run program after writing complete code and click login it gives this eror
java.lang.nullpointerexception
whats this please help me with it
+Game lover please re watch the video cause this error is caused by wrong spelling of words please rewatch the video or else if error is again occurred then i will help you.
i have done it twice and this time dont even chagnged a single word but still the same
okay then send me the 4th code to my email i'll check the error
i have sent the email please check it and tell me the problem
+Game lover i think you have missed to write some code for connecting the whole project as i shown connectivity.
hey!! how you write getText function with cross line
Did you created this object in javaconnect class. Just check it out.
yes brother
Sir error aya rhi ha forget wla source code m
My application get stuck when I enter wrong user name and password in login page, Please tell me how to fix it.
use try catch
it's showing red lines here pst=conn.prepareStatement (sql);
Did you imported the header files?
Bro my problem is
When I press retrieve button in forgot page
It shows nothing
Please help
You could give more details or even send the code if you've still got the problem...
Bro send the code for this Project
See you asking for source code no problem but i say you that do it yourself cause i also passed from same stage where now you are so at that time no help in YT but i did it my self , source code is just a answer to copy paste but doing yourself is an experiment and identify what is the working of that specific single line of word....hope you understand.
Go the Link and download the Required Jar File -
clkmein.com/qBMFB6
Go the Link and download the Required icons -
clkmein.com/qBVcFb
Go the Link and download the Required Giphy Images -
clkmein.com/qBVcMR
Go the Link and download the Icon Pack -
clkmein.com/qBVve2
Library Management System Required Notes :-
clkmein.com/qBMGUJ
I cant download this link what im going supposed to do?
Go the Link and download the Required icons -
clkmein.com/qBVcFb
Go the link wait for 5 second and then click the Skip Ad button then ypu will get a link.
"NO SUITABLE DRIVER"Guys I also came across with the same error: Not suitable driver ... I killed 2 hours to find a mistake, it was a syntax error. 056 you can download here: sourceforge.net/projects/phycluster/files/Packages%20needed/sqlitejdbc-v056.jar/download
i am in 1st semester sala kuch samj nae a rha tu kia kar raha hai
toh dekh kyo rha mt dekh bhai
hi, when I am clicking the "create" button, NullPointerException is coming..please resolve my error as it is very necessary
i have an error on line
conn= javaconnect.ConnecrDb();
what should i do?? plz help
why am i getting out of memory exception?