好心人帮帮忙解决一下数据库连接的有关问题!
日期：2014-05-18 浏览次数：20656 次
好心人帮帮忙解决一下数据库连接的问题!急!急!
请高手们帮我看看这个问题，搞了好几次都出现错误（已经加载了sqlserver的3个驱动文件）,源程序和出现的错误提示如下:
package shop;
import java.sql.*;
public class DBConnectBean {
public static Connection getSqlserverConn()
{
Connection conn=null;
String url= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String sqldriver= "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=jspdev ";
try {
Class.forName(url);
conn=DriverManager.getConnection(sqldriver, "sa ", " ");
conn.setCatalog( "jspdev ");
}
catch (Exception ex) {
ex.printStackTrace();
}
return conn;
}
}
---------------------------------------------------
<%@ page contentType= "text/html; charset=GBK " import= "java.sql.* "%>
<html>
<head>
<title>
logincheck.jsp
</title>
</head>
<body bgcolor= "#ffffff ">
<jsp:useBean id= "dbconn " class= "shop.DBConnectBean " scope= "page "/>
<%
//获得请求参数
String name=request.getParameter( "username ");
String password=request.getParameter( "userpassword ");
//连接数据库
dbconn.getSqlserverConn();
String usersql= "select * from users where name= ' "+name+ " 'and password= ' "+password+ " ' ";
Connection con=null;
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery(usersql);
if(result.next())
{
%>
欢迎你， <%=name%>
<%}%>
</body>
</html>
------------------------------------------------
java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.jsp.logincheck$jsp._jspService(logincheck$jsp.java:96)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
请高手们帮我看看这个问题，搞了好几次都出现错误（已经加载了sqlserver的3个驱动文件）,源程序和出现的错误提示如下:
package shop;
import java.sql.*;
public class DBConnectBean {
public static Connection getSqlserverConn()
{
Connection conn=null;
String url= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String sqldriver= "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=jspdev ";
try {
Class.forName(url);
conn=DriverManager.getConnection(sqldriver, "sa ", " ");
conn.setCatalog( "jspdev ");
}
catch (Exception ex) {
ex.printStackTrace();
}
return conn;
}
}
---------------------------------------------------
<%@ page contentType= "text/html; charset=GBK " import= "java.sql.* "%>
<html>
<head>
<title>
logincheck.jsp
</title>
</head>
<body bgcolor= "#ffffff ">
<jsp:useBean id= "dbconn " class= "shop.DBConnectBean " scope= "page "/>
<%
//获得请求参数
String name=request.getParameter( "username ");
String password=request.getParameter( "userpassword ");
//连接数据库
dbconn.getSqlserverConn();
String usersql= "select * from users where name= ' "+name+ " 'and password= ' "+password+ " ' ";
Connection con=null;
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery(usersql);
if(result.next())
{
%>
欢迎你， <%=name%>
<%}%>
</body>
</html>
------------------------------------------------
java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.jsp.logincheck$jsp._jspService(logincheck$jsp.java:96)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
