通过JApplet连接derby数据库

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JApplet;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.SwingUtilities;


public class JDBC_Applet extends JApplet{
	private JScrollPane jScrollPane;
	private JTextArea taResponse;
	private JPanel jPanel1,jPanel2,jPanel3,jPanel4;
	private JLabel jLabel3,jLabel6,jLabel7,jLabel9,jLabel10;
	private JTextField tfSql,tfUrl,tfUser,tfPassword;
	private JButton btnExecute,btnConnect,btnDisconnect;
	private JComboBox cbDriver;
	//-----------------------------------------------------------------------------------
	final static private String[] jdbcDriver = { "com.mysql.jdbc.Driver",
		"com.informix.jdbc.IfxDriver", "sun.jdbc.odbc.JdbcOdbcDriver",
		"com.borland.datastore.jdbc.DataStoreDriver","org.apache.derby.jdbc.EmbeddedDriver",
		"com.sybase.jdbc.SybDriver", "oracle.jdbc.driver.OracleDriver",
		"COM.ibm.db2.jdbc.net.DB2Driver", "interbase.interclient.Driver",
		"weblogic.jdbc.mssqlserver4.Driver" };
	private boolean connected = false;//初始连接为假
	private Connection con = null;//连接对像
	private ResultSet rs = null;//结果
	private String query = null;//查询
	
	private String rsLine = null;//结果集的行
	private String driver = null;
	private String url = null;
	private String user = null;
	private String password = null;
	//-----------------------------------------------------------------------------------
	public JDBC_Applet(){
		Com_init();//窗体内容
		Post_init();//下拉菜单
	}
	public void Post_init(){//下拉菜单的内容
		for(int i= 0; i < jdbcDriver.length; i++){
			cbDriver.addItem(jdbcDriver[i]);
		}
	}
	private void Com_init() {
		jScrollPane = new JScrollPane();//面板
		taResponse = new JTextArea();//response:响应  文本域
		// 显示sql查询结果的文本区域
		jPanel2 = new JPanel();
		jPanel1 = new JPanel();
		jLabel6 = new JLabel();
		tfSql = new JTextField();
		// 输入sql语句的文本区域。
		btnExecute = new JButton();
		// sql执行按钮
		jPanel3 = new JPanel();
		jLabel3 = new JLabel();
		jPanel4 = new JPanel();
		cbDriver = new JComboBox();
		// 数据库驱动下拉框
		jLabel7 = new JLabel();
		tfUrl = new JTextField();
		// 连接数据库的url
		jLabel9 = new JLabel();
		tfUser = new JTextField();
		// 录入用户名的文本框
		jLabel10 = new JLabel();
		tfPassword = new JTextField();
		// 录入用户密码的文本框
		btnConnect = new JButton();
		// 连接button
		btnDisconnect = new JButton();
		// 释放数据库连接的button
		setFont(new Font("Verdana", 0, 25));		
		// 设置字体
		jScrollPane.setViewportView(taResponse);
		getContentPane().add(jScrollPane, BorderLayout.CENTER);
		getContentPane().add(jPanel2, BorderLayout.EAST);
		jLabel6.setText("SQL:");
		// label Sql:
		jPanel1.add(jLabel6);
		tfSql.setPreferredSize(new Dimension(300, 21));
		jPanel1.add(tfSql);
		btnExecute.setText("执行语句");
		btnExecute.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent evt) {
				btnExecuteActionPerformed(evt);
				}
		});
		jPanel1.add(btnExecute);
		// 将jPanel1放到上边
		getContentPane().add(jPanel1, BorderLayout.SOUTH);

		jPanel3.setPreferredSize(new Dimension(550, 100));
		jPanel3.setMinimumSize(new Dimension(550, 100));
		jPanel3.setMaximumSize(new Dimension(550, 100));

		jLabel3.setText("JDBC 驱动:");
		jPanel3.add(jLabel3);
		// label JDBC Driver:
		jPanel3.add(jPanel4);

		cbDriver.setPreferredSize(new Dimension(450, 26));
		cbDriver.setMinimumSize(new Dimension(100, 26));
		jPanel3.add(cbDriver);

		jLabel7.setText("数据库地址:");
		jPanel3.add(jLabel7);
		// label Database URL:
		tfUrl.setPreferredSize(new Dimension(450, 21));
		jPanel3.add(tfUrl);

		jLabel9.setText("用户名:");
		jPanel3.add(jLabel9);
		// label User:

		tfUser.setPreferredSize(new Dimension(100, 21));
		jPanel3.add(tfUser);

		jLabel10.setText("密码:");
		jPanel3.add(jLabel10);
		tfPassword.setPreferredSize(new Dimension(100, 21));
		jPanel3.add(tfPassword);

		btnConnect.setPreferredSize(new Dimension(89, 27));
		btnConnect.setMaximumSize(new Dimension(89, 27));
		btnConnect.setText("连接");
		btnConnect.setMinimumSize(new Dimension(89, 27));
		btnConnect.addActionListener(new ActionListener() {//连接按钮事件
			public void actionPerformed(ActionEvent evt) {
				btnConnectActionPerformed(evt);
			}
		});
		jPanel3.add(btnConnect);

		btnDisconnect.setText("断开");
		btnDisconnect.addActionListener(new ActionListener() {//断开按钮事件
			public void actionPerformed(ActionEvent evt) {
				btnDisconnectActionPerformed(evt);
			}
		});
		jPanel3.add(btnDisconnect);
		// 放在布局管理器的北边
		getContentPane().add(jPanel3, BorderLayout.NORTH);		
	}
	//-----------------------------------------------------------------------------------
	private void btnConnectActionPerformed(ActionEvent be){//连接事件细节
		if(connected){
			taResponse.append("数据库已连接.\n");
		}else{
			driver = (String)cbDriver.getSelectedItem();//把下拉菜单的内容赋值给driver
			url = tfUrl.getText();//用户输入数据库地址
			user = tfUser.getText();
			password = tfPassword.getText();
			try{
				SwingUtilities.invokeLater(new Runnable(){
					public void run(){
						taResponse.append("Using JDBC driver: " + driver + "\n");
					}
				});
				// 注册数据库驱动 通过jdbc的方式连接数据库
				Class.forName(driver).newInstance();
				//con = DriverManager.getConnection(url,user,password);
				con = DriverManager.getConnection(url);
				if(con != null){
					SwingUtilities.invokeLater(new Runnable(){
						public void run(){
							taResponse.append("数据库 " + url + " 已经连接.\n");
						}
					});
					connected = true;
				}
			}catch(ClassNotFoundException e){
				SwingUtilities.invokeLater(new Runnable(){
					public void run(){
						taResponse.append("不能加载驱动.\n");
					}
				});
				e.printStackTrace();
			}catch(SQLException se){
				SwingUtilities.invokeLater(new Runnable(){
					public void run(){
						taResponse.append("不能连接数据库.\n");
					}
				});
				se.printStackTrace();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	//-----------------------------------------------------------------------------------	
	private void btnDisconnectActionPerformed(ActionEvent e){//断开事件细节
		if(connected){
			try{
				if(con != null){
					con.close();
					con = null;
					SwingUtilities.invokeLater(new Runnable(){
						public void run(){
							taResponse.append("数据库断开.\n");
						}
					});
				}
			}catch(SQLException se){
				SwingUtilities.invokeLater(new Runnable(){
					public void run(){
						taResponse.append("数据库断开错误.\n");
					}
				});
				se.printStackTrace();
			}
			connected = false;
			driver = null;
			url = null;
			user = null;
			password = null;
		}else{
			SwingUtilities.invokeLater(new Runnable(){
				public void run(){
					taResponse.append("数据库已断开.\n");
				}
			});
		}
	}
	//-----------------------------------------------------------------------------------
	private void btnExecuteActionPerformed(ActionEvent evt) {//执行SQL语句处理
		if(!connected){//没有连接的情况
			SwingUtilities.invokeLater(new Runnable(){
				public void run(){
					taResponse.append("没有可连接的数据库.\n");
				}
			});
		}else{
			if(con == null){//con为空的情况
				SwingUtilities.invokeLater(new Runnable() {
					public void run() {
						taResponse.append("连接数据库错误.\n");
					}
				});
			}else{
				try{
					query = tfSql.getText();//从文本域里获得用户输入
					Statement stmt = con.createStatement();//创建一个声明
					SwingUtilities.invokeLater(new Runnable(){
						public void run(){
							taResponse.append("正在查询:" + query + "\n");
						}
					});
					rs = stmt.executeQuery(query);
					ResultSetMetaData rsmd = rs.getMetaData();//获得结果集以便更多使用方法
					int count = rsmd.getColumnCount();//获得列数
					int i;
					rsLine = "\n 表的结构如下：\n";
					for(int it = 1; it <= count; it++){
						rsLine += rsmd.getColumnName(it) + " ";//获得所有列名
					}
					rsLine += "\n";
					while(rs.next()){
						for(i = 1; i <= count; i++){
							String s;
							try{
								s = new String(rs.getString(i).getBytes("ISO-8859-1"),"GBK");
								rsLine += s;
							}catch (UnsupportedEncodingException e) {
								JOptionPane.showMessageDialog(null, "系统不支持的字符");
							}
						}
						rsLine += "\n";
					}
					rsLine += "\n";
					stmt.close();
					SwingUtilities.invokeLater(new Runnable(){
						public void run(){
							taResponse.append(rsLine);
						}
					});
				}catch (SQLException e) {
					SwingUtilities.invokeLater(new Runnable() {
						public void run() {
							taResponse.append("查询失败.\n");
						}
					});
					e.printStackTrace();
				}
			}
		}
	}
	public static void main(String[] args) {
		JFrame frame = new JFrame("通过JApplet连接数据库...");
		JDBC_Applet applet = new JDBC_Applet();
		frame.addWindowListener(new WindowAdapter() {
			public void windowClosing(WindowEvent e) {
				System.exit(0);
			}
		});
		frame.getContentPane().add(applet);
		applet.init();
		frame.setSize(400, 300);
		frame.setVisible(true);
	}

}