员工编号总共6位，由字母XD+4位数字编号组成（如XD0001） * 必须唯一，在新增时自动生成，数字编号自动增长。在修改时，员工编号无法修改。

public String getEmployeeid() {
Connection con = new JDBCUtil().getConnection();
String id = null;
String sql = "select * from employeebasicinfo order by employeeid desc limit 1";
PreparedStatement pstOne = null;
ResultSet rs = null;
try {
pstOne = con.prepareStatement(sql);
rs = pstOne.executeQuery();

if (rs.next()) {
String a = rs.getString("employeeid");
int idnum = 0;