{{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.*" %> DataPipe Test page <% 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(); } %> %%