Formatting code for JavaJSP
{{parent page="HomePage"}}
==[[JspLucene Lucene full-text search]]==
==A fairly simple database read JSP using JTDS driver==
%%(jsp)
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C/DTD HTML 4.01 Trasitional//EN">
<html>
<head><title>DataPipe Test page</title></head>
<body>
<%
Connection conn = null;
ResultSet rs = null;
Statement stm = null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://1.2.3.4/MyDB","user","pwd");
stm = conn.createStatement();
rs = stm.executeQuery("SELECT * from DataPipe");
rs.next();
out.print(rs.getString(1));
rs.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
%%
==[[JspLucene Lucene full-text search]]==
==A fairly simple database read JSP using JTDS driver==
%%(jsp)
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C/DTD HTML 4.01 Trasitional//EN">
<html>
<head><title>DataPipe Test page</title></head>
<body>
<%
Connection conn = null;
ResultSet rs = null;
Statement stm = null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://1.2.3.4/MyDB","user","pwd");
stm = conn.createStatement();
rs = stm.executeQuery("SELECT * from DataPipe");
rs.next();
out.print(rs.getString(1));
rs.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
%%
