String business_city='哈尔滨';定义对吗？

[gumplei]

String business_city='哈尔滨';
byte[] tmpbyte=business_city.getBytes("ISO8859_1");
business_city=new String(tmpbyte);

String sql="select * from business_tab where business_city like '"+"%"+business_city+"%"
+"'";
ResultSet rs=dBBean.executeQuery(sql);//定义结果集,执行sql语句
错误显示：
C:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:74: unclosed character literal
String business_city='????'?

这个试什么错误，求教。马上结分

[bdscSecond]

先别web/jdbc,多写几个helloworld吧

[gumplei]

String business_city='哈尔滨';
我这个付值是错了吗？？？？

[ipv]

String business_city="哈尔滨";

[gumplei]

<%
dBBean.connect();
String business_city='哈尔滨';//获取传来的主键
byte[] tmpbyte=business_city.getBytes("ISO8859_1");
business_city=new String(tmpbyte);
String sql="select business_no,business_name,business_city,business_addr,business_phone from business_tab where business_city='哈尔滨' ";
ResultSet rs=dBBean.executeQuery(sql);//定义结果集,执行sql语句
System.out.print(sql);

[gumplei]

帮忙看看什么错误。对了的话，分全给一个人

[micker]

兄弟，不知道你的两条裤衩是怎么来的？？肯定是作弊来的，我想！
先去学习基础的吧！

[xqi8]

String business_city="哈尔滨";

[vbscript1981]

1.String business_city='哈尔滨'; 错了
你这个是对字符赋值，就用 '' 如 Char abc='a'

2.楼上的String business_city="哈尔滨";对了
对字符串，要用""

[micker]

dBBean.connect();
String business_city="哈尔滨";//获取传来的主键
byte[] tmpbyte=business_city.getBytes("ISO8859_1");
business_city=new String(tmpbyte);
String sql="select business_no,business_name,business_city,business_addr,business_phone from business_tab where business_city='"+business+"' ";
ResultSet rs=dBBean.executeQuery(sql);//定义结果集,执行sql语句
System.out.print(sql);

[Chinatosun]

try{
String business_city="哈尔滨";
business_city=new String(business_city.getBytes("ISO8859-1"));
String sql="select * from business_tab where business_city like '"+"%"+business_city+"%"
+"'";
ResultSet rs=dBBean.executeQuery(sql);
}
catch(Exception e){

}

[gumplei]

<%
request.setCharacterEncoding("GBK");
dBBean.connect();
String business_city="哈尔滨";//获取传来的主键

String sql="select business_no,business_name,business_city,business_addr,business_phone from business_tab where business_city='"+"%"+business_city+"%"
+"'";
ResultSet rs=dBBean.executeQuery(sql);//定义结果集,执行sql语句
System.out.print(sql);

%>
错误如下：
C:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:74: unclosed character literal
String business_city='????'?
^



An error occurred at line: 15 in the jsp file: /upjidi-1-main.jsp

Generated servlet error:
C:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:74: unclosed character literal
String business_city='????'?
^



An error occurred at line: 15 in the jsp file: /upjidi-1-main.jsp

Generated servlet error:
C:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:77: cannot resolve symbol
symbol : variable sql
location: class org.apache.jsp.upjidi_0002d1_0002dmain_jsp
ResultSet rs=dBBean.executeQuery(sql);//

[gumplei]

<%
dBBean.connect();
try{
String business_city="哈尔滨";
business_city=new String(business_city.getBytes("ISO8859-1"));
String sql="select * from business_tab where business_city like '"+"%"+business_city+"%"
+"'";
ResultSet rs=dBBean.executeQuery(sql);
}
catch(Exception e){

}

%>
错误如下：
An error occurred at line: 15 in the jsp file: /upjidi-1-main.jsp

Generated servlet error:
[javac] Compiling 1 source file

C:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:74: unclosed character literal
String business_city='????'?

[Chinatosun]

需要捕捉sql语句例外。是强制标准！

[ningIII]

request.setCharacterEncoding(response.getCharacterEncoding());