Javabean+sql+jsp的简易学生信息管理系统

javabean+sql+jsp建立的简易管理系统

简易系统，并不完善，供学习使用

user.java

package com.fanchen.model;

public class User {
private String id;
private String name;
private int age;

public  String getId() {
    return id;
}

public void setId(String id) {
    this.id = id;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public  int getAge() {

    return age;
}

public void setAge(int age) {
    this.age = age;
}

}

userDao.java`

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class userDao implements Dao{
//添加
public void add(User user){
jdbcutil n = new jdbcutil();
Connection conn = jdbcutil.getConnection();
System.out.println(conn);
String sql = “insert into User(id,name,age) value(?,?,?)”;
try {
PreparedStatement pstmt =conn.prepareStatement(sql);
pstmt.setString(1,user.getId());
pstmt.setString(2,user.getName());
pstmt.setInt(3,user.getAge());
pstmt.executeUpdate();
}catch(SQLException e)
{
e.printStackTrace();
}
}
//修改
public void update(User user) {
Connection conn = jdbcutil.getConnection();//连接完成
User u = null;
String sql = “update tb_ceshi set id=?,name =?,age =?”;
u = new User();
try {
PreparedStatement pstmt = conn.prepareStatement(sql);

        pstmt.setString(2, u.getName());
        pstmt.setInt(3, u.getAge());
        pstmt.setString(1, u.getId());

    } catch (SQLException e) {
        e.printStackTrace();
    }
}

//按照id删除
public void deletebyid(String id) {
    Connection conn = jdbcutil.getConnection();
    String sql = "delete from tb_ceshi where id=?";
    try {
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, id);
        pstmt.executeLargeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }


}


//按照id查询
public User finduserbyid(String id) {
    Connection conn = jdbcutil.getConnection();
    User u = null;
    String sql = "select * from tb_ceshi where id=?";


    try {
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, id);
        ResultSet rs = pstmt.executeQuery();
        if (rs.next()) {
            u = new User();

            u.setName(rs.getString("name"));
            u.setId(rs.getString("id"));
            u.setAge(rs.getInt("age"));
        }

    } catch (SQLException e) {
        e.printStackTrace();
    }
    return u;
}

//显示所有记录
public List<User> Queryall() {
    List<User> list = new ArrayList();
    User a = null;
    Connection conn = jdbcutil.getConnection();
    String sql = "select * from tb_ceshi";
    try {
        Statement quan = conn.createStatement();

        ResultSet rs = quan.executeQuery(sql);

        while (rs.next()) {
            a = new User();
            a.setId(rs.getString("id"));
            a.setName(rs.getString("name"));
            a.setAge(rs.getInt("age"));
            list.add(a);
        }
        rs.close();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        jdbcutil.closedb(conn);
    }
    return list;
}

}`

jdbcUnit.java

package com.fanchen.model;

import java.sql.*;

public class jdbcutil {
   
    private  static  Connection conn = null;
    private  static PreparedStatement pstmt = null;
    private  static ResultSet rs = null;

    public static Connection getConnection() {
   
        try {
   
            Class.forName