医院设计机构,在线网站优化,网站开发难点分析,曲靖市建设局网站官网我的项目没有使用任何IDE。整个编码使用Textpad完成。所以我需要帮助连接sql server数据库和我的项目。这是bean类#xff0c;其中编写了用于数据库连接的业务逻辑。我已经安装了SQL服务器并使用Windows身份验证创建了一个名为“vt”的数据库。我甚至为数据库创建了dsn#x…我的项目没有使用任何IDE。整个编码使用Textpad完成。所以我需要帮助连接sql server数据库和我的项目。这是bean类其中编写了用于数据库连接的业务逻辑。我已经安装了SQL服务器并使用Windows身份验证创建了一个名为“vt”的数据库。我甚至为数据库创建了dsn即vtdsn。但仍然没有找到课程的例外。请帮忙。M卡在这里。之前它在我使用MS Access进行数据库时工作正常。但是在使用SQL服务器进行数据库连接时我需要做些什么改变package ankit;import java.sql.*;public class RegisterBean {private Connection con;private PreparedStatement pst;private ResultSet rs;private String myfirstname, mylastname, myemail, mypassword, dateofbirth, gender, college, address;//code for setter and getter method. removed to shorten the code//public RegisterBean() {System.out.println(Default constructor of RegisterBean is called);}public void makeConnection() {try {Class.forName(com.mysql.jdbc.Driver);con DriverManager.getConnection(jdbc:odbc:vtdsn);} catch (Exception e) {System.out.println(Error in making connection );e.printStackTrace();}}public boolean checkRegistration(String fN, String lN, String email, String pwd, String dob, String gender, String coll, String addr) {boolean flag;makeConnection();try {pst con.prepareStatement(insert into studentdetail values(?,?,?,?,?,?,?,?));pst.setString(1, fN);pst.setString(2, lN);pst.setString(3, email);pst.setString(4, pwd);pst.setString(5, dob);pst.setString(6, gender);pst.setString(7, coll);pst.setString(8, addr);int i pst.executeUpdate();System.out.println(i);if (i 1) {flag true;} else {flag false;}} catch (Exception e) {flag false;e.printStackTrace();}return flag;}}将驱动程序添加到我的java bean类文件所在的Tomcat的classes文件夹中并将驱动程序添加到jre / lib和jre / lib / ext文件夹中。现在收到此错误Error in making connectionjava.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost/SQLEXPRESS/Databases/vt:1433;at java.sql.DriverManager.getConnection(DriverManager.java:604)at java.sql.DriverManager.getConnection(DriverManager.java:243)at ankit.RegisterBean.makeConnection(RegisterBean.java:113)at ankit.RegisterBean.checkRegistration(RegisterBean.java:124)at org.apache.jsp.components.jsp.RegisterDataBase_jsp._jspService(RegisterDataBase_jsp.java:117)at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)at java.lang.Thread.run(Thread.java:722)java.lang.NullPointerExceptionat ankit.RegisterBean.checkRegistration(RegisterBean.java:127)at org.apache.jsp.components.jsp.RegisterDataBase_jsp._jspService(RegisterDataBase_jsp.java:117)at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)at java.lang.Thread.run(Thread.java:722)false解决解决我的问题。我所做的只是下载sqljdbc4驱动程序并将驱动程序粘贴到TOMCAT lib文件夹中。 (注意下载驱动程序后将其解压缩到某处然后你会在该解压缩文件夹中找到原始驱动程序。将该文件粘贴到tomcat lib文件夹中。这就是我做错了我只是粘贴了下载的rar文件互联网这就是为什么tomcat无法找到驱动程序)。粘贴lib文件夹中的驱动程序后只需将类路径设置为该驱动程序即可完成。
