Hi am new to java. i need to create a dynamic web application. Am using eclipse IDE and Apache tomcat server. i need to create a tool. Someone please kindly help me out and post your code for my following problem. My Project requirement is as follows: I have a table in batchlogs.mdb in MS Access Database. the table structure is Sno JobName ProgramName Problem Resolution. 1 bs001 abcd01 program got abended with 803 error illegal operation check data
And i have a jsp file which contains a textbox, name issuedescription. when user types in their issues in the textbox and click the submit button it should search in the database fields JobName, ProgramName and Problem whether any single match is found for the value in text box and if found it should retrieve the corresponding Solution field from database and display in the textbox of the jsp.
1)checkid.jsp:
<%@page import="java.sql.*"%>
<html>
<head>
<script type="text/javascript">
function showData(){
xmlHttp=GetXmlHttpObject()
var id=document.getElementById("id").value;
var url="id.jsp";
url=url+"?id="+id;
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null);
}
function stateChanged(){
if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
var showdata = xmlHttp.responseText;
var strar = showdata.split(":");
if(strar.length>1){
var strname = strar[1];
document.getElementById("type").value= strar[1];
document.getElementById("price").value= strar[2];
}
}
}
function GetXmlHttpObject(){
var xmlHttp=null;
try{
xmlHttp=new XMLHttpRequest();
}
catch(e){
try{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e){
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
</head>
<body>
<br><br>
<table >
<tr><td>ID:</td><td><input type="text" id="id" name="id" onkeyup="showData();"></td></tr>
<tr><td>Product Type:</td><td><input type="text" id="type" name="name"></td></tr>
<tr><td>Price:</td><td><input type="text" id="price" name="address"></td></tr>
</table>
</body>
</html>
2)id.jsp:
<%@ page import="java.sql.*" %>
<%
String id = request.getParameter("id").toString();
System.out.println(id);
String data ="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from item where itemid='"+id+"'");
while(rs.next())
{
data = ":" + rs.getString("item") + ": " + rs.getString("price");
}
out.println(data);
System.out.println(data);
}
catch(Exception e) {
System.out.println(e);
}
%>