你用的什么开发?tomcat?三个文件考到Tomcat 5.0\common\lib下就行了环境变量:windows 2000:我的电脑--〉属性--〉高级--〉环境变量 --〉系统变量-->新建(先找找看有没有classpath) 变量名:classpath 变量值:D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar; D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
不用tomcat开发,考到哪里?系统环境变量设好了。
我现在测试sql java 能否连上sql server,但是运行结果总是 :java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver at SQLDemo.main(SQLDemo.java:8) 怎么办?import java.sql.*; import java.io.*; import java.util.*;public class SQLDemo{ public static void main(String args[]) throws Exception{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://QI1AQL1UUCCHXAH:1433;DatabaseName=Northwind;user=sa;Password=sa"); Statement st=conn.createStatement(); String s="select * from Customers"; ResultSet rs=st.executeQuery(s); while (rs.next()) { System.out.println(rs.getString(1)+"<br>"); System.out.println(rs.getString(2)+"<br>"); } } }
下载驱动。jdbc包中的3个jar包:msutil.jar,mssqlserver.jar,msbase.jar要在classpath里指一下
如果你的服务器是tomcat直接将3个jar包拷贝到tomcat\common\lib下重新启动tomcat可以了
--〉系统变量-->新建(先找找看有没有classpath)
变量名:classpath
变量值:D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
:java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at SQLDemo.main(SQLDemo.java:8)
怎么办?import java.sql.*;
import java.io.*;
import java.util.*;public class SQLDemo{ public static void main(String args[]) throws Exception{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://QI1AQL1UUCCHXAH:1433;DatabaseName=Northwind;user=sa;Password=sa");
Statement st=conn.createStatement();
String s="select * from Customers";
ResultSet rs=st.executeQuery(s);
while (rs.next())
{
System.out.println(rs.getString(1)+"<br>");
System.out.println(rs.getString(2)+"<br>");
}
}
}
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Statistics";
//pubs为你的数据库的
String user="sa";
String password="aaa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from NetReport";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();