Forums:

error while trying to access javascript from a java class

Greenhorn

Posts: 12

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi!!

i hava a javascript file that looks like this

and i am trying to call it in my dabmanager class using the following code:

but when i reun it i get thi error: java.lang.NoSuchMethodException: No such function getid()

please help me out guys i can't seem to get hwere the problem is.
Thanks!!

Rob Spoor

Sheriff

Posts: 22907

132

I like...

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The name of the function is getid, not getid(). If I remove the () I get another exception, about document not being defined. That makes sense because that's a browser defined variable. How can you get the document and an element if the JavaScript is not executed on a web page?

SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions

Akash Thadani

Greenhorn

Posts: 12

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I removed () and am getting the same error as Rob is getting can anybody help me find a solution to this please!!

Akash Thadani

Greenhorn

Posts: 12

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

is there any other way to do what i am trying to do.. i read about web engines and i found this sample code :

Can someone tell me if i can use this and tell me what changes do i need to make?? Please i really need this to be done and can't seem to figure a way out!!

Rob Spoor

Sheriff

Posts: 22907

132

I like...

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Could you first tell us what you're trying to accomplish? Once we know the "what" we can find the "how".

SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions

Akash Thadani

Greenhorn

Posts: 12

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i have a marks.jsp page which contains a marks form. the id select box is populated by data from the database. i want that on selection of a particular id the name corresponding to the id populates the name feild. that is all i want... i am attaching all my code here:

marks.jsp:

<%@ page import = "javax.servlet.http.HttpServlet" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import= "org.akash.java.DabManager" %>
<%@ page import= "org.akash.java.GetsSets" %>
<%@ page import= "java.sql.ResultSet" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>FILL IN YOUR MARKS HERE</title>
<script type="text/javascript" src="ValidateMark.js"></script>
</head>
<body>
<form action="MarksServlet" method="post" name="SubjectMarks" onsubmit= "return(validate());" >

<table cellpadding="2" width="20%" bgcolor="maroon" align="center"
	cellspacing="2">
	
		<tr>
			<td colspan=2>
			<center><font size=4><b>Subject Marks Form</b></font></center>
			</td>
		</tr>
		
		
		
		<tr>
			<td>ID</td>
			<td>
			<select name="identity" id= "identity">
			<%
		try {
			GetsSets sets =new GetsSets();
		ResultSet res= null;
		DabManager db= new DabManager();
		res= db.Gets();
		 while(res.next())
		 {
            Integer sid= res.getInt("id");		
		%>
		<option value="<%=sid%>" ><%=sid%></option>
		<%
		 }
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	   %>
	   </select>
			
			</td>
		</tr>

<tr>
			<td>Name</td>
			
			<%
		
			try {
			
		ResultSet resu= null;
		DabManager dab= new DabManager();
		resu= dab.Getsname();
		 while(resu.next())
		 {
            String sname= resu.getString("sname");		
		%>
		<td><input type="text" name="yourname" id="yourname" value=<%=sname %> size="30"><%=sname %></td>
		<%
		 }
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	   %>
			
		</tr>
		
		<tr>
			<td>Physics</td>
			<td><input type="text" name="Physics" id="Physics" size="10"></td>
		</tr>
		
		<tr>
			<td>Chemistry</td>
			<td><input type="text" name="Chemistry" id="Chemistry" size="10"></td>
		</tr>
		
		<tr>
			<td>Mathematics</td>
			<td><input type="text" name="Maths" id="Maths" size="10"></td>
		</tr>
		
		<tr>
			<td>Biology</td>
			<td><input type="text" name="Biology" id="Biology" size="10"></td>
		</tr>
		
		<tr>
			<td>
				<input type="reset">
			</td>
			<td colspan="2">
				<input type="submit" value="Submit Form" onclick ="confirm()"/>
			</td>
		</tr>
	</table>
</form>	
	
</body>
</html>

my marks servlet class:

package org.akash.java;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class MarksServlet
 */
@WebServlet("/MarksServlet")
public class MarksServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public MarksServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.getWriter().append("Served at: ").append(request.getContextPath());
	}

/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String id= request.getParameter("identity");
		String name= request.getParameter("yourname");
		String physics= request.getParameter("Physics");
		String chemistry= request.getParameter("Chemistry");
		String mathematics= request.getParameter("Maths");
		String bio= request.getParameter("Biology");
		
		GetsSets set = new GetsSets();
		
		set.setId(Integer.parseInt(id));
		set.setName(name);
		set.setPhy(physics);
		set.setChem(chemistry);
		set.setMath(mathematics);
		set.setBio(bio);
		
		
		try {
			DabManager.Inserts(set);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
		
		RequestDispatcher dispatcher = request.getRequestDispatcher("/index.html");
		 
		 dispatcher.forward (request, response);
	}

}

and my databae manager file:

package org.akash.java;

import java.io.IOException;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.script.Invocable;
import javax.script.ScriptEngine;
import javax.script.ScriptEngineManager;
import javax.script.ScriptException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.catalina.connector.Request;

import com.mysql.jdbc.Statement;

public class DabManager {
	
	private static Connection conn = ConnectionManager.getInstance().getConnection();
	public static void Inserts(GetsSets set) throws ClassNotFoundException, SQLException{
		
		Class.forName("com.mysql.jdbc.Driver");
	    String sql = "INSERT INTO `studentregistrationform`.`marks`(id,`name`, `physics`, `chemistry`, `maths`, `biology`) VALUES(?,?,?,?,?,?) ";	
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setLong(1, set.getId());
		pstmt.setString(2, set.getName());
		pstmt.setString(3, set.getPhy());
		pstmt.setString(4, set.getChem());
		pstmt.setString(5, set.getMath());
		pstmt.setString(6, set.getBio());
		
		pstmt.executeUpdate();
		
	}
	
	public ResultSet Gets()throws ClassNotFoundException, SQLException
	{
		Class.forName("com.mysql.jdbc.Driver");
		String sql = "SELECT id FROM `registrationform`";
		java.sql.Statement smt= conn.createStatement();
		ResultSet rs = smt.executeQuery(sql);
		
		return rs;
	}
	
	public ResultSet Getsname()throws ClassNotFoundException, SQLException
	{  
		ScriptEngineManager manager = new ScriptEngineManager();
	ScriptEngine engine = manager.getEngineByName("JavaScript");
	// read script file
	try {
		engine.eval(Files.newBufferedReader(Paths.get("C:/Users/Sony/workspace/StudentRegiForm/WebContent/ValidateMark.js"), StandardCharsets.UTF_8));
	} catch (ScriptException | IOException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}

Invocable inv = (Invocable) engine;
	// call function from script file
	Integer uid= null;
	try {
		uid = (Integer) inv.invokeFunction("getid");
	} catch (NoSuchMethodException | ScriptException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
		/*
		GetsSets sets = new GetsSets();
	    Integer uid= sets.getId();*/
		
		Class.forName("com.mysql.jdbc.Driver");
		
		 
		PreparedStatement pst=conn.prepareStatement("SELECT `sname`FROM `registrationform` WHERE id= ?");
		pst.setInt(1,uid);
	     ResultSet rs=pst.executeQuery();
		
	     return rs;
	}
}

the id is getting populated by the database properly the problem is population the name field from the database according to the id selected from the select box.

Rob Spoor

Sheriff

Posts: 22907

132

I like...

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Forget about ScriptEngine etc, you're going to need browser-side JavaScript for this. I'm moving this thread to both HTML/JavaScript and JSP.

SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions

Bear Bibeault

Sheriff

Posts: 67762

173

I like...

posted 10 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Yup, you are barking up a very wrong tree. Forget all about all of that ScriptEngine stuff -- that's not what you are after.

In fact, forget about JSP and Java for the moment too.

What you need to do is to learn how to use JavaScript in HTML pages -- because all JSP does is to specify a template for HTML pages. Your Java code won't know anything about the JavaScript executing on the browser.

The good news is that it's a lot easier to get JavaScript running on an HTML page than all that wrong direction you were headed in. All you need is <script> tags in the JSP (and, of course, to learn JavaScript).

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Akash Thadani

Greenhorn

Posts: 12

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thank you for all the help guy much appreciated!!

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.