我把3个.jar文件加载到tomcat的目录下和jdk的目录lib,也安装了sever 2000的补丁sp4,我的驱动程序的代码是:package com.zzx.util;
import java.sql.*;
public class DataConn {
public static void main(String[] srg) {
new DataConn().getConn();
//System.out.println("conn successfully");
}
/*
* mysql数据库驱动
* */
// final String driver = "com.mysql.jdbc.Driver";
// final String url = "jdbc:mysql://localhost:3306/jpkc";
// final String user = "root";
// final String password = "root";
//sql server 2000的数据驱动
// final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载server2005 JDBC驱动
// final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc"; // 连接服务器和数据库
// final String user = "sa";
// final String password = "";
final String driver ="net.sourceforge.jtds.jdbc.Driver";
final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc1";
final String user = "sa";
final String password = "sa";
static Connection conn = null; public DataConn() {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("驱动类加载失败!");
}
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("连接数据库失败!");
}
} public Connection getConn() {
return conn;
}
public void closeConn() {
try {
conn.close();
} catch (SQLException e) {
System.out.println("和数据库断开连接失败!");
}
}
}
错误提示是: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zzx.util.DataConn.<init>(DataConn.java:43)
at com.zzx.util.DataConn.main(DataConn.java:9)
连接数据库失败!
import java.sql.*;
public class DataConn {
public static void main(String[] srg) {
new DataConn().getConn();
//System.out.println("conn successfully");
}
/*
* mysql数据库驱动
* */
// final String driver = "com.mysql.jdbc.Driver";
// final String url = "jdbc:mysql://localhost:3306/jpkc";
// final String user = "root";
// final String password = "root";
//sql server 2000的数据驱动
// final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载server2005 JDBC驱动
// final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc"; // 连接服务器和数据库
// final String user = "sa";
// final String password = "";
final String driver ="net.sourceforge.jtds.jdbc.Driver";
final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc1";
final String user = "sa";
final String password = "sa";
static Connection conn = null; public DataConn() {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("驱动类加载失败!");
}
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("连接数据库失败!");
}
} public Connection getConn() {
return conn;
}
public void closeConn() {
try {
conn.close();
} catch (SQLException e) {
System.out.println("和数据库断开连接失败!");
}
}
}
错误提示是: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zzx.util.DataConn.<init>(DataConn.java:43)
at com.zzx.util.DataConn.main(DataConn.java:9)
连接数据库失败!
解决方案 »
- JSP页面取得List 然后又要传回到action如何解决?急急急...
- 使用extjs的json读取数据时出错,帮忙啊。
- java解析xlsx
- 求救大家都来看看
- 大家进来说说:现在做报表都用什么工具?ireport? e表?
- 生产企业采集数据,采用Struts框架合适吗
- web.xml配置org.springframework.web.context.ContextLoaderListener监听器出错
- tomcat的环境设置问题,为什么应用跑不动了?
- 如何将<bean:write name="moduals" property="inValid"/>值为<FONT COLOR='RED'>无效</FONT>输出成带颜色的字
- 请帮我好吗?在线啊,javamail
- RMI,RPC,JAX-RPC,JAX-WS,CORBA的概念理解?
- 求ognl表达式中select标签的用法
// final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载server2005 JDBC驱动
// final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc"; // 连接服务器和数据库
// final String user = "sa";
// final String password = "";把你这几行代码取消注释,然后再改一个密码和数据库名就可以了
String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name"; //db_name为数据库名
String Username="username"; //用户名
String Password="password"; //密码