<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jstl/sql_rt" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="f" %>
<%request.setCharacterEncoding("GBK") ; %>
<%--<%response.setCharacterEncoding("GBK") ; %>--%>
<html>
<head>
<title>
saveinfo
</title>
</head>
<body bgcolor="#ffffff"><%--
<sql:setDataSource driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://accp:1433;DataBaseName=jspjsp;" user="ee"
password="123" var="conn"/>
--%>(使用上面的的代码时出错,以安装驱程,同时也常试使用sql pack3也没有用
提示错误是:javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis) <sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:jspjsp" user="ee"
password="123" var="conn"/>(使用上面的的代码时一切正常)
<sql:update var="custinfo" dataSource="${conn}" scope="session" >
insert into information(pname,ptype,pprice,pbrand,pdes) values(?,?,?,?,?)
<sql:param value="${param.pname}"/>
<sql:param value="${param.ptype}"/>
<sql:param value="${param.pprice}"/>
<sql:param value="${param.pbrand}"/>
<sql:param value="${param.pdes}"/>
</sql:update>
<sql:query var="selectq" dataSource="${conn}" scope="session">
select * from information
</sql:query> <table bgcolor="1" width="90%"> <tr>
<c:forEach var="columnname" items="${selectq.columnNames}">
<th>${columnname}</th>
</c:forEach>
</tr>
<c:forEach var="row" items="${selectq.rowsByIndex}">
<tr>
<c:forEach var="column" items="${row}">
<td><c:out value="${column}"/></td>
</c:forEach>
</tr>
</c:forEach> </table></body>
</html>
<%@ taglib uri="http://java.sun.com/jstl/sql_rt" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="f" %>
<%request.setCharacterEncoding("GBK") ; %>
<%--<%response.setCharacterEncoding("GBK") ; %>--%>
<html>
<head>
<title>
saveinfo
</title>
</head>
<body bgcolor="#ffffff"><%--
<sql:setDataSource driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://accp:1433;DataBaseName=jspjsp;" user="ee"
password="123" var="conn"/>
--%>(使用上面的的代码时出错,以安装驱程,同时也常试使用sql pack3也没有用
提示错误是:javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis) <sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:jspjsp" user="ee"
password="123" var="conn"/>(使用上面的的代码时一切正常)
<sql:update var="custinfo" dataSource="${conn}" scope="session" >
insert into information(pname,ptype,pprice,pbrand,pdes) values(?,?,?,?,?)
<sql:param value="${param.pname}"/>
<sql:param value="${param.ptype}"/>
<sql:param value="${param.pprice}"/>
<sql:param value="${param.pbrand}"/>
<sql:param value="${param.pdes}"/>
</sql:update>
<sql:query var="selectq" dataSource="${conn}" scope="session">
select * from information
</sql:query> <table bgcolor="1" width="90%"> <tr>
<c:forEach var="columnname" items="${selectq.columnNames}">
<th>${columnname}</th>
</c:forEach>
</tr>
<c:forEach var="row" items="${selectq.rowsByIndex}">
<tr>
<c:forEach var="column" items="${row}">
<td><c:out value="${column}"/></td>
</c:forEach>
</tr>
</c:forEach> </table></body>
</html>
嘿嘿