Connect To SQL Express Database

Category: ASP

Connect To SQL Express

<%@ page import="java.sql.*" %>
<% String connectionUrl = "jdbc:sqlserver://localhostSQLEXPRESS;databaseName=[database;"; Connection connection = null; Statement statement = null; ResultSet rs = null; %>

<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
connection = DriverManager.getConnection(connectionUrl, "[username", "[password");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT [field FROM [table");

while (rs.next()) {
out.println(rs.getString("[field")+"
");
}

rs.close();
%>

JSP