jdbc - Display/Track/Delete Mysql Rows via JSP pages -
im having following problem:
i have made web application runs on apache tomcat.
im using mysql database backend database application. application provides gui entering rows,updating , deleting them
the problem this, when insert new row in database using mysql database interface (by passing sql query directly), can manipulate rows jsp pages (delete,select,update)
however if enter new row in database using jsp page (jdbc connection), row entered ,however im unable delete/select/update columns
no errors displayed. can kindly point out why happening? , how resolve this?
thanks
here code jdbc connection use insert row in mysql database. <%@page import="java.io.*"%> <%@ page import="java.sql.*" %> <% connection connection = null; statement st = null; resultset rs = null; %> <html> <head><link href="style.css" rel ="stylesheet" type="text/css"></head> <body bgcolor="white" > <div id="container"> <div id="header"> <img src="logo.jpg"> <div class ="horiztext"><p> order tracker</p></div> </div> </div> <br> <img src="banner.jpg" width="1500 " height="5"><br> <% if(session.getattribute("username") !=null) { %> <div id="navbar"> <ul> <li><a href="newoder.jsp">new order</a></li> <li><a href="updateorder.jsp">update order</a></li> <li><a href="trackorder.jsp">track order</a></li> <li><a href="trackdelay.jsp">track delay</a></li> <li><a href="vieworder.jsp">view database</a></li> <li><a href="delete.jsp">delete order</a></li> <li><a href="logout.jsp">logout</a></li> </ul> </div> <br> <% string sno=request.getparameter("sno"); string productname=request.getparameter("productname"); string producttype=request.getparameter("producttype"); string model=request.getparameter("model"); string make=request.getparameter("make"); string licensevoucher=request.getparameter("licensevoucher"); string location=request.getparameter("location"); %> <br> <div align="center"><font size="6" color="black"> <br> <% try { class.forname("com.mysql.jdbc.driver").newinstance(); connection=drivermanager.getconnection("jdbc:mysql://localhost:3307/test","root" ,"root"); st = connection.createstatement(); string query="insert inventory values (' "+sno+" ',' "+productname+" ','"+producttype+" ',' "+model+" ',' "+make+" ',' "+licensevoucher+" ',' "+location+" ')"; st.execute(query); out.println("data inserted"); } catch(exception e) { out.println("data not inserted"); } %> </font></div> <% } else { %> not logged in click here <a href="eric.jsp"><b>login</b></a> <% } %> </body> </html>
the straightforward way have found manipulate sql jsp use tag library:
<%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <sql:setdatasource var="snapshot" driver="com.mysql.jdbc.driver" url="jdbc:mysql://localhost/test" user="user_id" password="mypassword"/> <sql:query datasource="${snapshot}" var="result"> select * employees; </sql:query> <table border="1" width="100%"> <tr> <th>emp id</th> <th>first name</th> <th>last name</th> <th>age</th> </tr> <c:foreach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td> </tr> </c:foreach> </table> <sql:update datasource="${snapshot}" var="count"> insert employees values (104, 2, 'nuha', 'ali'); </sql:update> let me know how on...
Comments
Post a Comment