test.jsp

网上书店购物系统

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.util.*,java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:bookshoplk","sa","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
%>
<%
if(conn!=null)
out.println("connect");
else
out.println(" not connect");
rs=stmt.executeQuery("select count(*) from userinfo ");
rs.next();
out.println("count="+rs.getString(1));

rs=stmt.executeQuery("select * from userinfo ");
while(rs.next()){
out.println("userid="+rs.getString("userid"));
}
%>