<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="data","sa","123456");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from student");
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+rs.getInt("num")+"</td>");
out.println("<td>"+rs.getString("name")+"</td>");
out.println("<td>"+rs.getInt("age")+"</td>");
out.println("<td>"+rs.getString("fromw")+"</td>");
out.println("<td>"+rs.getString("school")+"</td>");
out.println("<td>"+rs.getString("major")+"</td>");
out.println("<td>"+rs.getInt("score")+"</td>");
out.println("</tr>");
out.println("</tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有