书签 分享 收藏 举报 版权申诉 / 43

类型javaweb学生信息管理系统精品.docx

  • 文档编号:11380004
  • 上传时间:2023-02-28
  • 格式:DOCX
  • 页数:43
  • 大小:29.31KB

密码:

forward.jsp:

<%@pagelanguage="java"contentType="text/html;charset=gb2312"

pageEncoding="gb2312"%>

DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:

//www.w3.org/TR/html4/loose.dtd">

loginforward

<%

Stringusername=null;

Stringpassword=null;

request.setCharacterEncoding("gb2312");

response.setContentType("text/html;charset=gb2312");

username=request.getParameter("username");

password=request.getParameter("password");

if(!

username.equals("")&&!

password.equals(""))

{

%>

forwardpage="login_ok.jsp">

paramname="username"value='<%=username%>'/>

paramname="username"value='<%=password%>'/>

forward>

<%

}

else

{

%>

forwardpage="error.jsp">

paramname="username"value='<%=username%>'/>

paramname="username"value='<%=password%>'/>

forward>

<%

}

%>

login_ok.jsp:

<%@pagelanguage="java"contentType="text/html;charset=gb2312"

pageEncoding="gb2312"%>

DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:

//www.w3.org/TR/html4/loose.dtd">

Inserttitlehere

input{

color:

red;

font-size:

12pt;

}

欢迎您使用学生管理系统


<%

Stringusername=null;

Stringpassword=null;

request.setCharacterEncoding("gb2312");

response.setContentType("text/html;charset=gb2312");

username=request.getParameter("username");

password=request.getParameter("password");

out.println("登陆成功,用户名["+username+"],");

out.println("密码["+password+"]");

%>


请选择您要进行的操作:

 

error.jsp:

<%@pagelanguage="java"contentType="text/html;charset=gb2312"

pageEncoding="gb2312"%>

DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:

//www.w3.org/TR/html4/loose.dtd">

Error

欢迎您使用学生管理系统

<%

Stringusername=null;

Stringpassword=null;

request.setCharacterEncoding("gb2312");

response.setContentType("text/html;charset=gb2312");

username=request.getParameter("username");

password=request.getParameter("password");

out.println("您输入的用户名["+username+"],");

out.println("和密码["+password+"]有一项为空,请重新输入:

");

%>

---返回重新登陆---

 

学生信息增加模块:

p_zeng.html:

<%@pagelanguage="java"contentType="text/html;charset=gb2312"

pageEncoding="gb2312"%>

DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:

//www.w3.org/TR/html4/loose.dtd">

Inserttitlehere

input{

color:

red;

font-size:

12pt;

}

欢迎您使用学生管理系统


<%

Stringusername=null;

Stringpassword=null;

request.setCharacterEncoding("gb2312");

response.setContentType("text/html;charset=gb2312");

username=request.getParameter("username");

password=request.getParameter("password");

out.println("登陆成功,用户名["+username+"],");

out.println("密码["+password+"]");

%>


请选择您要进行的操作:

 

zeng.jsp:

<%@pagelanguage="java"contentType="text/html;charset=gb2312"

pageEncoding="gb2312"import="java.sql.*"%>

DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:

//www.w3.org/TR/html4/loose.dtd">

callstoredprocedure

<%

intPAGESIZE=3;

intpageCount=0;

intcurPage=1;

java.sql.Connectionconn=null;

PreparedStatementpstmt=null;

Statementstmt=null;

ResultSetrs=null;

String[]cloStr={"sno","sname","cclass","sex","age","nation","clname","place"};

String[]showStr={"学生编号","学生姓名","所在年级","性别","年龄","民族","专业","住址"};

Stringsno,sname,cclass,sex,age,nation,clname,place;

StringstrURL="jdbc:

mysql:

//localhost/test";

StringstrDBUser="root";

StringstrDBPwd="123";

try

{

Class.forName("com.mysql.jdbc.Driver");

conn=java.sql.DriverManager.getConnection(strURL,strDBUser,strDBPwd);

}

catch(ClassNotFoundExceptione)

{

e.printStackTrace();

out.println("您输入的信息有误,请查证后再重新输入!

");

}

catch(Exceptionex)

{

ex.printStackTrace();

out.println("您输入的信息有误,请查证后再重新输入!

");

}

try{

sno=request.getParameter("sno");

byteno[]=sno.getBytes("ISO-8859-1");

sno=newString(no);

sname=request.getParameter("sname");

bytename[]=sname.getBytes("ISO-8859-1");

sname=newString(name,"gb2312");

cclass=request.getParameter("cclass");

byteclss[]=cclass.getBytes("ISO-8859-1");

cclass=newString(clss,"gb2312");

sex=request.getParameter("sex");

byteex[]=sex.getBytes("ISO-8859-1");

sex=newString(ex,"gb2312");

age=request.getParameter("age");

bytege[]=age.getBytes("ISO-8859-1");

age=newString(ge);

nation=request.getParameter("nation");

bytetion[]=nation.getBytes("ISO-8859-1");

nation=newString(tion,"gb2312");

clname=request.getParameter("clname");

bytecname[]=clname.getBytes("ISO-8859-1");

clname=newString(cname,"gb2312");

place=request.getParameter("place");

bytelace[]=place.getBytes("ISO-8859-1");

place=newString(lace,"gb2312");

Stringsqlll="insertintoS(sno,sname,cclass,sex,age,nation,clname,place)values('"+sno+"','"+sname+"','"+cclass+"','"+sex+"','"+age+"','"+nation+"','"+clname+"','"+place+"')";

pstmt=conn.prepareStatement(sqlll);

intcount3=pstmt.executeUpdate();//插入

Stringsqllll="select*fromS";

stmt=conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

rs=stmt.executeQuery(sqllll);

rs.last();

intsize=rs.getRow();

pageCount=(size%PAGESIZE==0)?

(size/PAGESIZE):

(size/PAGESIZE+1);

}

catch(Exceptionex)

{

ex.printStackTrace();

out.println("您输入的信息有误,请查证后再重新输入!

");

}

//获取想要显示的页数:

Stringinteger=request.getParameter("curPage");

if(integer==null)

{

integer="1";

}

try{

curPage=Integer.parseInt(integer);

}

catch(NumberFormatExceptione)

{curPage=1;

}

if(curPage<=1)

{

curPage=1;

}

if(curPage>=pageCount)

{

curPage=pageCount;

}

//如果要显示第curPage页,那么游标应移到posion的值是:

intposion=(curPage-1)*PAGESIZE+1;

rs.absolute(posion);//设置游标的位置

%>


<%

for(inti=0;i

{

out.println("");

out.println(""+showStr[i]+"

");

}

%>

<%

intcount=0;

do{

if(count>=PAGESIZE)

break;

out.println("");

for(inti=0;i

{

out.println("");

out.println(""+rs.getString(cloStr[i])+"

");

}

out.println("");

count++;

}while(rs.next());

%>

curPage=1">首页

curPage=<%=curPage-1%>">上一页

curPage=<%=curPage+1%>">下一页

curPage=<%=pageCount%>">尾页

举报
举报
版权申诉
版权申诉
word格式文档无特别注明外均可编辑修改;预览文档经过压缩,下载后原文更清晰! 立即下载
配套讲稿:

如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。

特殊限制:

部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。

关 键  词:
javaweb 学生 信息管理 系统 精品
提示  冰豆网所有资源均是用户自行上传分享,仅供网友学习交流,未经上传用户书面授权,请勿作他用。
关于本文
本文标题:javaweb学生信息管理系统精品.docx
链接地址:https://www.bdocx.com/doc/11380004.html
关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服 - 联系我们

copyright@ 2008-2022 冰点文档网站版权所有

经营许可证编号:鄂ICP备2022015515号-1

收起
展开