Revision [1786]

Last edited on 2008-07-02 08:11:40 by WikiAdmin
Additions:
==[[JspLucene Lucene full-text search]]==
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();
}
Deletions:
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();
}

Revision [1071]

Edited on 2007-10-17 21:33:16 by WikiAdmin
Additions:
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://1.2.3.4/MyDB","user","pwd");
Deletions:
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://206.188.24.236/DataPipe","datapipe","dp2007db");

Revision [1070]

The oldest known version of this page was created on 2007-10-17 21:32:35 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki