Here shows you JSP sample of dynamic web scroller created from a mysql database or a mssqlserver database. Here we take the scroller created from a mysql database as an example.

Part 1: Sample Instruction

To create a dynamic web scroller from database, you can input some condition clauses using either ASP, JSP, PHP, ASP.NET, ColdFusion or JavaScript language, that is, to input the Prefix or Suffix for a scroller item in the Condition Panel.

The illustration of the web scroller on the web server that supports JSP (Java Server Pages) will be like below:

Part 2: Steps

The following are the steps of this example:

(Before creating the web scroller, you should make a database "sc_jsp" (from "mysql.sql") containing the information of the product categories and the specific products.)

1. Create a scroller included one item. Enter Global > General panel and set the item's image area width and height. You'd better maintain aspect ratio of the original image. For example, here we set the item's image area width as 70 and image area height as 138 .
   
   
   


2. Enter Item panel, select "HTML" and input <%=sName%> in the context box. Input <%=sImage%> in image field. Then input <%=sLink%> in link field.
   
   
   


3. Enter Popup Tip Panel, select "HTML" and input <%=sDesc%> in the context box.
   
   
   


4. Enter Condition Panel and input the prefix and suffix for the item.
   
   
   
   

   Note: when you add the condition, you may get a warning message in Sothink JavaScript Web Scroller. That's because the condition code is server-side code which can not be processed by the browser directly. The warning will not show when you add the scroller to an ASP page that is supported by server. You can uncheck "Preview > Enable Auto-Refresh" to avoid seeing the warnings.
   
   Tips: To prevent this error popping up, you can add the JavaScript comment delimiters /* and */ to the Prefix as well as Suffix. In that way the preview ignores the extra code and the code works well on the server side processing.
   
   For example:
   Prefix:
   /*
   <%@ page import="java.sql.*"%>
   <%@ page import="net.sourceforge.jtds.jdbc.Driver"%>
   <%@ page contentType="text/html; charset=utf-8" %>
   <%
   Connection conn;
   Class.forName("com.mysql.jdbc.Driver");
   DriverManager.registerDriver(new Driver());
   
   
   conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/sc_jsp","root","123");
   Statement stmt = conn.createStatement(1004, 1007);
   ResultSet rs = stmt.executeQuery("select * from product");
   while(rs.next()){
   String sName = rs.getString("product_name");
   String sDesc = rs.getString("product_summary")+"";
   //sDesc=//sDesc.replace(/\r\n/g,"\\r\\n");
   String sLink = rs.getString("link");
   String sImage=rs.getString("image_path");
   
   %>
   */
   
   Suffix:
   /*
   <%
   }
   rs.close();rs=null;
   stmt.close();stmt=null;
   conn.close();conn=null;
   %>
   */

5. Publish the scroller as scroller_js_mysql.jsp.