[初学者问题]我现在配置好了Tomcat,想连接SQLserver,需要下载什么文件吗? 用jdbc-odbc连接sqlserver odbc数据源的话不要否则要用sqlserver的jdbc driver微软有提供,伴随文档有例子 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 迟来了一步,try{ InputStream ins = new FileInputStream("DBConfig.ini"); Properties pr = new Properties(); pr.load(ins); String dbname = pr.getProperty("DataBaseName","").trim(); String ip = pr.getProperty("IPAddress","localhost").trim(); user = pr.getProperty("username","").trim(); passwd = pr.getProperty("password","").trim(); url = "jdbc:weblogic:mssqlserver4:"+dbname+"@"+ip+":1433"; Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance(); DriverManager.setLoginTimeout(50); con = DriverManager.getConnection(url,user,passwd); String sql = "select * from tbname"; Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql) rs.getString(1); 我在论坛上找的一个例子,代码如下:<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html><body><%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=picdata";String user="sa";String password="";Connection conn= DriverManager.getConnection(url,user,password);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql="select * from user_record";ResultSet rs=stmt.executeQuery(sql);while(rs.next()) {%>您的第一个字段内容为:<%=rs.getString(1)%>您的第二个字段内容为:<%=rs.getString(2)%><%}%><%out.print("数据库操作成功,恭喜你");%><%rs.close();stmt.close();conn.close();%></body></html>却出错,提示:The server encountered an internal error () that prevented it from fulfilling this request请问那错了?(数据库picdata里有user_record表) 我已下载了mssqldriver.zip压缩包里面有msbase.jar,mssqlserver.jar,msutil.jar三个文件,那我应把它们放在那里呢?我放在sdk的lib目录下没有效果。我上述的代码有问题吗?高手啊!帮帮忙吧,这对你们来说只是举手之功劳啊! 关于Properties类的测试? 文件过滤FilenameFilter 简单的socket程序,但是cpu却一直是100% java调用存储过程访问oracle数据库的问题?? jbuilder x编译不出图形 如何让JLabel分多行显示? Java里如何得知SQL Server的一些状态信息,达到监控的目的? java 发布问题 明天要交了,可是~~~请大虾们帮帮小妹吧---数据的分级审核问题??? 关于HashMap源码中一个不解之处提问 如何判断,回车和ctrl键同时被按下的事件 初学者选那本书??请指教
try{
InputStream ins = new FileInputStream("DBConfig.ini");
Properties pr = new Properties();
pr.load(ins);
String dbname = pr.getProperty("DataBaseName","").trim();
String ip = pr.getProperty("IPAddress","localhost").trim();
user = pr.getProperty("username","").trim();
passwd = pr.getProperty("password","").trim();
url = "jdbc:weblogic:mssqlserver4:"+dbname+"@"+ip+":1433";
Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();
DriverManager.setLoginTimeout(50);
con = DriverManager.getConnection(url,user,passwd);
String sql = "select * from tbname";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql)
rs.getString(1);
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=picdata";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user_record";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>却出错,提示:
The server encountered an internal error () that prevented it from fulfilling this request
请问那错了?(数据库picdata里有user_record表)
,msutil.jar三个文件,那我应把它们放在那里呢?我放在sdk的lib目录下没有效果。我上述的代码有问题吗?高手啊!帮帮忙吧,这对你们来说只是举手之功劳啊!