| File: | /mysql.jsp |
| Permissions: | 0640 |
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page contentType="text/html; charset=Windows-1251"%>
<%
String home = "/users/e/x/example.inc.ru";
String title = "mysql.jsp пример";
FileInputStream iF = new FileInputStream(home+"/etc/mysql.password");
BufferedReader bR = new BufferedReader(new InputStreamReader(iF));
String password = bR.readLine();
iF.close();
try {
/* connect (commented out strings use classic MySQL driver) */
// Class.forName("org.gjt.mm.mysql.Driver");
Class.forName("com.caucho.jdbc.mysql.Driver");
// Connection con = DriverManager.getConnection("jdbc:mysql://localhost/db00047345", "00047345", password);
Connection con = DriverManager.getConnection("jdbc:mysql_caucho://localhost/db00047345", "00047345", password);
Statement st = con.createStatement();
/* do query */
ResultSet rs = st.executeQuery("select * from example");
%>
<HTML>
<HEAD>
<TITLE><%= title %></TITLE>
</HEAD>
<BODY>
<H1><%= title %></H1>
<TABLE>
<TR><% for(int i=1;i<=rs.getMetaData().getColumnCount();i++){ %><TD><%= rs.getMetaData().getColumnName(i) %></TD><% } %></TR>
<% while (rs.next()) { %>
<TR><% for(int i=1;i<=rs.getMetaData().getColumnCount();i++){ %><TD><%= new String(rs.getString(i).getBytes("ISO-8859-1"),"Cp1251") %></TD><% } %></TR>
<% } %>
</TABLE>
<%
rs.close();
st.close();
} catch (Exception e) {
throw (new ServletException(e));
}
%>
</BODY>
</HTML>
www.Net.ru - веб хостинг и регистрация доменов - web-hosting and domain registration