当前位置: 代码迷 >> Eclipse >> 小弟我是用JSP连接MS Sql Server 2005数据库报错
  详细解决方案

小弟我是用JSP连接MS Sql Server 2005数据库报错

热度:63   发布时间:2016-04-23 12:58:21.0
我是用JSP连接MS Sql Server 2005数据库报错
代码为:
Java code
package wuliu;import java.sql.*;public class conndata {Connection conn=null;ResultSet rs=null;  Statement st=null;  boolean n=false;  String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动  String dbURL = "jdbc:sqlserver://localhost; DatabaseName=DB_WuLiu";   //连接服务器和数据库test String userName = "sa";   //默认用户名 String userPwd = "";   //密码  public conndata() {            try {                Class.forName(driverName);                conn = DriverManager.getConnection(dbURL, userName, userPwd);                System.out.println("Connection Successful!");   //如果连接成功 控制台输出Connection Successful!            } catch (Exception e) {                 e.printStackTrace();            }  }  public ResultSet executeQuery(String sql)  {    try    {     conn=DriverManager.getConnection(dbURL, userName, userPwd);//这里报错     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");      // TODO Auto-generated catch block    }return rs;  }  public boolean executeUpdata(String sql)  {  try  {    conn=DriverManager.getConnection(dbURL, userName, userPwd);  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(dbURL, userName, userPwd);    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(dbURL, userName, userPwd);  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();}  }}

错误提示:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at wuliu.conndata.executeQuery(conndata.java:20)
at org.apache.jsp.regist_005fconfig_jsp._jspService(regist_005fconfig_jsp.java:86)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  相关解决方案