Java连接SQL Server 2000 数据库的有些系统表可以访问 为什么自己建的用户表访问就会出错 ??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %><%@ page import="java.sql.*" %><% String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=school"; String userName = "sa"; String userPwd = "sa"; Connection dbConn=null; try { Class.forName(driverName); dbConn = DriverManager.getConnection(dbURL, userName, userPwd); System.out.println("Connection Successful!"); } catch (Exception e) { e.printStackTrace(); } PreparedStatement stmt =null;ResultSet rs =null;String sql ="select * from student";try{ stmt=dbConn.prepareStatement(sql); out.print("成功1!"); rs = stmt.executeQuery(); out.print("成功2");}catch(Exception e){ out.print("失败!");}%> 调试结果:成功1!失败!我如果把String sql ="select * from student"改成String sql ="select * from sysfiles1";(sysfiles1是系统表)调试结果就是:成功1!成功2! 查看一下sa用户的权限,安全性-》登录-》双击sa用户-》数据库访问,看看是否选中了school库 各位大侠帮帮忙。。 插入数据时循序添加编号的问题! 新手讨教一关于2个表的查询语句. 再次请教,表的插入问题 select语句中的in运算 基本问题,谢谢了!! 存储过程中写行件判断! 请教高手,请问该函数返回出错,为什么 远程数据库更新的问题?? ms sql server7 移植到 oracle8i select...union all ...where.. 函数
<%@ page import="java.sql.*" %>
<% String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=school";
String userName = "sa";
String userPwd = "sa";
Connection dbConn=null; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
catch (Exception e) {
e.printStackTrace();
}
PreparedStatement stmt =null;
ResultSet rs =null;
String sql ="select * from student";
try{
stmt=dbConn.prepareStatement(sql); out.print("成功1!");
rs = stmt.executeQuery();
out.print("成功2");
}catch(Exception e){
out.print("失败!");
}
%>
成功1!失败!我如果把String sql ="select * from student"
改成String sql ="select * from sysfiles1";(sysfiles1是系统表)调试结果就是:
成功1!成功2!