package xwfb;
import java.sql.*;
public class test {
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("数据库驱动程序注册成功!");
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=srenp";
String user = "sa";
String password = "sa";
String sql = "select * from news";
Connection conn = DriverManager.getConnection(url, user, password);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
String teacher = rs.getString("teacher");
System.out.println(teacher);
}
System.out.println("数据库连接成功");
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
}错误报告:
Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/util/UtilLocalMessages
at com.microsoft.jdbc.base.BaseExceptions.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at xwfb.test.main(test.java:12)
数据库驱动程序注册成功!
import java.sql.*;
public class test {
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("数据库驱动程序注册成功!");
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=srenp";
String user = "sa";
String password = "sa";
String sql = "select * from news";
Connection conn = DriverManager.getConnection(url, user, password);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
String teacher = rs.getString("teacher");
System.out.println(teacher);
}
System.out.println("数据库连接成功");
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
}错误报告:
Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/util/UtilLocalMessages
at com.microsoft.jdbc.base.BaseExceptions.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at xwfb.test.main(test.java:12)
数据库驱动程序注册成功!
楼主【ren008598】截止到2008-07-22 10:55:57的历史汇总数据(不包括此帖):
发帖的总数量:0 发帖的总分数:0 每贴平均分数:0
回帖的总数量:4 得分贴总数量:2 回帖的得分率:50%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:0 未结的总分数:0
结贴的百分比:---------------------结分的百分比:---------------------
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
查一下给类 是在哪个包下面
然后看看你的classpath路径配置是否正确.
现在一般用eclipse,直接导入包就可以了.
这里 你的报告错误信息
Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/util/UtilLocalMessages
你检查这个包中的内容 是否 正确 路径是
没有找到com.microsoft.jdbc.sqlserver.SQLServerDriver
楼上说:ms sql server这个鸟东西哪弄不对一点就出问题,版本,补丁。
练习的话就用odbc连接mssql,要么就用mssql版本相对应的驱动,现在都出到了SP4,建议升个级再用。
msbase.jar、mssqlserver.jar、msutil.jar
直接复制到tomcat的发布目录WEB-INF/lib目录下,就可以了
这里有解决问题的方法:
http://topic.csdn.net/u/20080509/15/06363c2c-0650-4e0c-ba14-a2ce69c937c6.html
链接SQL2000要分为四步:
1、安装SQL2000,安装时选择windows和密码验证
2、安装SP4补丁,最好和SQl2000安装在同一目录下
3、在安装目录下有一个setup.bat,双击运行此批处理文件
4、安装SQL2000的驱动包
按以上几步操作,链接SQL2000应该就没有问题了。
在试下,看看
好多人都是双击解压后就认为是完事了....
2.sql2000必须是sp3补丁以上才行
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//打开驱动器
Connection con=DriverManager.getConnection("jdbc:odbc:cha");//连接数据库
Statement stm=con.createStatement();//实例化 Statement 执行语句对象我的是这样连接数据库
package com.hetao;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class LoginCl extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res){
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
try{
String u=req.getParameter("name");
String p=req.getParameter("password");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=sqdb","sa","");
sm=ct.createStatement();
rs=sm.executeQuery("select top 1 * from users where username='"+u+"'and password='"+p+"'");
if(rs.next()){
HttpSession hs=req.getSession(true);
hs.setAttribute("pass","ok");
hs.setMaxInactiveInterval(20);
res.sendRedirect("wel?un="+u+"&up="+p);
}
else{
res.sendRedirect("login");
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
try{
if(rs!=null){
rs.close();
}
if(sm!=null){
sm.close();
}
if(ct!=null){
ct.close();
}
}
catch(Exception ex){
ex.printStackTrace();
}
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res){
this.doGet(req,res);
}
}
但解决了
我是用servlet做的
package com.hetao;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class LoginCl extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res){
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
try{
String u=req.getParameter("name");
String p=req.getParameter("password");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=sqdb","sa","");
sm=ct.createStatement();
rs=sm.executeQuery("select top 1 * from users where username='"+u+"'and password='"+p+"'");
if(rs.next()){
HttpSession hs=req.getSession(true);
hs.setAttribute("pass","ok");
hs.setMaxInactiveInterval(20);
res.sendRedirect("wel?un="+u+"&up="+p);
}
else{
res.sendRedirect("login");
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
try{
if(rs!=null){
rs.close();
}
if(sm!=null){
sm.close();
}
if(ct!=null){
ct.close();
}
}
catch(Exception ex){
ex.printStackTrace();
}
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res){
this.doGet(req,res);
}
}
package pojo;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class BaseDao { private static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;Databsae=bbsdb";
private static final String USER = "sa";
private static final String PWD = "yj000"; public Connection getConnection() { Connection conn = null; try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} try {
conn = DriverManager.getConnection(URL, USER, PWD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return conn;
}
}
package pojo;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class Test extends BaseDao { /**
* @param args
*/ public static void main(String[] args) {
// TODO Auto-generated method stub
Test t = new Test(); t.test();
} public void test() {
Connection conn = super.getConnection(); String sql = "select * from users"; try {
PreparedStatement psttm = conn.prepareStatement(sql); ResultSet rs = psttm.executeQuery(); if (rs.next()) {
System.out.println("成功");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }}