代码为:
- 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)