Question

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确 这个错误如何解决啊

if (e.getSource() == del){
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 加载驱动程序
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\My Documents\\txl.mdb";
Connection conn = DriverManager.getConnection(url, "", "");//建立连接；
String sql1="select usercont from contact where username=?";
PreparedStatement ps1 = conn.prepareStatement(sql1);

rs=ps1.executeQuery();
while (rs.next()) {
a.setText(rs.getString(2)+"\n");
JOptionPane.showMessageDialog(null,"文本框中已显示出您目前所有好记录，请输入您要删除的联系人的姓名以删除该联系人！","提示！",JOptionPane.OK_OPTION);
JOptionPane.showInputDialog("姓名：");

}

} catch (Exception e3) {
e3.printStackTrace();
}
contact表中有5个字段，分别是：username,usercont,gender,qq,e-maile.

Answer 1

你把sql改为select * from 吧,你只去了usercont一个字段,哪来的getstring(2)取啊!

Answer 2

select usercont from contact where username=?"
你还没给 username设置查询的值！
ps1.setString(1,"查询的名字");