在JSP中对数据进行操作
运行之后的SQL语句为:DELETE * FROM com WHERE no=10001
可是数据库的数据没有变,请各位大哥帮我看看下面的代码有什么问题,谢谢!!
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=yellow ><Font size=2>
<% //获取提交的编号:
String newno=request.getParameter("nno");
if(newno==null)
{newno="";
} //获取提交的新的CPU: Connection con=null;
Statement sql=null;
ResultSet rs=null;
String nc,nb,nm,na;
int nn,np;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:data","sa","sa");
sql=con.createStatement();
String condition="DELETE * FROM com WHERE no"+"="+newno;
//执行更新操作:
out.print(condition);
sql.executeUpdate(condition);
//显示更新后的表中的记录:
%>
<P>更新后的表的记录:
<%
rs=sql.executeQuery("SELECT * FROM com");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"no");
out.print("<TH width=100>"+"cpu");
out.print("<TH width=100>"+"主板");
out.print("<TH width=100>"+"内存");
out.print("<TH width=100>"+"价格");
out.print("<TH width=100>"+"备注");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
nn=rs.getInt(1);
out.print("<TD >"+nn+"</TD>");
nc=rs.getString(2);
out.print("<TD >"+nc+"</TD>");
nb=rs.getString(3);
out.print("<TD >"+nb+"</TD>");
nm=rs.getString(4);
out.print("<TD >"+nm+"</TD>");
np=rs.getInt(5);
out.print("<TD >"+np+"</TD>");
na=rs.getString(6);
out.print("<TD >"+na+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{ }
%>
</FONT>
</BODY>
</HTML>
运行之后的SQL语句为:DELETE * FROM com WHERE no=10001
可是数据库的数据没有变,请各位大哥帮我看看下面的代码有什么问题,谢谢!!
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=yellow ><Font size=2>
<% //获取提交的编号:
String newno=request.getParameter("nno");
if(newno==null)
{newno="";
} //获取提交的新的CPU: Connection con=null;
Statement sql=null;
ResultSet rs=null;
String nc,nb,nm,na;
int nn,np;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:data","sa","sa");
sql=con.createStatement();
String condition="DELETE * FROM com WHERE no"+"="+newno;
//执行更新操作:
out.print(condition);
sql.executeUpdate(condition);
//显示更新后的表中的记录:
%>
<P>更新后的表的记录:
<%
rs=sql.executeQuery("SELECT * FROM com");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"no");
out.print("<TH width=100>"+"cpu");
out.print("<TH width=100>"+"主板");
out.print("<TH width=100>"+"内存");
out.print("<TH width=100>"+"价格");
out.print("<TH width=100>"+"备注");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
nn=rs.getInt(1);
out.print("<TD >"+nn+"</TD>");
nc=rs.getString(2);
out.print("<TD >"+nc+"</TD>");
nb=rs.getString(3);
out.print("<TD >"+nb+"</TD>");
nm=rs.getString(4);
out.print("<TD >"+nm+"</TD>");
np=rs.getInt(5);
out.print("<TD >"+np+"</TD>");
na=rs.getString(6);
out.print("<TD >"+na+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{ }
%>
</FONT>
</BODY>
</HTML>
执行之后输出的SQL语句是:DELETE * FROM com WHERE no=10001
可就是表没有变化
这样呢?
到SQL中就好使了