package test;
import java.sql.*;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class XianServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, java.io.IOException {
                response.setContentType("application/html; charset=GB2312");
               	java.io.PrintWriter out = response.getWriter();
                String id=request.getParameter("key");
                 try{
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
		Connection con = DriverManager.getConnection("jdbc:odbc:gBook");	
                Statement stmt = con.createStatement();
                String sql="select * from data where id="+id;
                ResultSet rs=stmt.executeQuery(sql);
                String s="";
                while(rs.next()){
                     s+="留言主題："+rs.getString("title")+"\n";
                     s+="留言作者："+rs.getString("author")+"\n";
                     s+="留言內容："+rs.getString("content")+"\n";
                     s+="留言日期："+rs.getDate("date");
                  }
                System.out.println(sql);
                  out.print(s);
                  }
                catch(Exception e){
                    e.printStackTrace();
                 }
                
	}
}