Connecting a Table with Java and be able to add and delete users in the table
Can you assist me. How to you connect a database(ms access table ) with java. And also how you add and delete the users in the database using that program.
Who is Participating?
here is some code that will work for you:
Just change the word database to the path of your database:
(ie. C:/data/database)
change the password to your password (only nessecary if the DB is password protected;
Modify the query to reflect the query you want.
This will display you the users in the DB
try{
Class.forName("sun.jdbc.od
Connection con1 = DriverManager.getConnectio
Statement stmt = con1.createStatement(Resul
String query ="select f_name,l_name from users";
ResultSet rs1 = stmt.executeQuery(query); //execute query
while(rs1.next()){
System.out.println( rs1.getString("f_name")+" "rs1.getString("l_name")+"
}
To insert records use this query :
String deletequery="insert into users (f_name, l_name) values ("'+firstname+"','"+lastna
then call:
stmt.executeQuery(query); //execute query
where firstname and lastname are strings containing the new names to insert.
to delete from database use this query:
String query ="delete from users where l_name='"+lastname+"' and f_name ='"+firstname;
then call:
stmt.executeQuery(query); //execute query
where firstname and lastname are strings containing the names to delete.
obviously you will need a application to insert this code into. that will dictate how users actually interact.
A suggestion would by an application that displays all records in database in a combobox, then have to 2 textboxes, and 2 buttons. one button would delete the record associated with the name currently selected in the combo box. the other button would insert the text in the text areas to the database.
just a suggestion though... if you need more help just ask
hope it helps
Just change the word database to the path of your database:
(ie. C:/data/database)
change the password to your password (only nessecary if the DB is password protected;
Modify the query to reflect the query you want.
This will display you the users in the DB
try{
Class.forName("sun.jdbc.od
Connection con1 = DriverManager.getConnectio
Statement stmt = con1.createStatement(Resul
String query ="select f_name,l_name from users";
ResultSet rs1 = stmt.executeQuery(query); //execute query
while(rs1.next()){
System.out.println( rs1.getString("f_name")+" "rs1.getString("l_name")+"
}
To insert records use this query :
String deletequery="insert into users (f_name, l_name) values ("'+firstname+"','"+lastna
then call:
stmt.executeQuery(query); //execute query
where firstname and lastname are strings containing the new names to insert.
to delete from database use this query:
String query ="delete from users where l_name='"+lastname+"' and f_name ='"+firstname;
then call:
stmt.executeQuery(query); //execute query
where firstname and lastname are strings containing the names to delete.
obviously you will need a application to insert this code into. that will dictate how users actually interact.
A suggestion would by an application that displays all records in database in a combobox, then have to 2 textboxes, and 2 buttons. one button would delete the record associated with the name currently selected in the combo box. the other button would insert the text in the text areas to the database.
just a suggestion though... if you need more help just ask
hope it helps
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
To add and delete data, you will need to embed SQL calls in a PreparedStatement.
This URL should get you started.
http://java.sun.com/developer/technicalArticles/Interviews/StartJDBC/
The Sun developer site also has a lot of tutorials, technical articles and code snippets available. There are also a lot of good books available which cover this topic. Look for O"Reilly Java Programming Examples In A Nutshell, or the Core Java Programming series. Either volume 1 or volume 2 has a chapter on JDBC/ODBC.
Finally, search the experts-exchange database for a reference to "Northwind". This is the Access sample database, and you are likely to find a code example for getting code out of Northwind in a previous answer that you can easily modify for your own situation.
Good luck,
Dorothy