有用eclipse开发java数据库应用程序的请帮忙 出错数据库连接出错No suitable driver
我应该把怎么样配置路径才能找到驱动呀
mssqlserver.jar
msbase.jar
msutil.jar
是这个原因还是其它原因呢?
问题点数：0、回复次数：4Top
1 楼allenhe（考一级去）回复于 2004-05-02 10:13:43 得分 0
放到classpath里面去
然后在project路径里面包含进来Top
2 楼ZenSigil（禅印）回复于 2004-05-02 10:41:45 得分 0
Eclipse 项目-属性-java构建路径-添加外部jarTop
3 楼day125（风中）回复于 2004-05-02 11:22:03 得分 0
我已
Eclipse 项目-属性-java构建路径-添加外部jar
三个都包含进来了
eclipse->run 下
我也看看 运行时的classpath路径
没错的
我的程序是这样的
/*
* Created on 2004-4-30
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.linjun.ch5;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
/**
* @author administrator
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class UserRegist {
private UserInfo userInfo;
private Connection con;
/**
*获得数据库连接
*/
public UserRegist()throws ConException {
String CLASSFORNAME="SQLServerDriver";
String SERVANDDB="jdbc:microsoft:slqserver://127.0.0.1:1433;DatabaseName=jspdev";
String USER="sa";
String PWD="";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
} catch (Exception e) {
e.printStackTrace();
throw new ConException("数据库连接出错"+e.getMessage());
}
}
/**
* @param info
*/
// 设置待注册用户信息
public void setUserInfo(UserInfo info) {
userInfo = info;
}
// 进行注册
public void regist() throws Exception{
String reg="insert into user_info values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
PreparedStatement pstmt=con.prepareStatement(reg);
// 创建一个预处理语句,然后设置它们的参数
pstmt.setString(1,userInfo.getUserId());
pstmt.setString(2,userInfo.getName());
pstmt.setString(3,userInfo.getPhone());
pstmt.setString(4,userInfo.getStreet());
pstmt.setString(5,userInfo.getState());
pstmt.setString(6,userInfo.getCity());
pstmt.setString(7,userInfo.getZipCode());
pstmt.setString(8,userInfo.getEmail());
pstmt.setString(9,userInfo.getCardNumber());
pstmt.setInt(10,userInfo.getCardType());
pstmt.setInt(11,0);
pstmt.setDate(12,new java.sql.Date( new java.util.Date().getTime() ));
pstmt.setInt(13,1);
pstmt.setInt(14,0);
pstmt.setString(15,userInfo.getFanvcategory());
pstmt.setString(16,userInfo.getPassword());
// 执行更新操作
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
throw e;
// TODO: handle exception
}
}
public static void main(String[] args){
try {
UserRegist regist=new UserRegist();
UserInfo info=new UserInfo();
info.setUserId("231");
info.setName("sd");
info.setPhone("213121");
info.setPassword("23434");
regist.setUserInfo(info);
} catch (Exception e) {
System.out.println("出错"+e.getMessage());
// TODO: handle exception
}
}
}
执行后出现
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.linjun.ch5.UserRegist.<init>(UserRegist.java:34)
at com.linjun.ch5.UserRegist.main(UserRegist.java:85)
出错数据库连接出错No suitable driver
Top
4 楼caoxmby（祝她幸福）回复于 2004-05-04 13:51:54 得分 0
看看驱动程序的版本对不对Top
