applet connected to table in MS Access database
i have connected my java code with the MS access database and this is my code, can anyone tell me how to show the table in an applet...pls
import java.sql.*;
public class TestDBDriver {
static Connection con;
static Statement stmt;
static ResultSet rs;
public static void main(String[] args) {
//step 1: load driver
loadDriver();
//step 3: establish connection
makeConnection();
//create a table
createTable();
//insert data
insertData();
//use precompiled statement to update data
usePreparedStatement();
//retrieve data
retrieveData();
//close all resources
closeAll();
}
// load a driver
static void loadDriver() {
try {
//step 2: Define connection URL
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
}
// make a connection step 3: establish connection
static void makeConnection() {
//for how to set up data source name see below.
String dsn = "judydriver";
String url =
"jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=faltu.mdb";
// String url = "jdbc:odbc:" + dsn;
try {
con = DriverManager.getConnection(url);
}catch(SQLException ex) {
System.err.println("database connection: " + ex.getMessage());
}
}
//create a table
static void createTable() {
String createString = "create table COFFEES " +
"(COF_NAME VARCHAR(32), " +
"SUP_ID INTEGER, " +
"PRICE FLOAT, " +
"SALES INTEGER, " +
"TOTAL INTEGER)";
try {
//step 4: create a statement
stmt = con.createStatement();
//step 5: execute a query or update.
stmt.execute("drop table COFFEES");//if exists, drop it, get new one
stmt.executeUpdate(createString);
}catch(SQLException ex) {
System.err.println("CreateTable: " + ex.getMessage());
}
}
//insert data to table COFFEES
static void insertData() {
try {
stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('Colombian', 101, 7.99, 0, 0)");
stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('French_Roast', 49, 8.99, 0, 0)");
stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('Espresso', 35, 5.99, 0, 0)");
stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('Colombian_Decaf', 101, 4.99, 0, 0)");
stmt.executeUpdate("INSERT INTO COFFEES " + "VALUES ('French_Roast_Decaf', 49,6.99, 0, 0)");
}catch(SQLException ex) {
System.err.println("InsertData: " + ex.getMessage());
}
}
//use PreparedStatement to precompile sql statement
static void usePreparedStatement() {
try {
PreparedStatement updateSales;
String updateString = "update COFFEES " +
"set SALES = ? where COF_NAME like ?";
updateSales = con.prepareStatement(updateString);
int [] salesForWeek = {175, 150, 60, 155, 90};
String [] coffees = {"Colombian", "French_Roast", "Espresso",
"Colombian_Decaf", "French_Roast_Decaf"};
int len = coffees.length;
for(int i = 0; i < len; i++) {
updateSales.setInt(1, salesForWeek[i]);
updateSales.setString(2, coffees[i]);
updateSales.executeUpdate();
}
}catch(SQLException ex) {
System.err.println("UsePreparedStatement: " + ex.getMessage());
}
}
//retrieve data from table COFFEES
static void retrieveData() {
try {
String gdta="SELECT COF_NAME, PRICE FROM COFFEES WHERE PRICE < 9.00";
//step 6: process the results.
rs = stmt.executeQuery(gdta);
while (rs.next()) {
String s = rs.getString("COF_NAME");
float n = rs.getFloat("PRICE");
System.out.println(s + " " + n);
}
}catch(SQLException ex) {
System.err.println("RetrieveData: " + ex.getMessage());
}
}
//close statement and connection
//step 7: close connection, etc.
static void closeAll() {
try {
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("closeAll: " + ex.getMessage());
}
}
}
Thanks;
View Answers
Related Tutorials/Questions & Answers:
applet connected to table in MS Access database applet connected to
table in
MS Access database i have
connected my java code with the
MS access database and this is my code, can anyone tell me how to show the
table in an
applet...pls
import java.sql.
Applet database access - AppletApplet database access HI...
I'm having an
applet where we should display the
database values in the
applet...
It works fine in the local system...
but when its in the server, we r getting null values in the local system..
I
Advertisements
how to access database in applethow to
access database in applet HI...
I'm having an
applet where we should display the
database values in the
applet...
It works fine in the local system(same network)...
but when its in the server, we r getting null values
how to access the MS ACCESS database with java how to
access the
MS ACCESS database with java how to
access the
MS ACCESS database with java how can we insert,delete,update,search records of
ms access with java
Java
MS Access database connectivity
Follow
how to connect to MS access database in JSP?how to connect to
MS access database in JSP? how to connect to
MS access database in JSP? Any seetings/drivers need to be set or installed before it? Please tell what needs to be done after creating a
table with an example
Updating Ms Access Database using jsp - JSP-ServletUpdating
Ms Access Database using jsp Hi
I am new to jsp and I am trying to update a record in an
access database. I only want to update part... a
table product(prod_id,prod_name,quantity,price) and try the following code
ms accessms access how to delete the autonumber from
ms access using java delete code
Ms Access Ms Access How to get query for Primary key from MsAccess?
SELECT column_name
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
table_name..._USAGE
WHERE
table_name = 'data';
In the above query, data is our
table name
MS-AccessMS-Access I am trying to upload a image to
ms-acess using jsp,and my...: [Microsoft][ODBC Microsoft
Access Driver]COUNT field incorrect ".I think i set wrong datatype for
table column in which my image going to be saved.I set
MS accessMS access how do i
access my
Ms-
Access file placed in the same jar file where my application code/class file r present??? Want to
access it via Code. Can anyone help me ? Please give reply urgent...
give me reply
Jdbc MS-Access questionJdbc
MS-
Access question How to delete records from the three
table in
MS-
Access? They are in relationship with each other regarding to data field
Jdbc MS-Access questionJdbc
MS-
Access question How to delete records from the three
table in
MS-
Access? They are in relationship with each other regarding to data field
MS ACCESSMS ACCESS i have done :
Insert form data into
MS database..., *.accdb)};DBQ=C:\\myca\\demo\\authors.accdb");
// Creating a
database table... data displayed in
table in my
database (authors.accdb)
when i run my
MS ACCESSMS ACCESS i have done :
Insert form data into
MS database..., *.accdb)};DBQ=C:\\myca\\demo\\authors.accdb");
// Creating a
database table... data displayed in
table in my
database (authors.accdb)
when i run my
MS ACCESSMS ACCESS i have done :
Insert form data into
MS database
Follow...)};DBQ=C:\\myca\\demo\\authors.accdb");
// Creating a
database table... data displayed in
table in my
database (authors.accdb)
when i run my
Extracting table from Access Database to ServletExtracting
table from
Access Database to Servlet Sir,
I have a
table with 4 field deptid, headid, normalexpend and projectexpend. Now I have to display a consolidated data where sum of normal_expend under particular head
ms access and password" from my
ms access............and detail in register(
table in my
ms... "username and password" from my
ms access............and detail in register(
table in my... has to login
. i already created
ms access page and inserted values throught
ms access and password" from my
ms access............and detail in register(
table in my
ms... "username and password" from my
ms access............and detail in register(
table in my... has to login
. i already created
ms access page and inserted values throught
ms access and password" from my
ms access............and detail in register(
table in my
ms... "username and password" from my
ms access............and detail in register(
table in my... has to login
. i already created
ms access page and inserted values throught
ms access and password" from my
ms access............and detail in register(
table in my
ms... "username and password" from my
ms access............and detail in register(
table in my... has to login
. i already created
ms access page and inserted values throught
database is connected but not insert the datadatabase is
connected but not insert the data hi,
i am getting
connected to database.Retrive the data also but cannot insert the data into
database...("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft
Access Driver
MS Access` - IDE QuestionsMS Access` hello sir,
how to configure
MS Access database in Net Beans5.5...
and i have a doubt, where should we run the below code...either in IDE or in any editor like EDITPLUS.
waitin for your reply....
thank you
J2ME connectivity to ms accessJ2ME connectivity to
ms access How to establish client server connectivity to
access ms access database on the server side? I have made the odbc connection. Plz help me in the coding part.. Dont know how to start
MS Access` - JDBC to insert image into
MS Access Database. Now the task is how to retrieve the image from
database. And i am developing a JFrame to retrieve tha fields from
database...
MS Access` Hello Sir,
Thank you very much for your valuable
MS Access - WebSevices" which have
access database and for images we have created a field in the
table...
MS Access hello sir,
i am trying to write a code which should take images from a particular folder and data from MSAccess..please help me..thank
How to Access MS Access in jar.How to
Access MS Access in jar. how do i
access my
Ms-
Access file... to
access it via Code or is their any alter-native?? Do i need any Driver to do this ... i m able to
access a
Ms-
access via JDBC but cant find the file wen
excel to ms accessexcel to
ms access hello sir i am developing a application which requires extracting data from excel sheet and place in the
ms access database using java programming
for example: in excel sheet i have 2 columns and more than
MS Access - JSP-Servlet
stepts
1.to configure the
ms access database to your system
control panel...
MS Access hello sir,
i want to use MS.Access as my
database..so my problem is how to connect
MS Acces
database with servlets ...
thank you
AJAX- Database not connected - AjaxAJAX-
Database not connected Respected Sir/Madam,
I am Ragavendran.R.. I am working with AJAX and
Database.. Ajax code works fine but the
database values are not retrieved if queried.. Instead, I could receive
MS Access - JDBC information about
MS access database...but still i am having doubt in that topic.
My problem is : Is there any jar to connect
MS Access and java ...
because... to be remember
1.to configure the
ms access database to your system
control
Migrating from mysql to MS AccessMigrating from mysql to
MS Access Hi
I am hoping for some help
I need to write a conversion program (SQL statements) to import existing data in a MYSQL
database to a
MS Access database.
any suggestions would be appreciated
accessing ms access through jspaccessing
ms access through jsp i have 3 tables in my
database employee,project,task
if i put employee id the search field .i should get details from other
table
what all queries should i use in servlet file and i am using