Kylalisteraamat

import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; public class loe extends HttpServlet{ public void doGet(HttpServletRequest kysimus, HttpServletResponse vastus) throws IOException, ServletException{ vastus.setContentType("text/plain"); PrintWriter valja=new PrintWriter(vastus.getWriter()); valja.println("Kylalisteraamat "); valja.println("

"); valja.println(" Külalisteraamat "); valja.println("

Lisa

"+ "\n"+ "\n\n"+ "

Sorteeri kirjed nime järgi \n"+ "kuupäeva järgi \n"+ "e-maili järgi

\n"+ "

\n"); valja.println(" "); valja.println("

"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn= DriverManager.getConnection("jdbc:odbc:poebaas", "", ""); Statement st=cn.createStatement(); //String lause2="DELETE FROM kylaline WHERE id='id';" ; //ResultSet rs2=st.executeQuery(lause2); String lause="SELECT id,andmed,nimi,email,kuup FROM kylaline order by "+kysimus.getParameter("sort")+";" ; if(kysimus.getParameter("sort")==null || kysimus.getParameter("sort").equals("null")){ lause="SELECT id,andmed,nimi,email,kuup FROM kylaline order by id desc"; } ResultSet rs=st.executeQuery(lause); while(rs.next()){ valja.println(" "); valja.println(rs.getString("andmed")); valja.println("
Kirje lisas :"+rs.getString("nimi")+" "+rs.getString("kuup")); valja.println("
E-mail : "+("email")+" "); valja.println("
Kustuta kirje \n
" ); valja.println("
"); valja.println("

"); } }catch(Exception viga){ valja.println("probleem andmebaasiga: " +viga); } } }