JSP连接Sql Server数据库示例，jspsqlserver示例,<%@ page con
分享于 点击 39797 次 点评：203
JSP连接Sql Server数据库示例，jspsqlserver示例,<%@ page con
<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html> <body> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") .newInstance(); String url = "jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user = "sa"; String password = ""; Connection conn = DriverManager.getConnection(url, user, password); Statement stmt = conn .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from test"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { %> 您的第一个字段内容为：<%=rs.getString(1)%> 您的第二个字段内容为：<%=rs.getString(2)%> <% } %> <% out.print("数据库操作成功，恭喜你"); %> <% rs.close(); stmt.close(); conn.close(); %> </body></html>
用户点评