myeclipse tomcat mysql_Myeclipse+tomcat+mysql，B/S实现学生信息的增删改查(实现篇)

小生第一次用Myeclipse和Mysql做东西，边学边做，处处遇到问题，然后自己搜资料和分析去解决

测试通过！

工程文件目录

index.jsp

String path = request.getContextPath();

String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";

%>

My JSP 'index.jsp' starting page

点此添加学生信息

点此查询学生信息

点此修改学生信息

点此删除学生信息

showInfo.jsp

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'showInfo.jsp' starting page

response.setCharacterEncoding("UTF-8");

request.setCharacterEncoding("UTF-8");

String id = request.getParameter("id");

String name = request.getParameter("name");

String age = request.getParameter("age");

String gender = request.getParameter("gender");

String major = request.getParameter("major");

Connection conn = null;

Statement stat = null;

ResultSet rs = null;

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

String url = "jdbc:mysql://localhost:3306/jsp";

String user = "root";

String password = "123456";

conn = DriverManager.getConnection(url,user,password);

stat = conn.createStatement();

rs = stat.executeQuery("select * from student");

%>

学生信息

---

全部学生信息如下

学号

姓名

年龄

性别

专业

while(rs.next())

{

out.print("

");

out.print("

" + rs.getInt("id") + "");

out.print("

" + rs.getString("name") + "");

out.print("

" + rs.getInt("age") + "");

out.print("

" + rs.getString("gender") + "");

out.print("

" + rs.getString("major") + "");

%>

">删除 ">修改

out.print("

");

}

%>

按学号查询:

按姓名查询:

按年龄查询:

按性别查询:

按专业查询:

返回添加学生信息页面

if(rs != null)

{

rs.close();

rs = null;

}

if(stat != null)

{

stat.close();

stat = null;

}

if(conn != null)

{

conn.close();

conn = null;

}

%>

insert.jsp

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'insert.jsp' starting page

reques