JTable连接数据库.docx

importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;importjava.util.*;publicclassJavaAccessVectorrows;/表行值VectorcolumnHeads;/表列名JTabletables;JScrollPanescrollpanes;/滚动条Connectionconn;/连接数据库对象Statementstate;/对数据库进行操作ResultSetrs;/对数据库操作的结果JButtonbtdel;publicJavaAccess()throwsExceptionFrameframes=newFrame(JTable显示数据库表);/创建窗口frames.addWindowListener(newWindowAdapter()publicvoidwindowClosing(WindowEvente)System.exit(0););tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundExceptione)System.out.println(+e);try/下面的路径可设绝对路径和相对路径/Stringstr=jdbc:odbc:driver=MicrosoftAccessDriver(*.mdb);DBQ=Connection.mdb;Stringstr=jdbc:odbc:javaconn;/这里javaconn是创建数据源的名称conn=DriverManager.getConnection(str,);/创建连接state=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);Stringsql=select*fromjava;/数据库语句rs=state.executeQuery(sql);/执行语句返回到结果集对象if(!(rs.next()/判断数据库中是否有内容JOptionPane.showMessageDialog(null,结果集中无记录,无记录,JOptionPane.INFORMATION_MESSAGE);ResultSetMetaDatarsmd=rs.getMetaData();/获得结果集列属性值 rows=newVector();columnHeads=newVector();for(inti=1;i=rsmd.getColumnCount();i+)columnHeads.addElement(rsmd.getColumnName(i);/添加列名dorows.addElement(getNextRow(rs,rsmd);/添加表行值while(rs.next();tables=newJTable(rows,columnHeads); tables.setSize(newDimension(383,81);/设置表的大小/关闭rs.close();state.close();conn.close();/下面设置窗口的属性btdel=newJButton(删除);btdel.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)tryif(tables.getSelectedRow()!=-1)Stringnames=(tables.getModel().getValueAt(tables.getSelectedRow(),0).toString();Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Stringstr=jdbc:odbc:driver=MicrosoftAccessDriver(*.mdb);DBQ=Connection.mdb;Connectionconn=DriverManager.getConnection(str,);Statementstate=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);Stringsql=deletefromjavawherename=+names+;ResultSetrs=state.executeQuery(sql);ResultSetMetaDatarsmd=rs.getMetaData();Vectorrows=newVector();VectorcolumnHeads=newVector();for(inti=1;i=rsmd.getColumnCount();i+)columnHeads.addElement(rsmd.getColumnName(i);/添加列名dorows.addElement(getNextRow(rs,rsmd);/添加表行值while(rs.next();tables=null;tables=newJTable(rows,columnHeads);/关闭rs.close();state.close();conn.close();catch(Exceptiones)System.out.println(+es.getMessage(););scrollpanes=newJScrollPane(tables);frames.add(scrollpanes,BorderLayout.NORTH);frames.add(btdel,BorderLayout.SOUTH);frames.setVisible(true);frames.setSize(400,400);frames.validate();catch(SQLExceptione)System.out.println(错误信息:+e.getMessage();e.printStackTrace();/取得表行的值方法 privateVectorgetNextRow(ResultSetrs,ResultSetMetaDatarsmd)throwsSQLExceptionVectorcurrentRow=newVector();for(inti=1;i=rsmd.getColumnCount();i+)currentRow.addElement(rs.getString(i);returncurrentRow;publicstaticvoidmain(Stringargs)throwsExceptionnewJavaAccess();这个是我大致写的就是想在jtable中选中行时点击按钮那行就删除了但不知道为什么实现不了对我有用0丢个板砖0引用|举报|管理laorerlaorer等级：#7得分：30回复于： 2009-06-24 13:48:45trySystem.out.println(tables.getSelectedRow():+tables.getSelectedRow();/看下有row是多少,/另外，你就不能把数据库操作放到一个函数里？if(tables.getSelectedRow()!=-1)Stringnames=(tables.getModel().getValueAt(tables.getSelectedRow(),0).toString();Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Stringstr=jdbc:odbc:driver=MicrosoftAccessDriver(*.mdb);DBQ=Connection.mdb;Connectionconn=DriverManager.getConnection(str,);Statementstate=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);Stringsql=deletefromjavawherename=+names+;ResultSetrs=state.executeQuery(sql);ResultSetMetaDatarsmd=rs.getMetaData();Vectorrows=newVector();VectorcolumnHeads=newVector();for(inti=1;i=rsmd.getColumnCount();i+)columnHeads.addElement(rsmd.getColumnName(i);/添加列名dorows.a