我想用学号作为关键字,查看该生的个人信息,但是由于刚接触,有的还不明白,请高手指点,帮我改正好吗
运行时出现:
[Microsoft][ODBC Microsoft Access Driver] ???????? ?????? 'sno='null' ??代码如下
<html>
<head>
<title>信息查询</title>
</head>
<%@ page import="java.sql.*"%>
<body>
<pre>
<%
String Student_sno;
Statement stmt;
Student_sno=request.getParameter("sno");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:ma");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select * from student where sno='"+Student_sno+"");
out.println("他的信息如下");
while(rs.next()){
out.print("姓名:");
out.println(rs.getString("name"));
out.print("性别:");
out.println(rs.getString("sex"));
out.print("学号:");
out.println(rs.getString("sno"));
out.print("生日:");
out.println(rs.getString("birthday"));
out.print("所在班级:");
out.println(rs.getString("banji"));
out.print("宿舍:");
out.println(rs.getString("room"));
out.print("联系方式:");
out.println(rs.getString("tel"));
out.print("家庭住址:");
out.println(rs.getString("address"));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
out.println(ex.getMessage());
}
%>
</pre>
</body>
</html>
运行时出现:
[Microsoft][ODBC Microsoft Access Driver] ???????? ?????? 'sno='null' ??代码如下
<html>
<head>
<title>信息查询</title>
</head>
<%@ page import="java.sql.*"%>
<body>
<pre>
<%
String Student_sno;
Statement stmt;
Student_sno=request.getParameter("sno");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:ma");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select * from student where sno='"+Student_sno+"");
out.println("他的信息如下");
while(rs.next()){
out.print("姓名:");
out.println(rs.getString("name"));
out.print("性别:");
out.println(rs.getString("sex"));
out.print("学号:");
out.println(rs.getString("sno"));
out.print("生日:");
out.println(rs.getString("birthday"));
out.print("所在班级:");
out.println(rs.getString("banji"));
out.print("宿舍:");
out.println(rs.getString("room"));
out.print("联系方式:");
out.println(rs.getString("tel"));
out.print("家庭住址:");
out.println(rs.getString("address"));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
out.println(ex.getMessage());
}
%>
</pre>
</body>
</html>
解决方案 »
- java 如何得到播放音乐的当前音调?
- 集合ArrayList的add怎么编译不过?
- 忽然犯傻了.以为这样调用也可以...
- 问高手一个功能怎么实现的,在线等!
- 在canvas上画图如何设置矩形的颜色,清屏,消除画面闪烁等问题[SWT]
- 这段代码的几个Testthis2分别是干什么的
- 如何在客户端方判断socket连接是否关闭
- java如何操作文件
- 如何把一段创建新线程的代码封装成一个类,然后另一个类中引用?如何引用?
- 请问java.util.hashtablc 与 java.util.arraylist有何不同?谢谢!
- java能否printf出 汉字或字母的计算机内的二进制表示。
- 怎么用图片做背景啊~~~~~~~ 还有怎么用代码画渐变色?
sno为null(sno必须not null吧)