简单的学生信息管理系统(3)

来源：网络收集时间：2026-07-22

导读： Connection con = kkk.getConnection(); Statement statement = con.createStatement(); ResultSetrs = statement.executeQuery(sql); st(); user[] user2 = new user[rs.getRow()]; rs.beforeFirst(); inti = 0; w

Connection con = kkk.getConnection();

Statement statement = con.createStatement();

ResultSetrs = statement.executeQuery(sql);

st();

user[] user2 = new user[rs.getRow()];

rs.beforeFirst();

inti = 0;

while (rs.next()) {

user2[i] = new user(rs.getString("name"), rs.getString("password")); i = i + 1;

}

rs.close();

statement.close();

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

con.close();

return user2;

}

//学生信息查询

public student[] QueryStu(String sql) throws SQLException, ClassNotFoundException {

JDBCConnectionkkk = new JDBCConnection();

kkk.setTableName("student");

Connection con = kkk.getConnection();

Statement statement = con.createStatement();

ResultSet rs1 = statement.executeQuery(sql);

st();

student[] stu=new student[rs1.getRow()];

rs1.beforeFirst();

inti=0;

while(rs1.next())

{

stu[i]=new

student(rs1.getString("number"),rs1.getString("name"),rs1.getString("email")); i+=1;

}

rs1.close();

statement.close();

con.close();

returnstu;

}

//数据添加类

Insert.jsp

<html>

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

{ <title>My JSP 'insert.jsp' starting page</title> <script type="text/javascript"> functionvalidate2()

varNumber=document.forms["form4"].number.value;

varName=document.forms["form4"].name.value;

varEmail=document.forms["form4"].email.value;

if(Number.length<=0)

{

alert("学号不能为空！");

}

else if(Name<=0)

{

alert("名字不能为空！");

}

else if(Email<=0)

{

alert("email不能为空！")

}

else

{

document.forms["form4"].submit();

}

</script>

<body background="img/5.jpg"> <br> <br> <center> <h3>学生信息添加</h3> <form action="Insert" method="post" name="form4"> <table width="228" height="112"> <tr> <td> 学号 </td> <td> <input type="text" name="number" /> </head>

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

</tr> <tr> <td> 姓名 </td> <td> <input type="text" name="name" /> </td> </tr> <tr> <td> email </td> <td> <input type="text" name="email" /> </td> </tr> </table>

<p><input type="button" value="提交"

onClick="validate2()"/>  

</html>

//insert.java servlet do post()

publicvoiddoPost(HttpServletRequest request, HttpServletResponse response)

throwsServletException, IOException { request.setCharacterEncoding("GB2312"); String number=request.getParameter("number"); String name=request.getParameter("name"); String email=request.getParameter("email"); studentst=new student(number,name,email); try { st.getValue(); // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) {

jsp中简单的学生管理系统,可以基本实现对数据库的增删查改

} request.setAttribute("ok","添加成功！"); // TODO Auto-generated catch block e.printStackTrace(); request.getRequestDispatcher("insert.jsp").forward(request,response); }

//数据修改

Update.jsp

<html>

<body background="img/5.jpg"> <center> <br> <br> <h2> 请选择要修改的学生 </h2> <br> <br> <% %>

String sql = "select * from student"; query q = new query(); studentstu[] = q.QueryStu(sql); <head> <title>My JSP 'update.jsp' starting page</title> </head>

…… 此处隐藏：766字，全部文档内容请下载后查看。喜欢就下载吧 ……

简单的学生信息管理系统(3).doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/wenku/127391.html（转载请注明文章来源）

上一篇：学校安全工作述职报告
下一篇：住宅楼(混合)施工组织设计