用jsp、javabean做了一个学生信息管理系统，虽然j2ee的框架很多，但是基础仍然很重要。麻雀虽小五脏俱全，希望本博客对j2ee初学者有帮助，也是对自己知识的复习和整合。
系统预览：
管理员登录界面
录入信息界面
管理界面
修改学生信息
系统比较简单，有增删改查四个基本功能。
源码下载地址：[学生信息管理系统源码]
(http://download.csdn.net/detail/napoay/9411126)
核心代码
jdbc连接数据库
package cn.ac.ucas.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conn {
public Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1/student?useUicode=true&characterEncoding=utf-8";
String user="root";
String password="123456";
conn=DriverManager.getConnection(url, user, password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return conn;
}
}
管理员登陆
在数据库中有一张user表，有用户名和密码两个字段，登录时将用户输入的用户名和密码和数据库中的管理员毕竟，用户名和密码输入正确登录成功。
login.jsp
<jsp:useBean id="user" class="cn.ac.ucas.model.User"></jsp:useBean>
<jsp:useBean id="userservice" class="cn.ac.ucas.service.UserService"></jsp:useBean>
<jsp:setProperty property="*" name="user" />
<%
if (userservice.validUser(user)) {
session.setAttribute("user", user);
%>
<jsp:forward page="main.jsp"></jsp:forward>
<%
} else {
%>
<jsp:forward page="index.jsp"></jsp:forward>
<%
}
%>验证用户名和密码
public boolean validUser(User user) {
try {
pstmt = conn.prepareStatement("select * from user where username=?and password=?");
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
ResultSet rst = pstmt.executeQuery();
if (rst.next()) {
return true;
} else {
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}使用session
用户名和密码输入正确的时候把user放到seesion中：
session.setAttribute("user", user);用户名和密码输入不正确不能之间访问登录后的页面，不然用户直接输入地址就可以访问到管理页面，登录和不登录没有区别。下面试checklogin.jsp，需要登录后访问的页面使用jsp:include包含在内，这样如果session中没有user信息返回到首页，不能直接查看。
<%@page import="cn.ac.ucas.model.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
User user= (User)session.getAttribute("user");
if(user==null){
%>
<jsp:forward page="index.jsp"></jsp:forward>
<%
}
%>退出时移出session
session.removeAttribute("user");增
public boolean addStu(Student student) {
try {
pstmt = conn.prepareStatement(
"insert into Student(nickname,name,gender,birth,majority,course,interest,otherinfo)"
+ "values(?,?,?,?,?,?,?,?)");
pstmt.setString(1, student.getNickname());
pstmt.setString(2, student.getName());
pstmt.setByte(3, student.getGender());
pstmt.setString(4, student.getBirth());
pstmt.setString(5, student.getMajority());
pstmt.setString(6, student.getCourses());
pstmt.setString(7, student.getInterests());
pstmt.setString(8, student.getOtherinfo());
pstmt.executeUpdate();
return true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}删
public boolean deleteStu(int id) {
try {
pstmt = conn.prepareStatement("delete from Student where id=?");
pstmt.setInt(1, id);
pstmt.executeUpdate();
return true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}改
public boolean updateStu(Student student){
try {
pstmt=conn.prepareStatement("update Student set nickname=?,name=?,gender=?,birth=?,majority=?,course=?,interest=?,otherinfo=? where id=?");
pstmt.setString(1, student.getNickname());
pstmt.setString(2, student.getName());
pstmt.setByte(3, student.getGender());
pstmt.setString(4, student.getBirth());
pstmt.setString(5, student.getMajority());
pstmt.setString(6, student.getCourses());
pstmt.setString(7, student.getInterests());
pstmt.setString(8, student.getOtherinfo());
pstmt.setInt(9, student.getId());
pstmt.executeUpdate();
return true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}查
查询所有学生信息
public List getAllStudent() {
List stuList = new ArrayList();
try {
pstmt = conn.prepareStatement("select * from Student");
ResultSet rst = pstmt.executeQuery();
while (rst.next()) {
Student stu = new Student();
stu.setId(rst.getInt(1));
stu.setNickname(rst.getString(2));
stu.setName(rst.getString(3));
stu.setGender(rst.getByte(4));
stu.setBirth(rst.getString(5));
stu.setMajority(rst.getString(6));
if (rst.getString(7) != null) {
stu.setCourse(rst.getString(7).split("&&"));
}
if (rst.getString(8) != null) {
stu.setInterest(rst.getString(8).split("&&"));
}
stu.setOtherinfo(rst.getString(9));
stuList.add(stu);
}
return stuList;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}查询单个学生信息
public Student getStuById(int id) {
try {
pstmt = conn.prepareStatement("select * from Student where id = ?");
pstmt.setInt(1, id);
ResultSet rst = pstmt.executeQuery();
if(rst.next()){
Student stu=new Student();
stu.setId(rst.getInt(1));
stu.setNickname(rst.getString(2));
stu.setName(rst.getString(3));
stu.setGender(rst.getByte(4));
stu.setBirth(rst.getString(5));
stu.setMajority(rst.getString(6));
if (rst.getString(7) != null) {
stu.setCourse(rst.getString(7).split("&&"));
}
if (rst.getString(8) != null) {
stu.setInterest(rst.getString(8).split("&&"));
}
stu.setOtherinfo(rst.getString(9));
return stu;
}
return null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
