import java.net.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ServletConnect extends HttpServlet
  {
   public void service(ServletRequest rq,ServletResponse rp) throws ServletException,IOException
     {
      Connection con = null;    //定義數據庫連接對象
      Statement stmt = null;    //定義數據庫聲明對象
      ResultSet rset = null;    //定義記錄結果集對象
      String sSQLCmd = null;    //存放T-SQL語句
      String Recordset1 = null; 
      String Recordset2 = null;
      String Recordset3 = null;
      String ResponseStr = null;
      String ResponseStr_chs = null;
      rp.setContentType("text/html");   //定義反饋信息的輸出格式
      ServletOutputStream out = rp.getOutputStream(); //定義輸出流對象
      
      sSQLCmd = rq.getParameter("ssqlcmd");

      if (sSQLCmd == null || sSQLCmd.length() < 1)
        {
         /* 如果前天提交的查詢命令有錯誤，則返回error */
         out.print("error");
        }
      else
        {
         /* 開始查詢，并將查詢結果反饋給前臺的Applet */
         try
           {
            /* 利用JDBC-ODBC橋建立數據庫連接 */
            DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
            con = DriverManager.getConnection("jdbc:odbc:DemoDB","demo","demo");
            stmt = con.createStatement ();
            rset = stmt.executeQuery (sSQLCmd);

            while(rset.next())
              {
               Recordset1 = rset.getString(1); 
               Recordset2 = rset.getString(2);
               Recordset3 = rset.getString(3);
               Recordset1 = (Recordset1 == null) ? "不限" : Recordset1;
               Recordset2 = (Recordset2 == null) ? "不限" : Recordset2;
               Recordset3 = (Recordset3 == null) ? "不限" : Recordset3;
               ResponseStr = Recordset1 + "," + Recordset2 + "," + Recordset3;
               ResponseStr_chs = new String(ResponseStr.getBytes("iso-8859-1"));   //轉換中文字符
               System.out.print("<" + ResponseStr + "> ... ");
               out.print(ResponseStr_chs);
               System.out.print("... has been sent.\n");
              }
            rset.close();
            con.close();
           }

         catch(SQLException e)
           {
            System.out.println("!程序在運行是出現例外：" + e.toString());
           }
        }
     }
  }