try { con = DriverManager.getConnection("jdbc:odbc:point21DSN","sa",""); sql = con.createStatement(); rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone ="&id3&""); while(rs.next()) { id1 = rs.getInt(3); } con.close(); }
呵呵!不可以这样! 你试试: rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone = " + &id3&);
rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone ="&id3&"");应该这样吧 rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone =\"&id3&\"");
{ con = DriverManager.getConnection("jdbc:odbc:point21DSN","sa","");
sql = con.createStatement(); rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone ="&id3&"");
while(rs.next())
{ id1 = rs.getInt(3);
}
con.close();
}
你试试:
rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone = " + &id3&);
rs = sql.executeQuery("SELECT point point21.dbo.ussd_ipp where phone =\"&id3&\"");