jdbc sqlserver 没找到
来源:百度知道 编辑:UC知道 时间:2024/05/05 19:28:49
我配置的jsp服务器是Tomcat 6.0, 编译好类dbmanager.DBManager后放在WEB-INF的classes文件夹下,DBManager的代码如下:
package dbmanager;
import java.sql.*;
import javax.swing.JOptionPane;
/**
* @(#)DBManager.java
*
*
* @author Administrator
* @version 1.00 2008/1/11
*/
public class DBManager {
private Connection con;
private Statement s;
public DBManager() {
try{
//load the driver
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ex) {
System.out.println(ex.getMessage());
}
try {
//Create the connection
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.100.11;DatabaseName=stl","abc","123");
//get opeation
s = con.createStatement();
}
catch(SQLException ex) {
package dbmanager;
import java.sql.*;
import javax.swing.JOptionPane;
/**
* @(#)DBManager.java
*
*
* @author Administrator
* @version 1.00 2008/1/11
*/
public class DBManager {
private Connection con;
private Statement s;
public DBManager() {
try{
//load the driver
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ex) {
System.out.println(ex.getMessage());
}
try {
//Create the connection
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.100.11;DatabaseName=stl","abc","123");
//get opeation
s = con.createStatement();
}
catch(SQLException ex) {
首先你要确定你把sqlserver的驱动放置在了webinf目录下的lib目录下
你的数据路驱动路径可能要换下:
jdbc:sqlserver://192.168.100.11;DatabaseName=stl
你没有加端口号!
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stl
1433前面是半角冒号后面是半角分号
jdbc sqlserver 没找到
JDBC 如何 连接 SQLServer 2000
jsp连sqlserver,jdbc连不上
为什么我jdbc连不上sqlserver?
jdbc 2005 能不能 连接 sqlserver 2000
JDBC for SQLServer 2000:error establishing socket
[microsoft] [SQLServer 2000 Driver for JDBC] Error esblishing socket
请教SQLServer 2000 Driver for JDBC错误(java)
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.