說重點,
String username = "楊婷";
String name = "/'"+username+"/'";String sql = "select * from Mekp_Information where accepter = "+name;
ResultSet rs;try {rs = stmt.executeQuery(sql);while(rs.next()){System.out.PRintln(rs.getString("subject"));}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}
以上代碼是查詢sqlserver表中的數據,但是查詢失敗
解決方案:
1,檢查表的字段類型 改為nvarchar
2,sql語句改為:String sql = "select * from Mekp_Information where accepter = N "+name; 注意: 字段值前面加個大寫的N
如此大功告成。
新聞熱點
疑難解答