使用ibatis2的jpetstore报错

如果使用了hsqldb以外数据库的，点击添加一个宠物到购物车的时候，总会报错，不同的数据库不一样，mysql是报“Column 'ITEMID' in field list is ambiguous”，oracle则报一堆有乱码的错误，无奈只能用默认的hsqldb，它需要一个叫hsqldb.jar的东西，lib目录下有，不过默认使用的是内存数据库，即工程一关闭数据全消失，如果想保存住，需要用服务器模式，下面是相应的命令：

进到hsqldb.jar所在的目录：

建立数据库，必须起个别名，都叫jpetstore：
java -cp hsqldb.jar org.hsqldb.Server -database.0 db/jpetstore

 

 

启动数据库：以server模式
java -cp hsqldb.jar org.hsqldb.Server -database.0 db/jpetstore -dbname.0 jpetstore
jpetstore是数据库名字

server模式的url及driver:
driver=org.hsqldb.jdbcDriver
url=jdbc:hsqldb:hsql://localhost/jpetstore
username=sa
password=

 

默认用户名为sa,密码为空，最好把启动的语句写个成bat文件，双击执行就行。

 

但另一个不爽的是，我用myeclipse8.0，在database视图中点击edit data看不到表的内容，显然是个bug，想看你只能写个查询的sql，无奈花了1个多小时，写了个程序来自动查询：

 package frames; import java.awt.BorderLayout; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; 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 java.util.Enumeration; import java.util.Vector; import javax.swing.ButtonGroup; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JRadioButton; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; import javax.swing.table.TableColumn; public class QueryTable { public static void main(String[] args) throws Exception { String url = "jdbc:hsqldb:hsql://localhost/jpetstore"; String driver = "org.hsqldb.jdbcDriver"; Class.forName(driver).newInstance(); final Connection conn = DriverManager.getConnection(url, "sa", ""); Statement stmt = conn.createStatement(); ResultSet rsTables = stmt.executeQuery("select table_name from INFORMATION_SCHEMA.SYSTEM_TABLES where table_type='TABLE';"); JFrame frame = new JFrame(); JPanel pnlTop = new JPanel(new FlowLayout(FlowLayout.LEFT)); ButtonGroup bg = new ButtonGroup(); final JTable jtable=new JTable(); final JScrollPane jsp = new JScrollPane(jtable); while (rsTables.next()) { final String table = rsTables.getString(1); JRadioButton jrb = new JRadioButton(table); pnlTop.add(jrb); bg.add(jrb); jrb.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { try { Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from "+table); ResultSetMetaData meta=rs.getMetaData(); Vector vData=new Vector(); while (rs.next()){ Vector vRow=new Vector(); for (int i = 1; i <=meta.getColumnCount(); i++) { vRow.add(rs.getObject(meta.getColumnName(i))); } vData.add(vRow); } Vector vColNames=new Vector(); for (int i = 1; i <= meta.getColumnCount(); i++) { vColNames.add(meta.getColumnName(i)); } DefaultTableModel model=new DefaultTableModel(vData, vColNames); jtable.setModel(model); JTableHeader header = jtable.getTableHeader(); int rowCount = jtable.getRowCount(); Enumeration columns = jtable.getColumnModel().getColumns(); while (columns.hasMoreElements()) { TableColumn column = (TableColumn) columns.nextElement(); int col = header.getColumnModel().getColumnIndex(column.getIdentifier()); int width = (int) jtable.getTableHeader().getDefaultRenderer() .getTableCellRendererComponent(jtable,column.getIdentifier(), false, false, -1, col).getPreferredSize().getWidth(); for (int row = 0; row < rowCount; row++) { int preferedWidth = (int) jtable.getCellRenderer(row, col) .getTableCellRendererComponent(jtable,jtable.getValueAt(row, col), false, false, row,col).getPreferredSize().getWidth(); width = Math.max(width, preferedWidth); } header.setResizingColumn(column); // 此行很重要 column.setWidth(width + jtable.getIntercellSpacing().width+5); } jtable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); } catch (SQLException e1) { e1.printStackTrace(); } } }); } frame.add(pnlTop, BorderLayout.NORTH); frame.add(jsp,BorderLayout.CENTER); frame.setSize(900, 400); frame.setVisible(true); frame.addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { try { conn.close(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } System.exit(0); } }); } }

 

原理很简单，不解释了。运行效果如下：