jsp连接SqlServer数据库
<%@ page import="javax.xml.transform.Result" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>Simple jsp page</title></head>
<body>
<%
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn= DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=liu","sa","123456");
Statement st=conn.createStatement();
ResultSet rs= st.executeQuery("select * from student");
while(rs.next())
{
out.print(" "+rs.getString(1));
out.print(" "+rs.getString(2));
}
}
catch(Exception e)
{
out.print(e.getMessage());
}
finally
{
}
%>
</body>
</html>