<!--
<link rel= "stylesheet " type= "text/css " href= "styles.css ">
-->
</head>
<body>
<%
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test ";
String user= "sa ";
String password= " ";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql= "select * from test ";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
out.println( " <table> ");
out.println( " <tr> ");
out.println( " <td> "+rs.getString( "id ")+ " </td> ");
out.println( " <td> "+rs.getString( "password ")+ " </td> ");
out.println( " </tr> ");
out.println( " </table> ");
}
out.print( "数据库操作成功,恭喜你 ");
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
------解决方案--------------------直连的三个.jar文件加到工程里了么?
------解决方案--------------------sqlserver JDBC驱动包的问题,你看你有没有放再lib目录下
------解决方案--------------------最好别用微软的那个jdbc啊 很垃圾的
------解决方案--------------------你到这里去下个补丁(sql2ksp4)http://www.itmhu.cn/soft/8/80/2007/200702132586.html
记住解压了要安装才可以.