logindao.java

用Java实现学生成绩管理系统的crud功能

package cn.com.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class LoginDao {
	public boolean stuLogin(String name,String pwd)
	{
		Connection con=null;
	    Statement stmt=null;
	    ResultSet rs=null;
	    boolean flag=false;
	    
	     con = ConManager.getConnection();
	     try {
			stmt = con.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			rs = stmt.executeQuery("select * from student ");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			while (rs.next())
			{
				String n=rs.getString(2);
				String i=rs.getString(3);
				if(name.equals(n)&&pwd.equals(i))
				{
					flag=true;break;
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return flag;
		
	}

}