select * from T_TEST where T1='001' sql server里有大小写区别吗
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用 户 '.' 登录失败。原因: 未与信任 SQL Server 连接相关联。 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source ) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
检查你的驱动程序和上面这句话,可能是没连接上。
sql server里有大小写区别吗
户 '.' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
ClassNotFoundException, InstantiationException, IllegalAccessException {
String str = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cc";
String user = ".";
String password = "";
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from T_TEST where T1='001'";
rs = stmt.executeQuery(sql);
if (rs.next())
str = rs.getString("T2");
}
catch (SQLException e) {
System.out.println("{SQLException e :}");
e.printStackTrace();
}
catch (ClassNotFoundException cnfee) {
System.out.println("{ClassNotFoundException e :}");
cnfee.printStackTrace();
}
catch (InstantiationException iee) {
System.out.println("{InstantiationException e :}");
iee.printStackTrace();
}
catch (IllegalAccessException iaee) {
System.out.println("{IllegalAccessException e :}");
iaee.printStackTrace();
}
finally {
rs.close();
stmt.close();
conn.close();
}
return str;
}
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
//pubs为你的数据库的
String user="mgj";
String password="1223521";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用
户 'mgj' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source