MySQL JSP テスト(Amber)

<%@ page contentType="text/html; charset=EUC-JP" import="java.sql.*" %> MySQL JSP テスト(Amber)

select * from aptable の実行結果;

<% Class.forName("org.gjt.mm.mysql.Driver"); Connection mydb=DriverManager.getConnection("jdbc:mysql://localhost/test","mysql","mysql"); Statement sql=mydb.createStatement(); ResultSet myrs=sql.executeQuery("select * from aptable"); while(myrs.next()){ %> <% } myrs.close(); sql.close(); mydb.close(); %>

apname	apversion	apcomment	apcount
<%=myrs.getString("apname")%>	<%=myrs.getString("apversion")%>	<%=myrs.getString("apcomment")%>	<%=myrs.getString("apcount")%>