《MSSQLjsp文件测试.docx》由会员分享,可在线阅读,更多相关《MSSQLjsp文件测试.docx(3页珍藏版)》请在三一办公上搜索。
1、MSSQLjsp文件测试<% page language=java contentType=text/html; charset=UTF-8pageEncoding=UTF-8 import=java.sql.*%><!DOCTYPE html PUBLIC -/W3C/DTD HTML 4.01 Transitional/EN http:/www.w3.org/TR/html4/loose.dtd><html><head><meta http-equiv=Content-Type content=text/html; charset=UTF-8><
2、title>jdbc test</title></head><body><h2>用户信息</h2><%Connection conn = null;Statement stat = null;ResultSet rs = null;Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);String url = jdbc:sqlserver:/localhost:1433;DatabaseName=student;String user = sa;String passwords =
3、 123456;conn = DriverManager.getConnection(url,user,passwords);stat = conn.createStatement;String sql = select * from users;rs = stat.executeQuery(sql);%><table width=90% border=1 align=center cellspacing=1><tr><td>编号:</td><td>用户名:</td><td>密码:</td><td>性别:</td&
4、gt<td>E-mail:</td><td>熟练的开发语言:</td></tr><%while(rs.next)out.print(<tr>);out.println(<td>+rs.getString(id)+</td>);out.println(<td>+rs.getString(username)+</td>);out.println(<td>+rs.getString(passwords)+</td>);out.println(<td>+rs.getString(sex)+</td>);out.println(<td>+rs.getString(email)+</td>);out.println(<td>+rs.getString(lan)+</td>);out.print(</tr>);rs.close;stat.close;conn.close;%></table></body></html>