求解无语了

[bf234511171]

数据库
phoneNum productId accessNo

[diguoguo]

-------------------------

[niu90]

[storm_1984]

?????????

[阳光下的木棉]

看的也无语了。。

[bf234511171]

数据库
phoneNum productId accessNo
111 1 10600033
222 1 10600033
333 1 10600033

package com.zte.udt.atomService;
import java.sql.*;
import java.util.*;

public class Conn3ASE {




public Map<String,Object> Stradd(Map<String,Object> map){
String s1 = (String) map.get("input1");
String s2 = (String) map.get("input2");
String accessNo=(String) map.get("input3");
String s3 = Stradd(s1,s2,accessNo);


Map<String,Object> result = new HashMap<String,Object>();
result.put("output1", s3);

return result;

}

private String Stradd(String s1,String s2,String accessNo){
try {
StringBuffer str = new StringBuffer();

DriverManager.registerDriver(new com.sybase.jdbc2.jdbc.SybDriver());
Connection conn = DriverManager.getConnection(
"jdbc:sybase:Tds:10.129.39.157:4100/udtsce", "zteudtsce",
"zteudtsce");

Statement stmt = conn.createStatement();

// String sql = "select "+s1+" from "+s2+" where accessNo = " +accessNo+ " " ;
String sql = "select "+s1+" from "+s2+" where accessNo = \""+accessNo+"\"";
// String sql = "select phoneNum from uoe_chat_user where accessNo = \"10600033\"";


System.out.println(sql);

ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {

String s = rs.getString("phoneNum");
str=str.append(s+"|");
}
String sr = str.toString();

return sr;

} catch (Exception e) {
System.out.println(e.getMessage());
}
return null;
}

public static void main(String[] args){


Conn3ASE comm = new Conn3ASE();
String s = comm.Stradd("phoneNum","uoe_chat_user","10600033");

System.out.print(s);
}
}
为什么老是报错误：
Invalid column name '10600033'.

用的是sybase数据库

[-droidcoffee-]

lz 想表达啥

[bf234511171]

我不是在下面说了吧老是报错误！得不倒我要查的数据

[bf234511171]

我在线等希望高手们帮我下！

[bf234511171]

谢谢各位的热心人回复，问题解决了 String sql = "select "+s1+" from "+s2+" where accessNo = '"+accessNo+"'"；

[qianquan]

[china453000]

问是一个好办法，关键还是要自学

[luoye_teng]

把你数据库的表结构，，字段的数据类型贴出来看看。