基于java的学生信息管理系统代码（SQLServer版）

悠悠 2023-10-11 20:19 12阅读 0赞

源码编号：F-A18

项目类型：Java SE项目（awt+swing）

项目名称：学生信息管理系统（StudentSystemInfo)

用户类型：有学生、管理员

主要技术：java、awt、swing等技术

开发工具：Eclipse

运行工具：Eclipse/MyEclipse/IDEA都可以，Eclipse最兼容

数 据 库：SQLServer

数据库表数量：1张表

视图数量：5个左右

项目简介：本系统主要有对学生信息的增删改查、注册等作功能。

**项目内容**

![6a76b7d7c886a5f139f46e1c99660a41.png][]

package com.chinasoft.dao;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Vector;
    
    import com.chinasoft.model.dbfactory.DBFactory;
    import com.chinasoft.model.entity.Manage;
    
    public class SelectAdmin_c {
    	private static List<Manage> list=new ArrayList<Manage>();
    	private static Connection conn=null;
    	public static List<Manage> selectAdmin_c(String uname,String psw) {		
    		conn=DBFactory.getInstance();
    		if(conn==null){
    			conn=DBFactory.getInstance();
    		}
    		PreparedStatement pStatement=null;
    		ResultSet rs=null;
    		String sql="select * from Manage where Manage_num=? and Manage_psw=?";
    		try {
    			pStatement=conn.prepareStatement(sql);
    			pStatement.setString(1, uname);
    			pStatement.setString(2, psw);
    			rs=pStatement.executeQuery();
    			while (rs.next()) {
    				Manage manage=new Manage();
    				manage.setManageId(rs.getInt("Manage_id"));
    				manage.setManageName(rs.getString("Manage_name"));
    				manage.setManageSex(rs.getString("Manage_sex"));
    				manage.setManageNum(rs.getString("Manage_num"));
    				manage.setManagePsw(rs.getString("Manage_psw"));
    				manage.setManagePer(rs.getString("Manage_per"));
    				list.add(manage);
    			}
    			
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    //		try {
    //			conn.close();
    //		} catch (SQLException e) {
    //			// TODO Auto-generated catch block
    //			e.printStackTrace();
    //		}
    		
    		return list;
    	}
    	
    	
    	
    	
    	
    }

登录代码

package com.chinasoft.dao;
    
    import java.awt.Container;
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.List;
    
    import javax.swing.JOptionPane;
    
    import com.chinasoft.model.dbfactory.DBFactory;
    import com.chinasoft.view.Admin_c.MainAdmin_c;
    import com.chinasoft.view.Admin_p.MainAdmin_p;
    import com.chinasoft.view.student.student;
    import com.chinasoft.view.teacher.Teacher;
    
    
    public class loginCheck {
    	public loginCheck(){}
    	
    
    	private static loginCheck loginCheck;
    
    	static {
    		loginCheck = new loginCheck();
    	}
    
    	public static loginCheck getInstance() {
    		return loginCheck;
    	}
    	public List check(String uname,String pwd,String juese) {
    		List list =new ArrayList();
    		Connection conn=DBFactory.getInstance();
    		PreparedStatement pStatement=null;
    		ResultSet rs=null;
    		if(juese.equals("学生")){
    			String sql="select * from Student where stu_id=? and stu_psw=?";	
    			try {
    				pStatement=conn.prepareStatement(sql);
    				pStatement.setString(1, uname);
    				pStatement.setString(2, pwd);
    				rs=pStatement.executeQuery();
    				if(rs.next()==true){
    					list.add(true);
    					return list;
    				}
    				
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    			
    		}else if(juese.equals("教师")){
    			String sql="select * from Teacher where Tea_id=? and Tea_psw=?";
    			
    			try {
    				pStatement=conn.prepareStatement(sql);
    				pStatement.setString(1, uname);
    				pStatement.setString(2, pwd);
    				rs=pStatement.executeQuery();
    				if(rs.next()==true){
    					list.add(true);
    					return list;
    				}
    				
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    		}else{
    			String sql="select Manage_per from Manage where Manage_num=? and Manage_psw=?";
    			
    			try {
    				pStatement=conn.prepareStatement(sql);
    				pStatement.setString(1, uname);
    				pStatement.setString(2, pwd);
    				rs=pStatement.executeQuery();
    				String str="";
    				while(rs.next()){
    					list.add(true);
    					list.add(rs.getString("Manage_per"));
    					return list;
    				}
    				if(rs.next()==true){
    					
    				}
    				
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    		}
    		try {
    			conn.close();
    			pStatement.close();
    			rs.close();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return list;			
    	}
    	
    	
    }

[6a76b7d7c886a5f139f46e1c99660a41.png]: https://img-blog.csdnimg.cn/img_convert/6a76b7d7c886a5f139f46e1c99660a41.png