jsp输入java程序信息,jsp、javabean学生信息管理系统

用jsp、javabean做了一个学生信息管理系统，虽然j2ee的框架很多，但是基础仍然很重要。麻雀虽小五脏俱全，希望本博客对j2ee初学者有帮助，也是对自己知识的复习和整合。

系统预览：

管理员登录界面

录入信息界面

管理界面

修改学生信息

核心代码

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

验证用户名和密码

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信息返回到首页，不能直接查看。

退出时移出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;

}

}