Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%--
- Document : newjsp
- Created on : Apr 15, 2017, 1:14:17 PM
- Author : Spyweeb
- --%>
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.Statement"%>
- <%@page import="java.sql.Connection"%>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <!DOCTYPE html>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>JSP Page</title>
- <style>
- th,tr,td
- {
- font-family: Lucida Sans;
- }
- th{
- background-color: aquamarine;
- }
- </style>
- </head>
- <%!
- String driver = "oracle.jdbc.OracleDriver";
- String url = "jdbc:oracle:thin:@localhost:1521:orcl";
- String user = "hr";
- String pass = "ntic";
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- String cb_tab[];
- public Connection getCon(){
- try{
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, pass);
- }catch(Exception e){
- e.printStackTrace();
- }
- return conn;
- }
- %>
- <body>
- <%
- cb_tab = request.getParameterValues("mycb");
- String clicked = request.getParameter("delete");
- try{
- stmt = conn.createStatement();
- if(clicked != null){
- if(cb_tab !=null){
- for(int i=0; i<cb_tab.length; i++){
- rs = stmt.executeQuery("DELETE FROM persons WHERE person_id ="+cb_tab[i]);
- out.println("Deleted are :");
- out.println("<p>"+cb_tab[i]+"</p>");
- } //end for
- }else{
- out.println("<p>None</p>");
- } //end if-else
- } else {
- %>
- <%
- }
- }catch(Exception ex){
- ex.printStackTrace();
- }
- %>
- <%
- try{
- String sql = "SELECT person_id, first_name, job_title FROM persons";
- stmt = getCon().createStatement();
- rs = stmt.executeQuery(sql);
- %>
- <form name="myform" action="checkbox_jsp.jsp" method="POST">
- <div align="center">
- <table border="1" cellpadding="9" style="border-collapse: collapse">
- <tbody>
- <tr>
- <th>#</th>
- <th>First Name</th>
- <th>Job</th>
- </tr>
- <% while(rs.next()){%>
- <tr>
- <td><input type="checkbox" name="mycb" value="<%= rs.getString("person_id") %>" /></td>
- <td> <%= rs.getString("first_name") %> </td>
- <td> <%= rs.getString("job_title") %> </td>
- </tr>
- <% }%>
- </tbody>
- </table>
- <%
- }catch(Exception ex){
- ex.printStackTrace();
- }
- %>
- <br><br>
- <input type="submit" value="Delete" name="delete" />
- <br><br>
- </div>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement