How to create access database for bills?

Asked By Martha Nelson 20 points N/A Posted on - 11/27/2012

Hi to everyone,

How to create access database for bills?

I am still in the planning process and was not able to figure out the proper way of connecting Java applications to ms access database.

Do you have some tips regarding this matter?

Your suggestion is very much welcome.

• Status: Open
• Question Views: 1203
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Eastern Carl 5 points N/A #172663

How to create access database for bills?

Dear user,

To connect Java applications to ms access database, what you need to do is to go to Control Panel and then click administrative tools, now select your driver and database.

You can use database drivers like JDBC, ODBC, etc. To connect ms access with Java, write this code in your program:

Connection con=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:DSN name");
Statement stmt=con.createStatment();
ResultSet rs=stmt.executeQuery("select * from tablename");
while(rs.next())
{
System.out.println(rs.getSting("username"); //here username is the field name
}

Hope this will help you.

Thank you.

About Eastern Carl

Questions
5

Answers
103

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 11/27/2012
• Question Category: MS Access