package database;

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

import javax.swing.JOptionPane;

public class Adduser {

	public static Boolean adduser(String user, String studentid, String name, String password) {

		Connection con = ConnectDatabase.connectDB();

		PreparedStatement preSql;

		String sqlStr=null;
		
		if(userlist()) {
			sqlStr = "insert into usertable values (?,?,?,?,0)";
		}else {
			sqlStr = "insert into usertable values (?,?,?,?,1)";
		}

		try {
			preSql = con.prepareStatement(sqlStr);
			preSql.setString(1, user);
			preSql.setString(2, studentid);
			preSql.setString(3, name);
			preSql.setString(4, password);
			int ok = preSql.executeUpdate();
			con.close();
			return true;
		} catch (SQLException e) {
			JOptionPane.showMessageDialog(null, "用户名已存在", "警告", JOptionPane.WARNING_MESSAGE);
			return false;
		}
	}
	
	//判断用户是否存在
	public static boolean userlist() {
		Connection con = ConnectDatabase.connectDB();

		PreparedStatement preSql;

		ResultSet rs;

		String sqlStr = "select * from usertable";
		try {
			preSql = con.prepareStatement(sqlStr);
			rs = preSql.executeQuery();
			boolean flag = false;
			while(rs.next()) {
				flag = true;
				return true;
			}
			if(!flag) {
				return false;
			}
			con.close();
			return false;
		} catch (SQLException e) {
			return false;
		}
	}
}