UC知道JSP与SQL连接问题
来源：百度知道 编辑：UC知道 时间：2024/05/22 15:35:21
我写的JSP代码是这样的中间的USERNAME USERPASSWORD是从HTML文件中返回的
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.sql.*"%>
<%
String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String cString="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=book";
String username=request.getParameter("username");
String userpassword=request.getParameter("userpassword");
String sql="select * from book";
Class.forName(dbDriver);
Connection connect=DriverManager.getConnection(cString+","+username+","+userpassword);
Statement stmt=connect.createStatement();
ResultSet rs=stmt.executeQuery(sql);
%>
他给我的错误是
HTTP Status 500 -
type Exception report
message
description The server encountered an inte
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.sql.*"%>
<%
String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String cString="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=book";
String username=request.getParameter("username");
String userpassword=request.getParameter("userpassword");
String sql="select * from book";
Class.forName(dbDriver);
Connection connect=DriverManager.getConnection(cString+","+username+","+userpassword);
Statement stmt=connect.createStatement();
ResultSet rs=stmt.executeQuery(sql);
%>
他给我的错误是
HTTP Status 500 -
type Exception report
message
description The server encountered an inte
把这句Connection connect=DriverManager.getConnection(cString+","+username+","+userpassword);
改为Connection connect=DriverManager.getConnection(cString,username.userpassword); 看行不行
OK
(cString,username.userpassword);
我晕啊，应该是这样：
(cString,username,userpassword);
都是逗号才对