data.java

图书信息管理系统

package com;

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

import com.bean.LoginBean;
import com.bean.BookBean;


public class data {
	
	/*
	 * 鐧诲綍淇℃伅楠岃瘉
	 * */
public String LoginCheck(Connection con,String loginName,String pwd){
		
		String type = "";
		String sql = "";	
		ResultSet rs = null;
		Statement stmt = null;		
		try{		
			stmt = con.createStatement();
			sql = "select * from  admin,master "+
					"where loginName = '"+loginName+"' and "+
					"loginPwd='"+pwd+"' and admin.mid = master.mid";				
			rs =stmt.executeQuery(sql);			
			if(rs.next()){
				type = rs.getString("name");
			}else{
				type = "error";
			}	
			rs.close();
			stmt.close();
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		return type;
	}
/*
 * 鐢ㄦ埛淇℃伅琛ㄦ煡璇