将数据类型varchar转换为数字

Question

Statement stmt1 = null; 
ResultSet srs1 = null; 
List3 = new ArrayList<String>(); 
stmt1 = conn.createStatement(); 
srs1 = stmt1 .executeQuery("SELECT [FILE_ACL].[FILE_SYSTEM_ID],
                      [USER_LITE].[USERS].[SYS_ID] FROM [FILE_ACL],
                      [USER_LITE].[USERS] WHERE [FILE_ACL].[PEOPLE_SYSTEM_ID]
                     = 'u' AND [USER_LITE].[USERS].[SYS_ID] 
                     = [FILE_ACL].[PEOPLE_SYSTEM_ID]"); 

while (srs1.next()) { 
    List3.add(srs1.getString("FILE_SYSTEM_ID"));
} 
System.out.println(List3);

我从

for (int u = 2; u < List1.size(); u++) {
  System.out.println(List1.get(u)); 
 } 

它会给我一个整数

========================================================================

但我遇到了错误，将数据类型varchar转换为数值。

有什么解决办法吗？

谢谢!

Answer 1

 Implicit conversion from datatype 
'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run
 this query.