高手们 帮忙啊!
编写了一个测试数据库的代码如下:
addUser.html
<html>
<head><title>user add</title></head>
<body>
<form method="post" action="jdbc.jsp">
<p align="center">姓名:
<input type="text" name="name" size="20"> </p>
<p align="center">密码:
<input type="password" name="pwd" size="20">
</p>
<p align="center">
<input type="submit" value="提交" name="B1"></p>
</form>
</body>
</html>
jdbc.jsp
<html>
<head><title>add user to DB</title></head>
<%@page import="java.sql.*"%>
<body>
<pre>
<%
String name,pwd;
name=request.getParameter("name");
pwd=request.getParameter("pwd");
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:jspTest");
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into tbUser values('"+name+"','"+pwd+"')" );
ResultSet rs=stmt.executeQuery("select * from tbUser");
out.println("all user from db");
while(rs.next())
{
out.print("user name:");
out.print(rs.getString("name")+" password:");
out.print(rs.getString("password"));
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
</pre>
</body>
</html>
当输入姓名 密码 提交后出现下列问题
[Microsoft][ODBC SQL Server Driver][SQL Server]?? '(null)' ???????: ???? SQL Server ??????
请问怎样改