Samples of DataJett JSP Development:

JSP Samples:

Sample System Properties JSP:

http://www.datajett.com/JSP/SysProp.jsp (Will open in new window).

========================================================

Query MySql Database Table:

JSP that Displays Employee History Table of a MySql Database on http://www.datajett.com/

Contains Java & Html within JSP.

http://www.datajett.com/JSP/DJ_EmpHist.jsp (Will open in new window).

Sample Code Below:

<%@page language="java" import="java.sql.*"%> 
<%
Driver DriverRecordset1 = (Driver)Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection Conn = DriverManager.getConnection(
"jdbc:mysql://localhost/datajett_xmb1?user=datajett_djAdm1n&password=XXXXXX");

Statement StatementRecordset1 = Conn.createStatement();
ResultSet Recordset1 = StatementRecordset1.executeQuery("select * from DJ_EH02");
out.println("<table cellpadding=2 border=1>");

while (Recordset1.next()) {
out.println("<tr>");
out.println("<td>" + Recordset1.getString(1) + "</td><td>" 
+ Recordset1.getString(2) + "</td><td>" + Recordset1.getString(3) + "</td>");
out.println("</tr>");
}
out.println("</table>");
Recordset1.close();
Conn.close();
%>

========================================================

Create MySql Database Table:

JSP that Creates Employee History Table into a MySql Database on http://www.datajett.com/

Contains Java & Html within JSP.

No sample program link provided, since it would only error (table has already been created).

Sample Code Below:

<%@page language="java" import="java.sql.*"%>
Driver DriverRecordset1 = (Driver)Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection Conn = DriverManager.getConnection(
"jdbc:mysql://localhost/datajett_xmb1?user=datajett_djAdm1n&password=XXXXXX");

Statement StRecSet = Conn.createStatement();

int Recordset01 = StRecSet.executeUpdate("create table DJ_EH02(co_nm char(50), cs_loc char(50), ft_dt char(50));");
int Recordset02 = StRecSet.executeUpdate("insert into DJ_EH02(co_nm,cs_loc,ft_dt) values('Lincoln FoodService Products','Ft Wayne, IN','04/06-11/06');");
int Recordset03 = StRecSet.executeUpdate("insert into DJ_EH02(co_nm,cs_loc,ft_dt) values('Heico Aerospace', 'Hollywood, FL', '11/05-04/06');");
int Recordset0....

StRecSet.close();
Conn.close();
%>