Please visit our sponsor
<![CDATA[UNKNOWN
//**************************************
// Name: Java Address Book Database
// Description:Simple Address Book database. Some functionality like database grid view, submit new entries, delete entries, clear fields, find entries. Used MSAccess as data "holder". Good for beginners who want to get familiar with SQL commands and jdbc/odbc. Feedback would be cool. Used JBuilder3/jdk 1.2 to develop.
// By: Steven Jacobs
//
//
// Inputs:None
//
// Returns:None
//
//Assumes:None
//
//Side Effects:None
//This code is copyrighted and has limited warranties.
//Please see http://www.Planet-Source-Code.com/xq/ASP/txtCodeId.1795/lngWId.2/qx/vb/scripts/ShowCode.htm
//for details.
//**************************************
/////////////////////////////////////////////////////////////////////////////
//Name of File: AddressBook.java
//Purpose:Input data/Find data from an Access database
//Author:Steven Jacobs
//Date: 03/29/2000
//Comments: Feel free to change/improve/etc. Any questions or concerns,
//email me at sjcplus@aol.com
/////////////////////////////////////////////////////////////////////////////
package untitled20;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import com.borland.jbcl.layout.*;
import com.borland.jbcl.control.*;
import java.sql.*;
import javax.swing.*;
import java.util.*;
public class AddressBook extends Applet
{
FlowLayout flow = new FlowLayout(FlowLayout.LEFT);
boolean isStandalone = false;
Label nameLabel = new Label("Name: ");
Label addressLabel = new Label("Address: ");
Label emailLabel = new Label("Email: ");
Label isConnectLabel = new Label("Connected??");
TextField nameField = new TextField(40);
TextField addressField = new TextField(40);
TextField emailField = new TextField(40);
TextField connectField = new TextField(50);
Button submitButton = new Button("Submit");
Button findButton = new Button("Find");
Button clearButton = new Button("Clear Fields");
Button gridButton = new Button("Show Database Grid");
Button deleteButton = new Button("Delete Record");
Button exitButton = new Button("Exit");
private String url;
private Connection connect;
//Construct the applet
public AddressBook()
{
}
//Initialize the applet
public void init()
{
try
{
jbInit();
}
catch(Exception e)
{
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception
{
this.setLayout(flow);
add(nameLabel);
add(nameField);
add(addressLabel);
add(addressField);
add(emailLabel);
add(emailField);
add(isConnectLabel);
add(connectField);
add(submitButton);
add(findButton);
findButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
Statement state = connect.createStatement();
if (nameField.getText().equals(""))
{
isConnectLabel.setText("No Value");
connectField.setText("You must enter a value in the 'Name' field");
state.close();
}
else
{
String query = "SELECT * FROM info " +
"WHERE Name = '" +
nameField.getText() + "'";
isConnectLabel.setText("Querying??");
connectField.setText("Sending Query!!" + connect.nativeSQL(query));
ResultSet rS = state.executeQuery(query);
display(rS);
connectField.setText("Successfull Query");
state.close();
}
}
catch (SQLException sqlex)
{
sqlex.printStackTrace();
connectField.setText(sqlex.toString());
}
}
public void display(ResultSet rS)
{
try
{
rS.next();
nameField.setText(rS.getString(1));
addressField.setText(rS.getString(2));
emailField.setText(rS.getString(3));
}
catch (SQLException sqlX)
{
sqlX.printStackTrace();
connectField.setText(sqlX.toString());
}
}
});
add(clearButton);
clearButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
nameField.setText("");
addressField.setText("");
emailField.setText("");
isConnectLabel.setText("Clearing Fields??");
connectField.setText("Fields Cleared..You may enter a new record..");
}
});
add(gridButton);
gridButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
AddressBookGrid adg = new AddressBookGrid();
Dimension dlgSize = adg.getSize();
Dimension frmSize = getSize();
Point loc = getLocation();
adg.setLocation((frmSize.width = dlgSize.width)/2 + loc.x, (frmSize.height - dlgSize.height)/2 + loc.y);
adg.show();
}
});
add(deleteButton);
deleteButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
Statement state = connect.createStatement();
if (nameField.getText().equals(""))
{
isConnectLabel.setText("No Value to Delete");
connectField.setText("You must enter a value in the 'Name' field to delete the record");
state.close();
}
else
{
String query = "DELETE * FROM info " +
"WHERE Name = '" +
nameField.getText() + "'";
isConnectLabel.setText("Deleting??");
connectField.setText("Sending Query Delete!!" + connect.nativeSQL(query));
state.executeQuery(query);
connectField.setText("Successfull Deletion");
state.close();
}
}
catch (SQLException sqlex)
{
sqlex.printStackTrace();
connectField.setText(sqlex.toString());
}
}
});
add(exitButton);
exitButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
System.exit(0);
}
});
submitButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
Statement state = connect.createStatement();
if (nameField.getText().equals("") &&
addressField.getText().equals("") &&
emailField.getText().equals(""))
{
isConnectLabel.setText("No Values!!");
connectField.setText("You must enter values in the field");
}
else
{
String query = "INSERT INTO info (" +
"Name, " +
"Address, " +
"Email" +
") VALUES ('" +
nameField.getText() + "', '" +
addressField.getText() + "', '" +
emailField.getText() + "')";
connectField.setText("Sending query: " + connect.nativeSQL(query));
int result = state.executeUpdate(query);
if (result == 1)
{
isConnectLabel.setText("Submitted??");
connectField.setText("Insertion successful");
}
else
{
isConnectLabel.setText("Submitted??");
connectField.setText("Insertion unsuccessful");
}
} }
catch (SQLException sqlex)
{
sqlex.printStackTrace();
connectField.setText(sqlex.toString());
}
}});
try
{
url = "jdbc:odbc:AddressBook";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connect = DriverManager.getConnection(url);
connectField.setText("Connection successful");
}
catch(ClassNotFoundException cnfx)
{
cnfx.printStackTrace();
connectField.setText("Connection unsuccessful" + cnfx.toString());
}
catch (SQLException sqlx)
{
sqlx.printStackTrace();
connectField.setText("Connection unsuccessful" + sqlx.toString());
}
catch (Exception ex)
{
ex.printStackTrace();
connectField.setText("Connection unsuccessful" + ex.toString());
}
}
//Get Applet information
public String getAppletInfo()
{
return "Applet Information";
}
//Get parameter info
public String[][] getParameterInfo()
{
return null;
}
//Main method
public static void main(String[] args)
{
AddressBook applet = new AddressBook();
applet.isStandalone = true;
DecoratedFrame frame = new DecoratedFrame();
frame.setTitle("Address Book Applet");
frame.add(applet, BorderLayout.CENTER);
applet.init();
applet.start();
frame.setSize(400,250);
Dimension d = Toolkit.getDefaultToolkit().getScreenSize();
frame.setLocation((d.width - frame.getSize().width) / 2, (d.height - frame.getSize().height) / 2);
frame.setVisible(true);
}
}
/////////////////////////////////////////////////
//beginning of second source file
/////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
//Name of File: AddressBookGrid.java
//Purpose:Shows the contents of your database in a java JTable
//Author:Steven Jacobs
//Date: 03/29/2000
//Comments: Feel free to change/improve/etc. Any questions or concerns,
//email me at sjcplus@aol.com
/////////////////////////////////////////////////////////////////////////////
package untitled20;
import java.awt.*;
import javax.swing.JFrame;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
public class AddressBookGrid extends JFrame
{
private Connection connection;
private JTable table;
private Vector gridColumns;
private Vector gridRows;
AddressBook Ab;
public AddressBookGrid()
{
String url = "jdbc:odbc:AddressBook";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(url);
}
catch (ClassNotFoundException cnf)
{
Ab.connectField.setText("Failed to Connect to Driver");
}
catch (SQLException sqlx)
{
Ab.connectField.setText("Unable to connect");
}
showDatabaseTable();
setSize(450,150);
setTitle("Address Book Grid View");
show();
}
private void showDatabaseTable()
{
try
{
Statement state = connection.createStatement();
String query = "SELECT * FROM info";
ResultSet result = state.executeQuery(query);
displayDatabaseRecords(result);
state.close();
}
catch (SQLException sqlx)
{
sqlx.printStackTrace();
}
}
private void displayDatabaseRecords(ResultSet rS) throws SQLException
{
boolean moreRecords = rS.next();
if (!moreRecords)
{
Ab.connectField.setText("No records to display");
}
gridColumns = new Vector();
gridRows = new Vector();
try
{
ResultSetMetaData rs = rS.getMetaData();
for (int i = 1; i <= rs.getColumnCount(); ++i)
gridColumns.addElement(rs.getColumnName(i));
do
{
gridRows.addElement(getNextRow(rS,rs));
}while (rS.next());
table = new JTable (gridRows, gridColumns);
JScrollPane scroller = new JScrollPane(table);
getContentPane().add(scroller, BorderLayout.CENTER);
validate();
}
catch(SQLException sqlx)
{
sqlx.printStackTrace();
}
}
private Vector getNextRow(ResultSet rS, ResultSetMetaData rs) throws SQLException
{
Vector currentRow = new Vector();
for (int i = 1; i <= rs.getColumnCount(); ++i)
if (rs.getColumnType(i) == Types.VARCHAR)
{
currentRow.addElement(rS.getString(i));
}
else
{
Ab.connectField.setText("Type was: " + rs.getColumnTypeName(i));
}
return currentRow;
}
}
]]>