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

源码编号：F-A18  

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

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

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

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

开发工具：Eclipse

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

数  据  库：SQLServer

数据库表数量：1张表

视图数量：5个左右

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

项目内容

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;			
	}
	
	
}