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

Linkide Haldamine

"); try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection cn = DriverManager.getConnection( "jdbc:mysql://127.0.0.1/if21", "if21", "ke+88lla"); Statement st=cn.createStatement(); if(kysimus.getParameter("lisamine")!=null){ PreparedStatement ps=cn.prepareStatement( "INSERT INTO andmetabel (kirjeldus, link) VALUES (?, ?)" ); ps.setString(1, kysimus.getParameter("kirjeldus")); ps.setString(2, kysimus.getParameter("link")); ps.executeUpdate(); } String sort="id"; String sortTulp=kysimus.getParameter("sorttulp"); if(sortTulp==null){sortTulp="id";} if(sortTulp.equals("kirjeldus")){sort="kirjeldus";} if(sortTulp.equals("link")){sort="link";} String lause="SELECT id, kirjeldus, link FROM andmetabel ORDER BY "+sort; ResultSet rs=st.executeQuery(lause); valja.println(""); valja.println(""+ ""+ ""+ ""+ ""); while(rs.next()){ valja.println(""); } valja.println("
KirjeldusLink
"+ (rs.getString("kirjeldus"))+ ""+ (rs.getString("link"))+ ""+ "muuda"+ ""+ "kustuta"+ "
"); valja.println("

Lisamine

"); valja.println( "
"+ ""+ "\n"+ "\n"+ "
Kirjeldus:"+ "
Link:"+ "
"+ ""+ "
"+ "TAGASI"+ "
" ); cn.close(); valja.println("
"); valja.println(""); valja.println(""); }catch(Exception viga){ viga.printStackTrace(valja); } } }