Please help me to modify my java code from php code

i want to covert this php code int java/JSP .

if (isset($_POST['orders'])) {

$orders = explode('&', $_POST['orders']);
$array = array();

foreach($orders as $item) {
    $item = explode('=', $item);
    $item = explode('_', $item[1]);
    $array[] = $item[1];
}

} I tried like this (see below JSP code) ... but this is not giving me the exact result as the above PHP code is giving. So please help me to convert it into Java.

if (request.getParameter("orders") != null) { String item = request.getParameter("orders"); System.out.println("oRDERS...."+item);

String[] arr = item.split("\\=");
item.split("\\_");

System.out.println("Length of Array is :" + arr.length);

for (int i = 0; i < arr.length; i++) {
     System.out.println("array " + i + ":" + arr[i]);
}

} else { System.out.println("NOT SET"); }

View Answers

April 2, 2012 at 11:42 AM

We are providing you the code where we have specified only three fields bookid,author and title in the database. Follow these steps to update these fields:

1) Create book.jsp

    <%@page import="java.sql.*"%>

    <form name=myname method=post action="edit.jsp">
    <table border="1">
    <tr><td></td>
    <td><b><u>bookid</u></b></td>
    <td><b><u>Author</u></b></td>
    <td><b><u>title</u></b></td>
    </tr>
    <%try{

    Connection conn = null;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");
    ResultSet rs = null;
    Statement st=null;
    st=conn.createStatement();
    rs = st.executeQuery("select * from book");
    int i=0; while(rs.next()){ %>
    <tr><td><input type="checkbox" name="check<%=i%>" value=<%= rs.getString("bookid") %>></td>
    <td><%= rs.getString("bookid") %></td>
    <td><%= rs.getString("author") %></td>
    <td><%= rs.getString("title") %></td>
    </tr><%
    i++;
    }
%>
<input type="hidden" name="value" value="<%=i%>">
<%
    }catch(SQLException e){ System.out.println(e.getMessage()); } %>
    </table>
    <input type="submit">
    </form>

2) Create edit.jsp

    <%@page import="java.sql.*"%>

    <%
String v=request.getParameter("value");
String id[]= new String[Integer.parseInt(v)];
    for(int i=0;i<10;i++){
    id[i]=request.getParameter("check"+i);
    out.println(id[i]);
    }
    %>

    <form name=myname method=post action="update.jsp">
    <table border="1">
    <tr>
    <td><b><u>bookid</u></b></td>
    <td><b><u>Author</u></b></td>
    <td><b><u>title</u></b></td>
    </tr>
    <%try{

    Connection conn = null;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");
    ResultSet rs = null;
    Statement st=null;
    st=conn.createStatement();
    for(int a=0;a<10;a++){
    rs = st.executeQuery("select * from book where bookid='"+id[a]+"'");
    while(rs.next()){ %>
    <tr>
    <td><input type="text" name="bid" value="<%= rs.getString("bookid") %>"></td>
    <td><input type="text" name="auth" value="<%= rs.getString("author") %>"></td>
    <td><input type="text" name="tit" value="<%= rs.getString("title") %>"></td>
    </tr><%
    }
    }
    }catch(SQLException e){ System.out.println(e.getMessage()); } %>
    </table>

    <input type="submit">

April 2, 2012 at 11:43 AM

continue..

3)Create update.jsp

<%@page import="java.sql.*"%>
<%
String d[] =request.getParameterValues("bid");
if(d !=null) {
for(int i=0;i<d.length;i++) {
out.println(d[i]);
}
}
String name[] =request.getParameterValues("auth");
if(name !=null) {
for(int i=0;i<name.length;i++) {
out.println(name[i]);
}
}
String title[] =request.getParameterValues("tit");
if(title !=null) {
for(int i=0;i<title.length;i++) {
out.println(title[i]);
}
}
%>
<%
try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");

Statement st=null;
st=conn.createStatement();
for(int a=0;a<10;a++){
String book_id=d[a];
String author=name[a];
String tit=title[a];
st.executeUpdate("update book set author='"+author+"', title='"+tit+"' where bookid='"+book_id+"'");
}
}
catch(Exception e){
e.printStackTrace();
}
%>

April 4, 2012 at 8:51 AM

Thank you , But this not my exact solution for my problem. What actually i want to do is "i want to order my table rows, users drag and drop the rows in the browser and same order should be stored in my books table(database) in the order column. So that when they refresh the page their order should be remain same, as they alter it before. Please help me on this topic "how to order rows?"

Ads