:: Forum >> Version 1 >>

JSP Example?

Is there an example showing how to display a Grid from within a JSP? I ask because I don't see anything displayed in my JSP. If I place the script statements inside an html page it does display properly.
Jerry
Tuesday, May 24, 2005
I found the solution in this forum. It was related to a table with a grid inside of it.
Jerry
Tuesday, May 24, 2005
I am desing webpage which use JSP, I have a example about JSP for you.

<%@ page  language="java" import="java.sql.*"  %>
<
html>
<
head>
<
title>Untitled Document</title>
<
meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<
link href="control/runtime/styles/xp/grid.css" rel="stylesheet" type="text/css" >
<
script src="control/runtime/lib/grid.js"></script>
<
script src="control/patches/paging1.js"></script>
<
style type="text/css">
<!--
        .
active-controls-grid {height:80%; width:100%; font:ArialHelveticasans-serifbackground:background-color:#FFFFFF;}
        .
active-column-{width:40pttext-align:centerbackground-color:#FFFFCC;}
        .
active-column-{width110ptbackground-color:#CCFFFF;}
        .
active-column-{width60pttext-align:centerbackground-color:#FFFFCC;}        
        .
active-column-{width100pttext-align:centerbackground-color:#CCFFFF;}
        .
active-column-{width100pt;}        
        .
active-column-{width100pttext-align:centerbackground-color:#CCFFFF;}
        .
active-grid-column {border-right1px solid black;}
        .
active-grid-row {border-bottom1px solid black;}
        .
active-templates-header{font-weight:boldcolor:greentext-align:center;}        
-->
</
style>
</
head>
<%
    
try{
        Class.
forName("com.mysql.jdbc.Driver");//connect driver
    
}
    
catch(ClassNotFoundException ce){
        
out.print(ce.getMessage());
    }
%>
<
body>
<%
    
boolean flag false;
    
String datagrid "var myData=[\n";
                
String sConnect "jdbc:mysql://localhost/YourDB";//I am using MySQL database
                
String sUserName ""//you define ex: "root"
                
String sPassword="";//you define ex: "1234567".. ect 
    
try{
        
Connection connect DriverManager.getConnection(sConnectsUserNamsPassword);
        
ResultSet rs null;
        
Statement st connect.createStatement();
        
rs st.executeQuery("SELECT * FROM YOURTABLE");
        while(
rs.next()){
            if(!
flag){
                
flag true;
                
datagrid += "[\""+rs.getInt(1)+"\",\""+rs.getString(2)+"\",\""+rs.getString(3)+"\",\""+rs.getString(4)+"\",\""+rs.getString(5)+"\",\""+rs.getString(6)+"\"]\n";
            }
            else{
                
datagrid += ",[\""+rs.getInt(1)+"\",\""+rs.getString(2)+"\",\""+rs.getString(3)+"\",\""+rs.getString(4)+"\",\""+rs.getString(5)+"\",\""+rs.getString(6)+"\"]\n";
            }
        }
        
datagrid += "];\n";
        
rs.close();
        
st.close();
        
connect.close();
    }
    
catch(SQLException se){
        
out.print(se.getMessage());
    }
%>
<
script>
var 
myTitle=["Column 1""Column 2""Column 3""Column 4""Column 5""Column 6"];
<%=
datagrid %>

var 
obj = new Active.Controls.Grid;
var 
row = new Active.Templates.Row//add double click event
row.setEvent("ondblclick", function(){this.action("myAction")}); 
obj.setTemplate("row"row); 
obj.setModel("row", new Active.Rows.Page);
obj.setColumnHeaderHeight(25);    
obj.setProperty("row/count"myData.length-1);//(myData.length-1) is total rows
obj.setProperty("column/count"6);
obj.setProperty("data/text", function(ij){return myData[i][j]});
obj.setProperty("column/texts"myTitle);
obj.setProperty("row/pageSize"25);

document.write(obj);
</
script>
</
body>
</
html>
  
Ns.Thinh (VietNam)
Friday, December 16, 2005


hi,

I used this codings. But I got output only undefined.
Why it is coming like this? What should i do?

If anybody find this solution, Plz send me to the following id:
padhmini83@yahoo.co.in
Padmini
Wednesday, March 15, 2006
Hi frnds actaully im creating one apllication form,i want to add image and i want 2 make it somewat attractive..........can u help me plz

my mail id is s1c9o8r4p2i7o@gmail.com
Niveda.
Friday, October 6, 2006
Hi, can we use 2 dimensional arrays(String[row][col]) for the grid control?
Would really appreciate it if anyone can post a sample.

Thank you.

123 
dos
Sunday, October 8, 2006



This topic is archived.

Back to support forum

Forum search