test.jsp

<%
String xibie = request.getParameter("optProvince");
//xibie = new String(xiebie.getBytes("ISO8859-1"),"utf-8");
String zhuanye = request.getParameter("optCity");
//zhuanye = new String(zhuanye.getBytes("ISO8859-1"),"utf-8");
//String banji = request.getParameter("banji");
//banji = new String(banji.getBytes("ISO8859-1"),"utf-8");
  
   DriverManager.registerDriver(new SQLServerDriver());
  String url="jdbc:microsoft:sqlserver://10.34.8.170:1433;databaseName=HOMEWORK";
  String user="sa";
  String pwd="sa";
  Connection conn = DriverManager.getConnection(url,user,pwd);
  String sqlQue="select * from tb_test where xibie='"+optProvince+"'"+" and zhuanye='"+optCity+"'";
  PreparedStatement pst = conn.prepareStatement(sqlQue);
  ResultSet rs = pst.executeQuery();
  while(rs.next())
  {
%>