java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at wuliu.conndata.executeQuery(conndata.java:20)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:203)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
这是因为没有找到驱动 还是别的原因数据库异常
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at wuliu.conndata.executeQuery(conndata.java:20)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:203)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
这是因为没有找到驱动 还是别的原因数据库异常
错误提示的很清楚啊
你的连接字符串没写对
import java.sql.*;
public class conndata {
Connection conn=null;
ResultSet rs=null;
Statement st=null;
boolean n=false; public conndata() {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e)
{e.printStackTrace();}
}
public ResultSet executeQuery(String sql)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:dbsource","sa","123");
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=st.executeQuery(sql);
}catch(SQLException e)
{
e.printStackTrace();
System.out.println("Query Exception");
}
return rs;
}
public boolean executeUpdata(String sql)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:dbsource","sa","123");
st=conn.createStatement();
int m=st.executeUpdate(sql);
n=true;
}catch(Exception e)
{
n=false;
e.printStackTrace();
System.out.print("Updata Exception");
}
return n;
}
public boolean executeInsert(String sql)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:dbsource","sa","123");
st=conn.createStatement();
st.executeUpdate(sql);
n=true;
}catch(Exception ex)
{
n=false;
ex.printStackTrace();
System.out.println("Insert Exception");
}
return n; }
public boolean executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:dbsource","sa","123");
st=conn.createStatement();
st.executeUpdate(sql);
n=true;
}
catch(Exception e)
{
n=false;
e.printStackTrace();
System.out.println("Delete exception");
}
return n;
}
public void closeConn()
{
try
{
conn.close();
}catch(Exception e)
{e.printStackTrace();}
}
public void closeStatement()
{
try
{
st.close();
}catch(Exception e)
{e.printStackTrace();} }
}我是SQL2005 ID SA 密码 123
dbsource对么?