可是,我都加进去了,但是还是捕获了异外。
代码如下:
我的数据库名为:monkey;
用户名为sa,密码为how;
表名为:user;
里面有字段username,password;
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
String address="jdbc:microsoft:sqlserver://127.0.0.1:1433";
String user="sa";
String passwd="how";
String database="monkey";
DatabaseMetaData conMD=null;
java.sql.Statement stmt=null;
Connection con=null;
ResultSet sqlRst=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(address,user,passwd);
conMD=con.getMetaData();
con.setCatalog(database);stmt=con.createStatement();
sqlRst=stmt.executeQuery("SELECT * FROM user");
out.print("stmt OK");while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("username") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("password") + "</p>");
}
}
catch(Exception gr)
{
out.print("stmt ERROR");
}
%>
代码如下:
我的数据库名为:monkey;
用户名为sa,密码为how;
表名为:user;
里面有字段username,password;
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
String address="jdbc:microsoft:sqlserver://127.0.0.1:1433";
String user="sa";
String passwd="how";
String database="monkey";
DatabaseMetaData conMD=null;
java.sql.Statement stmt=null;
Connection con=null;
ResultSet sqlRst=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(address,user,passwd);
conMD=con.getMetaData();
con.setCatalog(database);stmt=con.createStatement();
sqlRst=stmt.executeQuery("SELECT * FROM user");
out.print("stmt OK");while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("username") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("password") + "</p>");
}
}
catch(Exception gr)
{
out.print("stmt ERROR");
}
%>
实验:
conn=DriverManager.getConnection("jdbc:sqlserver://myname:1433;user=sa;password=sa;DatabaseName=YOURDB");你捕获到什么错误了?
可我的驱动装得是正确的.而且在classpath里都设了。