查询数据库遇到中文问题,搞得我都晕啦,请高手帮忙~~~~~谁能解决50分就给他一人
查询的数据库是acess的,代码段如下:
String ziyuanfenku = request.getParameter("select1");
String xiangguanjibing = request.getParameter("select2");
String yangbenxingzhi = request.getParameter("select3");
String biaobenleixing = request.getParameter("select4");
String minzu = request.getParameter("select5");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:data");
String sq1="SELECT * FROM table1 WHERE (分库库号=?) AND (相关疾病=?) AND (样本性质 LIKE ?) AND (?='yes') (AND 民族=?)";
PreparedStatement state1 = con.prepareStatement(sq1);
if (yangbenxingzhi.equals("家系")){
String yangbenxingzhi1 = yangbenxingzhi+"%";
}
state1.setString(1,ziyuanfenku);
state1.setString(2,xiangguanjibing);
state1.setString(3,yangbenxingzhi1);
state1.setString(4,biaobenleixing);
state1.setString(5,minzu);
ResultSet rs1 = state1.executeQuery();
错误信息是:
cannot resolve symbol
symbol : variable yangbenxingzhi1
location: class org.apache.jsp.chgres.info.process_jsp
state1.setString(3,yangbenxingzhi1);
搞了半天不知道是怎么回事,是不是like子句的问题,还是中文的问题?