注意这里的URL和fornamel 里面的内容,注意SQLserver2008 2005和2000的写法区别!!网上的误导为很多!!!
<%@ page language="java" contentType="text/html;charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;chatset=GB18030">
<title>My JSP 'MyJsp.jsp' starting page</title>
</head>
<body>
<%Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433; DatabaseName=test";
String user="sa";
String password="123";
Connection conn=DriverManager.getConnection(url,user,password);
System.out.println(conn);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from login ";
System.out.println(sql);
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) { %>
您的用户名为:<%=rs.getString(1) %> <br>
您的密码为:<%=rs.getString(2) %> <br>
<%} %>
<%out.print("数据库操作成功"); %>
<%rs.close();
stmt.close();
conn.close();
%>
This is my JSP page.<br>qilei <br>
</body>
</html>