如何将selectItem变量放入:
var e = document.getElementById("categoryName");
var selectItem = e.options[e.selectedIndex].text;在:
var theData = [ // Start of JavaScript data object
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/pyramid", "root", "test");
PreparedStatement ps = con.prepareStatement("SELECT timeStamp, value FROM status WHERE idCategory = (SELECT idCategory FROM category WHERE name =' " SELECTITEMVARIABLE " ')");在前面提到的SELECTITEMVARIABLE语句中,我如何使用javascript中的selectItem?很抱歉我的英语不好,谢谢!
发布于 2013-06-18 21:24:11
您需要将客户端值传递给服务器(通过POST),从请求参数中读取它,然后将其附加到SQL。
https://stackoverflow.com/questions/17170004
复制相似问题