KB: Connect To SQL Express Database

More...

Connect To SQL Express

<%@ page import="java.sql.*" %>
<%
String connectionUrl = "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=[database];";

Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>

<html><body>

<%
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]")+"<br>");
}

rs.close();
%>

</body></html>

Back To JSP