Ignatius88

Is it necessary to include servlet and Jsp in class diagram? Is there any tutorial for this? I am just wondering for I have never drawn any UML diagram for web apps. I have been searching and found out that <<sterotype>> thing but nothing says how to present them in …

[CODE]<script type="text/javascript"> function insertPreference() { var row = document.getElementById('voteTable').rows[0]; var cell = row.cells; var id = cell[0].innerHTML; var title = cell[1].innerHTML; alert(id); alert(title); } </script> <table id="voteTable" border="1"> <tr> <td id="id">3</td> <td id="title">This is an example of storing the table value into a database.</td> <td id="vote"> <input type="radio" name="yesorno" value="true" …

[CODE]SELECT movie_id, movie_title, movie_release_year, movie_genre, movie_plot, (SELECT AVG(sum_movie_rate) FROM (SELECT SUM(movie_rate) AS sum_movie_rate FROM user_movie_rate WHERE movie_id = ?) AS t1) AS average_rating FROM movie WHERE movie_id = ?[/CODE] when I retrieve a specific information of a movie, I want to calculate the average ratings of the movie. user_movie_rate looks …

[CODE] pstmt = conn.prepareStatement("INSERT INTO tableA (userid, itemid) VALUES (?, ?) ON DUPLICATE KEY UPDATE value = ?"); pstmt.setString(1, userid); pstmt.setString(2, itemid); pstmt.setString(3, value); pstmt.executeUpdate(); [/CODE] This code works [CODE] pstmt = conn.prepareStatement("INSERT INTO tableA (userid, itemid) VALUES ((SELECT userid FROM user WHERE userid = ?), ?) ON DUPLICATE KEY …

[CODE]document.getElementById('login').innerHTML += '<p><a href = "/<Project name>/<Servlet name>" onclick="sendRequest("/<Project name>/<Servlet name>", "uid=' + FB.getSession().uid + '", AJAXresult, "post")">Recommend me a movie!</a></p>';[/CODE] The code above works fine outside of the innerHTML. Is there something wrong with the code above?

Is there a way that if I click on a radio button, it inserts its value to database? [CODE]<form name = "data" method = "post" action = "JSP/insert.jsp"> <p> <font size = "4"> Rate: 1<input name="radio_rate" type="radio" value="1" onclick="return validate()"/> 2<input name="radio_rate" type="radio" value="2" onclick="return validate()"/> 3<input name="radio_rate" type="radio" value="3" …

[CODE] <script> var xhr = null; function createRequest() { if(window.ActiveXObject) { xhr = new ActiveXObject("Microsoft.XMLHTTP"); } else { xhr = new XMLHttpRequest(); } } function sendRequest(url, param, callback, method) { createRequest(); var httpMethod = (method!='POST' && method!='post') ? 'GET' : 'POST'; var httpParam = (param==null || param=='') ? null : …

[CODE]UPDATE movie_temp SET movie_release_year = ( substring_index(movie_title,')',1) ) WHERE movie_title IN (SELECT * FROM (SELECT movie_title FROM movie_temp) AS TEMP); [/CODE] When executing the above query (movie_temp table has more than 660,000 rows), after 600 seconds workbench throws me errors Error Code: 2013Lost connection to MySQL server during query followed …

I have been searching for ways to do this but I was not able to find any. What I want to do is this: movie_genre (Table) movidId movieTitle movieGenre (Varchar) 1 Copying Beethoven (2006) Biography 2 Copying Beethoven (2006) Drama 3 Copying Beethoven (2006) Music movie_plot (Table) movieId movieTitle moviePlot …