连接到数据库的程序的源代码.doc_第1页
连接到数据库的程序的源代码.doc_第2页
连接到数据库的程序的源代码.doc_第3页
连接到数据库的程序的源代码.doc_第4页
连接到数据库的程序的源代码.doc_第5页
已阅读5页,还剩3页未读, 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

这个程序是连接到数据库的一个程序,主要功能是在上方的文本输入框中输入查询语句,实现从数据库中查询的功能,还可以在下方的过滤文本框中输入要过滤的文本,实现过滤查询结果的功能。现在的问题是编译能够成功,但是运行时会报错。错误信息及源代码在下面给出,请问原因为何?多谢指教。/这是ResultSetTableModel类,用作JTable的构造函数的参数。package ResultSetTableModel;import java.sql.*;import javax.swing.table.*;public class ResultSetTableModel extends AbstractTableModelprivate Connection connection;private Statement statement;private ResultSet resultset;private ResultSetMetaData metadata;private int numberofrows;private boolean connectedtodatabase=false;public ResultSetTableModel(String url,String username,String password,String query)tryconnection=DriverManager.getConnection(url,username,password);statement=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);connectedtodatabase=true;setQuery(query);catch(SQLException sqlexception)System.out.println(error on connecting to database);public void setQuery(String query) throws SQLException,IllegalStateExceptionif(!connectedtodatabase)throw new IllegalStateException(Not connected to database);resultset=statement.executeQuery(query);metadata=resultset.getMetaData();public void disconnectFromDatabase()if(connectedtodatabase)tryresultset.close();statement.close();connection.close();catch(SQLException sqlException)sqlException.printStackTrace();finallyconnectedtodatabase=false;public int getColumnCount() throws IllegalStateExceptionint currentrow=1;if(!connectedtodatabase)throw new IllegalStateException(Not connected to database);tryresultset.last();currentrow=resultset.getRow();catch(SQLException sqlexception)sqlexception.printStackTrace();return currentrow;public Class getColumnClass(int column) throws IllegalStateExceptionif(!connectedtodatabase)throw new IllegalStateException(Not connected to database);tryString className=metadata.getColumnClassName(column+1);return Class.forName(className);catch(Exception exception)exception.printStackTrace();finallyreturn Object.class;public String getColumnName(int column) throws IllegalStateExceptionString columnname=null;if(!connectedtodatabase)throw new IllegalStateException(Not connected to database);try columnname=metadata.getColumnName(column+1);catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallyreturn columnname;public int getRowCount() throws IllegalStateExceptionint rowcount=0;if(!connectedtodatabase)throw new IllegalStateException(Not connected to database);try resultset.last();rowcount=numberofrows=resultset.getRow();catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallyreturn numberofrows;public String getValueAt(int row,int column) throws IllegalStateExceptionif(!connectedtodatabase)throw new IllegalStateException(Not connected to database);try resultset.absolute(row+1);return resultset.getObject(column+1).toString();catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return ;/这是QueryData类,其中实现了图形界面package ResultSetTableModel;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.SQLException;import java.util.regex.*;import javax.swing.table.*;public class QueryData extends JFrame static final String DATABASEURL=jdbc:oracle:thin:localhost:1521:orcl; static final String DATABASEUSERNAME=scott; static final String DATABASEPASSWORD=123456; private JButton submitquery; private Box boxnorth,boxsouth; private JTextArea inquerysentence; private JTextField filtercondition; private JButton applyfilter; private ResultSetTableModel tablemodel; private JTable resulttable; public QueryData() super(Displaying query results); Box boxnorth,boxsouth; JTextArea inquerysentence; JTextField filtercondition; JButton applyfilter; ResultSetTableModel tablemodel=new ResultSetTableModel(DATABASEURL,DATABASEUSERNAME,DATABASEPASSWORD,select * from emp); boxnorth=Box.createHorizontalBox(); boxsouth=Box.createHorizontalBox(); inquerysentence=new JTextArea(select * from emp,30,100); inquerysentence.setWrapStyleWord(true); inquerysentence.setLineWrap(true); submitquery=new JButton(Submit Query); boxnorth.add(new JScrollPane(inquerysentence); boxnorth.add(submitquery); JTable resulttable=new JTable(tablemodel); JLabel filterflag=new JLabel(Filter); filtercondition=new JTextField(); applyfilter=new JButton(Apply Filter); boxsouth.add(filterflag); boxsouth.add(filtercondition); boxsouth.add(applyfilter); add(boxnorth,BorderLayout.NORTH); add(new JScrollPane(resulttable),BorderLayout.CENTER); add(boxsouth,BorderLayout.SOUTH); setSize(500,500); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); submitQuery(inquerysentence.getText(); applyFilter(filtercondition.getText(); public void submitQuery(final String sentencetoinquery) submitquery.addActionListener( new ActionListener() public void actionPerformed(ActionEvent actionevent) try tablemodel.setQuery(sentencetoinquery); catch(SQLException sqlexception) JOptionPane.showMessageDialog(null, sqlexception.getMessage(),Database error, JOptionPane.ERROR_MESSAGE ); ); public void applyFilter(final String filtercondition) final TableRowSorter sorter=new TableRowSorter(tablemodel); resulttable.setRowSorter(sorter); applyfilter.addActionListener( new ActionListener() public void actionPerformed(ActionEvent actionevent) if(filtercondition.length()=0) sorter.setRowFilter(null); else try sorter.setRowFilter(RowFilter.regexFilter(filtercondition); catch(Exception exception) JOptionPane.showMessageDialog(null, Bad regex pattern,Bad regex pattern, JOptionPane.ERROR_MESSAGE ); ); public stati

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论