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

Question

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

Answer 1

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

Answer 2

String business_city="哈尔滨";

Answer 3

<%
 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);

Answer 4

String business_city="哈尔滨";

Answer 5

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

Answer 6

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);

Answer 7

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){
       
}

Answer 8

<%
 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.jspGenerated 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.jspGenerated 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);//

Answer 9

<%
 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.jspGenerated servlet error:
    [javac] Compiling 1 source fileC:\Tomcat 4.1\work\Standalone\localhost\_\upjidi_0002d1_0002dmain_jsp.java:74: unclosed character literal
String business_city='????'?

Answer 10

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

Answer 11

request.setCharacterEncoding(response.getCharacterEncoding());