页面2:(do_change.jsp)<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>´¦ÀíÓû§ÐÞ¸Ä×¢²áÐÅÏ¢</title>
</head>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="UserBean" scope="page" class="mydb.mydb" /><% String moveType =request.getParameter("moveButton");
if (moveType==null){}
else if (moveType.equals("µÚÒ»Ìõ")){
String sub1=(String) session.getValue("dwnsubject");
byte[] tmpb=sub1.getBytes("ISO8859_1");
sub1=new String(tmpb); String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); String sql="select top 1 * from student where ¿ÆÄ¿='" + sub1 + "'
order by ѧºÅ";
ResultSet rs = UserBean.executeQuery(sql);
String name1="";
String num1="";
String code1="";
if(rs.next()) {
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
rs=null;
UserBean.closeStmt();
}
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}
else if (moveType.equals("ÏÂÒ»Ìõ")){
String hiddenName=request.getParameter("num11");
String sql="select * from student";
ResultSet rs = UserBean.executeQuery(sql);
String name1="";
String num1="";
String code1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); int recordExist=0; //±íʾûÓмǼ
while(rs.next()) {
recordExist=1; //¼Ç¼´æÔÚ
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
if (name1.equals(hiddenName)) //Õâ¿é²»Ì«Ã÷°×£¬
break;
}
if ( rs.next())
{
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
}
if (recordExist==1){
rs=null;
UserBean.closeStmt();
}
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
response.sendRedirect("change.jsp");
}
else if (moveType.equals("ÉÏÒ»Ìõ")){ String hiddenName=request.getParameter("num11");
String sql="select * from student";
//ÓÃname1ʼÖÕ±£ÁôÉÏÒ»Ìõ£¬tempname1µÈ¶ÁÈ¡ÏÂÒ»ÌõÓÃÓÚÅжÏ
String name1="";
String num1="";
String code1="";
String tempname1="";
String tempnum1="";
String tempcode1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb);
ResultSet rs = UserBean.executeQuery(sql); if (rs.next())
{
name1=rs.getString("name");
password1=rs.getString("password");
if (name1.equals(hiddenName)) //Ô­À´ÒѾ­ÊǵÚÒ»Ìõ
{ }
else{
//¼ÇϵÚÒ»Ìõ¼Ç¼
tempname1=name1; //¼ÇϵÚÒ»Ìõ¼Ç¼(Õâ¿éÒ²²»Ì«Ã÷°×)
tempnum1=num1;
tempcode1=code1;
while(rs.next()) {
name1=tempname1;
num1=tempnum1;
code1=tempcode1;
tempname1=rs.getString("ÐÕÃû");
tempnum1=rs.getString("ѧºÅ");
tempcode1=rs.getString(times1);
if (tempname1.equals(hiddenName))
break;
}
}
rs=null;
UserBean.closeStmt();
}
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}
//******************************************************************************
////***************ÕâÀï´¦ÀíÌá½»ÐÞ¸Ä
String dealType =request.getParameter("dealButton");
if (dealType==null){}
else if (dealType.equals("È·ÈÏÐÞ¸Ä")){
String change1=request.getParameter("change"); //´ÓhiddenÖжÁÈ¡
String num1=request.getParameter("num11");
String strSQL="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb);
String sub1=(String) session.getValue("dwnsubject");
byte[] tmpb=sub1.getBytes("ISO8859_1");
sub1=new String(tmpb);
strSQL="update student set times1='" + change1 + "' where ѧºÅ='" + num1 + "' and ¿ÆÄ¿£½'"+sub1+"'";
UserBean.executeUpdate(strSQL);
//ÉèÖÃsessionÓÃÓÚ·µ»ØºóµÄÏÔʾ
// session.putValue("name",name1);
// session.putValue("password",password1);
response.sendRedirect("manage.jsp");
}
////***************ÕâÀï´¦ÀíÐÂÔö
else if (dealType.equals("²éÕÒ")){
String num1=request.getParameter("num").trim();
String strSQL="select * from student where ѧºÅ='" + num1 + "'";
ResultSet rs = UserBean.executeQuery(strSQL);
String name1="";
String code1="";
//String times1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); if(rs.next()) { //ÓÐÖظ´
rs=null;
UserBean.closeStmt();
name1=rs.getString("ÐÕÃû");
code1=rs.getString("times1");
rs.close();
session.putValue("num",num1);
response.sendRedirect("change.jsp");
}
response.sendRedirect("manage.jsp");
}
%>
<body>
<script language=javascript>
window.location="change.jsp?showword=Ð޸ijɹ¦"
</script>
</body>
</html>-----说给两百分就给两百,即使系统不让,我也会给大家补上,我是在着急!!!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>´¦ÀíÓû§ÐÞ¸Ä×¢²áÐÅÏ¢</title>
</head>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="UserBean" scope="page" class="mydb.mydb" /><% String moveType =request.getParameter("moveButton");
if (moveType==null){}
else if (moveType.equals("µÚÒ»Ìõ")){
String sub1=(String) session.getValue("dwnsubject");
byte[] tmpb=sub1.getBytes("ISO8859_1");
sub1=new String(tmpb); String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); String sql="select top 1 * from student where ¿ÆÄ¿='" + sub1 + "'
order by ѧºÅ";
ResultSet rs = UserBean.executeQuery(sql);
String name1="";
String num1="";
String code1="";
if(rs.next()) {
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
rs=null;
UserBean.closeStmt();
}
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}
else if (moveType.equals("ÏÂÒ»Ìõ")){
String hiddenName=request.getParameter("num11");
String sql="select * from student";
ResultSet rs = UserBean.executeQuery(sql);
String name1="";
String num1="";
String code1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); int recordExist=0; //±íʾûÓмǼ
while(rs.next()) {
recordExist=1; //¼Ç¼´æÔÚ
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
if (name1.equals(hiddenName)) //Õâ¿é²»Ì«Ã÷°×£¬
break;
}
if ( rs.next())
{
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
}
if (recordExist==1){
rs=null;
UserBean.closeStmt();
}
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
response.sendRedirect("change.jsp");
}
else if (moveType.equals("ÉÏÒ»Ìõ")){ String hiddenName=request.getParameter("num11");
String sql="select * from student";
//ÓÃname1ʼÖÕ±£ÁôÉÏÒ»Ìõ£¬tempname1µÈ¶ÁÈ¡ÏÂÒ»ÌõÓÃÓÚÅжÏ
String name1="";
String num1="";
String code1="";
String tempname1="";
String tempnum1="";
String tempcode1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb);
ResultSet rs = UserBean.executeQuery(sql); if (rs.next())
{
name1=rs.getString("name");
password1=rs.getString("password");
if (name1.equals(hiddenName)) //Ô­À´ÒѾ­ÊǵÚÒ»Ìõ
{ }
else{
//¼ÇϵÚÒ»Ìõ¼Ç¼
tempname1=name1; //¼ÇϵÚÒ»Ìõ¼Ç¼(Õâ¿éÒ²²»Ì«Ã÷°×)
tempnum1=num1;
tempcode1=code1;
while(rs.next()) {
name1=tempname1;
num1=tempnum1;
code1=tempcode1;
tempname1=rs.getString("ÐÕÃû");
tempnum1=rs.getString("ѧºÅ");
tempcode1=rs.getString(times1);
if (tempname1.equals(hiddenName))
break;
}
}
rs=null;
UserBean.closeStmt();
}
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}
//******************************************************************************
////***************ÕâÀï´¦ÀíÌá½»ÐÞ¸Ä
String dealType =request.getParameter("dealButton");
if (dealType==null){}
else if (dealType.equals("È·ÈÏÐÞ¸Ä")){
String change1=request.getParameter("change"); //´ÓhiddenÖжÁÈ¡
String num1=request.getParameter("num11");
String strSQL="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb);
String sub1=(String) session.getValue("dwnsubject");
byte[] tmpb=sub1.getBytes("ISO8859_1");
sub1=new String(tmpb);
strSQL="update student set times1='" + change1 + "' where ѧºÅ='" + num1 + "' and ¿ÆÄ¿£½'"+sub1+"'";
UserBean.executeUpdate(strSQL);
//ÉèÖÃsessionÓÃÓÚ·µ»ØºóµÄÏÔʾ
// session.putValue("name",name1);
// session.putValue("password",password1);
response.sendRedirect("manage.jsp");
}
////***************ÕâÀï´¦ÀíÐÂÔö
else if (dealType.equals("²éÕÒ")){
String num1=request.getParameter("num").trim();
String strSQL="select * from student where ѧºÅ='" + num1 + "'";
ResultSet rs = UserBean.executeQuery(strSQL);
String name1="";
String code1="";
//String times1="";
String times1 = (String) session.getValue("dwntimes");
byte[] tmpb=times1.getBytes("ISO8859_1");
times1=new String(tmpb); if(rs.next()) { //ÓÐÖظ´
rs=null;
UserBean.closeStmt();
name1=rs.getString("ÐÕÃû");
code1=rs.getString("times1");
rs.close();
session.putValue("num",num1);
response.sendRedirect("change.jsp");
}
response.sendRedirect("manage.jsp");
}
%>
<body>
<script language=javascript>
window.location="change.jsp?showword=Ð޸ijɹ¦"
</script>
</body>
</html>-----说给两百分就给两百,即使系统不让,我也会给大家补上,我是在着急!!!
解决方案 »
- svn版本控制工具能否根据提交人员进行文件查询
- 在TOMCAT环境下 向oracle的blob字段出插入byte[]值,结果执行没有错误,却没有插入任何值,大家帮忙看看
- 请教一个关于session的基础问题
- 作为一个初级软件工程师如何更好的为以后的发展做准备?
- Tomcat突然不能连接MySQL数据库了,不知道到底出了什么问题
- 运行一jsp页面:提示package news does not exist
- jsp连接数据库的小问题,比较菜(在线等)
- 上传图片到数据库的问题!
- 求各位前辈指点
- 做JSP只用resin+mysql行不行?
- 我怎样才能实现我的循环?
- ****太奇怪的问题!****我的最后30分奉上!虽有点少!但我有诚意!
这时弹出一消息框说:51行缺少对象,再点说12行缺少对象,没指明是那页,然后出现如下错误:D:\\JRun\\servers\\default\\default-app\\wangzhan\\do_change.jsp:21:
D:\\JRun\\servers\\default\\default-app\\wangzhan\\do_change.jsp:22:
D:\\JRun\\servers\\default\\default-app\\wangzhan\\do_change.jsp:22: Syntax: ; expected instead of this token
D:\\JRun\\servers\\default\\default-app\\wangzhan\\do_change.jsp:22: Syntax: ; expected instead of this tokenallaire.jrun.scripting.DefaultCFE:
Errors reported by compiler:d:/JRun/servers/default/default-app/WEB-INF/jsp/jrun__wangzhan__do_change2ejsp1b.java:65:69:65:71:
Lexical: String constant not properly terminated
d:/JRun/servers/default/default-app/WEB-INF/jsp/jrun__wangzhan__do_change2ejsp1b.java:66:27:66:28:
Lexical: String constant not properly terminated
d:/JRun/servers/default/default-app/WEB-INF/jsp/jrun__wangzhan__do_change2ejsp1b.java:66:16:66:20: Syntax: ; expected instead of this token
d:/JRun/servers/default/default-app/WEB-INF/jsp/jrun__wangzhan__do_change2ejsp1b.java:66:27:66:28: Syntax: ; expected instead of this token
我找不出那错,只好请教大家,希望你耐心点,不知道你是那里人,方便的话,我请你一顿饭(100元)以上.
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
rs=null;
UserBean.closeStmt();
}
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}
改成
if(rs.next()) {
name1=rs.getString("ÐÕÃû");
num1=rs.getString("ѧºÅ");
code1=rs.getString(times1);
rs=null;
UserBean.closeStmt();
session.putValue("name",name1);
session.putValue("num",num1);
session.putValue("code",code1);
response.sendRedirect("change.jsp");
}应该是你的if和else if相配对的花括号没有匹配导致的
这个dealButtonClick函数里面的参数你在检查一下吧
CSDN有你这种人真是不幸。
rosmada(嘿嘿)这小子,自己不好好调程序,来这里帖如此之多的代码。
拜托!贴出错误所在的代码好不好???精练一点好不好?
你有必要看一下这篇文章“提问的智慧”
明明菜的要死,还这么狂!
小心每个人都会骂你!
这样的态度永远学不好编程!!!!!!!!!!