你的sql语句有错误, 你使用了 bno 作为字段名,但是数据库里没有这么一列,或者你表搞错了。
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<% Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}
try { con=DriverManager.getConnection("jdbc:odbc:myliujie","","");
String condition="INSERT INTO information( bno,bname,bor,ret,sno,sname)VALUES( '"+bno+"', '"+bname+"','"+bor+"',"+ret+"', '"+sno+"', "+sname+")";
sql=con.createStatement();
rs=sql.executeQuery(condition);
out.print("
"+"图书编号"); out.print(" | "+"书名"); out.print(" | "+"借书时间"); out.print(" | "+"还书时间"); out.print(" | "+"学号"); out.print(" | "+"姓名");
catch(SQLException e) |
---|
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<% Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}
try { con=DriverManager.getConnection("jdbc:odbc:myliujie","","");
String condition="INSERT INTO information( bno,bname,bor,ret,sno,sname)VALUES( '"+bno+"', '"+bname+"','"+bor+"',"+ret+"', '"+sno+"', "+sname+")";
sql=con.createStatement();
rs=sql.executeQuery(condition);
out.print("
"+"图书编号"); out.print(" | "+"书名"); out.print(" | "+"借书时间"); out.print(" | "+"还书时间"); out.print(" | "+"学号"); out.print(" | "+"姓名");
catch(SQLException e) |
---|
sql异常很简单明了啊,列名无效,有两种情况
1 数据库不存在这个字段
2 你连接的sql语句有问题
sql语句异常了,sql中列字段名称和数据库定义的列字段名称不一样,改成一样就好了,提示的错误挺明显的