java连接access数据库问题

[zhe8300975]

try
{
theStatement=theConnection.createStatement();
theResult=theStatement.executeQuery("select * from people");
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
tableModel.setRowCount(0);
while(theResult.next())
{
String colValue[]={theResult.getString(1),gbk_str.gbk_string(theResult.getBytes(2)),gbk_str.gbk_string(theResult.getBytes(3))};
tableModel.addRow(colValue);
}
jTable1.invalidate();
}
catch(Exception e)
{
handleException(e);
}
这个是可以的

String peo_name=jTextField2.getText();
try
{
theStatement=theConnection.createStatement();
theResult=theStatement.executeQuery("select * from people where name ='"+peo_name+"'");
这个就有问题了
错误报告
[Microsoft][ODBC Microsoft Access Driver] ?ַ???﷨???? ?ڲ?ѯ???ʽ 'name ='赵文??' ?С?
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ?ַ???﷨???? ?ڲ?ѯ???ʽ 'name ='赵文??' ?С?
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3109)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
at MainJFrame.jButton2ActionPerformed(MainJFrame.java:185)
at MainJFrame.access$100(MainJFrame.java:21)
at MainJFrame$3.actionPerformed(MainJFrame.java:94)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6437)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6202)
at java.awt.Container.processEvent(Container.java:2213)
at java.awt.Component.dispatchEventImpl(Component.java:4793)
at java.awt.Container.dispatchEventImpl(Container.java:2271)
at java.awt.Component.dispatchEvent(Component.java:4619)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4816)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4476)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4406)
at java.awt.Container.dispatchEventImpl(Container.java:2257)
at java.awt.Window.dispatchEventImpl(Window.java:2677)
at java.awt.Component.dispatchEvent(Component.java:4619)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:662)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
这是什么情况呢？

[zhe8300975]

单步调试主要是theResult=theStatement.executeQuery("select * from people where name ='"+peo_name+"'");
SQL语言那出错