Çë½ÌjspÖÐÏÂÀ­ÁбíµÄ¶¯Ì¬²éѯ - Java / Web ¿ª·¢

ÏÂÀ­ÁбíÖеÄÖµÊÇ´ÓÊý¾Ý¿âÖеõ½µÄ£¬ÔõÑùʵÏÖÈ¡µ½ÏÂÀ­ÁбíµÄÖµ²¢²éѯÊý¾Ý¿â

sqlÓï¾ä£ºString sql="select * from xiaofei where regname like '%"+userid+"%' and xfdate=´ÓÏÂÀ­ÁбíÖÐÈ¡µÃµÄÖµ";


selectµÄÓï¾ä£º
<form name="form" method="post">
  <div align="center">
  <table width="959" height="524" border="0">
  <tr>
  <td height="37" colspan="6" align="right"><div align="center">ÇëÑ¡Ôñ
  </div>
  <label>
  <div align="center">
  <select name="aaa" id="aaa" onChange="disSel();">
  <%
  request.setCharacterEncoding("gb2312");
  String strError = null;
  String userid=(String)session.getAttribute("user");
 
   
   
  try{
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
  Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate