解决SQL语句中含有中文字符无法查询问题

s}&e Lj _A0package oop.hu.ytu.dao;

"Xk:u RQ0importjava.sql.Connection;51Testing软件测试网,j7_'KGq'zl5l
import java.sql.PreparedStatement;51Testing软件测试网6e7CF:Z7}N.e
import java.sql.ResultSet;51Testing软件测试网ZuK%bG)o]e'?P.|
import oop.hg.ytu.beans.LoginBean;51Testing软件测试网aj6q~bh
import oop.hg.ytu.utils.JdbcUtils;

/**51Testing软件测试网\k7L)U)QUP;d
 * 处理用户登录请求
`Cr!K$R)`)r0 * @author Administrator51Testing软件测试网)R
KZ^
RA/x};q
 *51Testing软件测试网$Nc,WO,F$B _g
 */
8Z5Y E7j*A~q\0public class LoginDomain {
m*_Z)l/Jhxu0 public LoginBean select(String tableName,String username){51Testing软件测试网+P(x-N AZ3z'd0J
  Connection con = null;51Testing软件测试网1KIgt
jT1S
  PreparedStatement pt = null;
:f7d{%FDDG$@&i%sw0  ResultSet rs = null;51Testing软件测试网],h#AD^S
  LoginBean bean = new LoginBean();51Testing软件测试网1n'_Pd kUo H
  

p p"M2|UN0  try {
rC-UQq9\}y
]0   username = "\""+username+"\"";
Uqy,^@YZL0   con = JdbcUtils.getConnection();51Testing软件测试网3^A'x\-]"bB
   String sql = "select name,password from "+tableName+" where name="+username+"";51Testing软件测试网/_!g4rDVS-M1fz'oh
   pt = con.prepareStatement(sql);
[*A0jIL7S0  // pt.setString(1, tableName);51Testing软件测试网H@3{Z6\ wo
  // pt.setString(2, u);
JzT'Fp[*n/q,V0   rs = pt.executeQuery();
*`j{[D1n/B6o0   while(rs.next()){
8B"L&n{+Z"|0    bean.setUsername(rs.getString("name"));51Testing软件测试网"]Zq*T"@
    bean.setPassword(rs.getString("password"));51Testing软件测试网A}2Z'qC$\u;O9r/b&[t
   }
Cv3u3S^"[0  } catch (Exception e) {
Zwe0kl'O0   throw new RuntimeException(e);
"kA(K6ze%E.Q4iHhg u0  }finally{51Testing软件测试网q]EZ1K@'R;Ef
   JdbcUtils.free(rs, pt, con);51Testing软件测试网g;[2j2Y#N6l|5D
  }
M+oA D}sa c0  return bean;
,W~w7O5hj U{!du0 }
V+J"w,yYQzn$Im3q0}