《java核心技术》这本书上有例子。
解决方案 »
- 新手提问~
- 验证字符串只含数字和小数点的正则表达是。。。。?
- 我的机器编译java为什么这么慢?解决问题者得30分.
- 【菜鸟问题】在Canvas上用Graphic2D作图时部分重画的问题
- 问:main()函数中的args[]数组在何时能用上?有什么作用?
- 请问 这个异常可能是什么造成的?
- JAVA里面的方法是怎么样把参数值返回?
- 急!!!如何从一个webapp里得到另一个webapp中的session中的数据???
- 小问题一个:ie6是否支持java2,先答先得(当然得答对)!
- java.sql.SQLException: 列名无效
- Thead对象的sleep方法,和yield方法有何区别,为什么实现的线程中,在run方法中要调用sleep方法?
- help! 命令行编译错误:系统找不到指定的路径
import java.sql.*;
import javax.swing.*;
import javax.swing.tree.*;
import java.awt.*;
import java.awt.event.*;class AccessDBTest {
public static void main(String args[]) {
JFrame frame = new AccessDBTestFrame();
frame.show();
}
}class AccessDBTestFrame
extends JFrame {
AccessDBTestFrame() {
setTitle("ViewDB");
setSize(400, 300); readTree(); JTree tree = new JTree(root);
tree.setEditable(true);
Container contentPane = getContentPane();
contentPane.add(new JScrollPane(tree), BorderLayout.WEST); JButton button = new JButton();
button.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent event) {
try {
conn = getConnection();
stat = conn.createStatement();
//add new
ResultSet rs = stat.executeQuery("INSERT INTO Publishers (Publisher_Id,Name,URL) VALUES(00219,'China Machine Press','www.machine.com')");
stat.close();
conn.close();
readTree();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
);
JPanel panel = new JPanel();
panel.add(button); contentPane.add(panel);
} public static Connection getConnection() throws SQLException {
System.setProperty("jdbc.drivers", "sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=" +
"AccessDB.mdb";
return DriverManager.getConnection(url, "", "");
} public void readTree() {
try {
conn = getConnection();
stat = conn.createStatement(); //setup tree model root
root = new DefaultMutableTreeNode("Books");
ResultSet rs = stat.executeQuery("SELECT Name FROM Publishers");
while (rs.next()) {
DefaultMutableTreeNode node = new DefaultMutableTreeNode(rs.getString(1));
root.add(node);
}
stat.close();
conn.close();
}
catch (Exception ex) {
JOptionPane.showMessageDialog(this, ex);
}
} private Connection conn;
private Statement stat;
private DefaultMutableTreeNode root;
}