使用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 blocke1.printStackTrace();} System.exit(0); }});}}

 

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